Getting Started

Formatting field contents
I am new to Access-self taught. I enter >&\"[Red] in the design view to change my information on a table. What came back was. SMITH STREET" in red. How do I use the character formats: ! < > & "text' (space) \ 2 * [color] correctly. I can't find anything that makes since or is simple to understand. Thank yo... 1 Jun 2008 16:05

Running totals in a form
I want to design a small DB to record the monthly municipal costs. I would like to enter the current monthly water and electric meter readings and have the monthly useage calculated and idealy presented in the Form. The more I think about this, the more I think it's a job for Excel. Regards Gareth ... 2 Jun 2008 04:35

Can I have a tickbox toggle a Byte Field from 1 to 0 ?
I want to use a Tick Box to toggle a Byte field on and off on a form - the Form is already displaying data from a Table ('Control') - the field is 'Preview' and is a Byte Field - I don't really want to change the type of Field in the Table itself. As a side point - my Control Table is a 'one record' table cont... 1 Jun 2008 12:57

microsoft update error code 0x80072ee7
I have a USED XP media center edition, (2005 I think.) bought second hand anyway, every time I visit the microsoft website I get this error code (0x80072EE7). I cannot update or download anything from Microsoft. also I can't download adobe flashplayer. Any help that any of you good folks could give me would be ... 1 Jun 2008 08:15

form design
i have successfully created a dragndrop form with 2 tables.ican drag one item to the other and reverse it! i now want to create another form and select 4names from the second table to go into seperate boxes headed skip,lead,second,third and retain this info to form a report? can someone please tell me if i should u... 1 Jun 2008 02:34

Local / network options for References?
I've had problems with some users getting "Cannot find project or library_ and I changed the Reference on my machine to look at Microsoft Excel object library 8, as 11 was missing. Loaded a module, and viewed code, then checked Tools->Reference. Browsed for and found this: [ ] Missing Excel Object Library, etc... 1 Jun 2008 15:18

Backup an Access '97 database without having to have Exclusive Access?
In Access 2003, there's a button to backup. However, in 97 I don't see that option. Is there a way to backup the database without having exclusive access? It seems no matter how early I get to work, or how late I stay, there's always someone using it. Thanks for any help. George ... 31 May 2008 14:03

Access '97 will not close
I've got 4 users who have Access '97. When they exit the application I'm responsible for, the application does close, but Access remains running. They have to use Task Manager to close. IT reinstalled Access '97, and my application runs fine, but they have the same problem. Sometimes Access shows up twice on the ... 31 May 2008 14:50

Displaying Information in one Table based on information in an
Great, Thanks Arvin Ray C "Arvin Meyer [MVP]" wrote: As you mentioned, a combo box would be easier, but if you really want to use a textbox: Instead of basing your form directly on a table, base it on a query where the 2 tables are joined on SupplierID. Add the name from the Supplier's tab... 31 May 2008 04:26

Cannot open reports in MsAccess 2003.
"Duane Hookom" <duanehookom(a)NO_SPAMhotmail.com> escribi� en el mensaje de noticias:B7CF05FE-C142-4DD6-A83E-FA19FCA6EEAC(a)microsoft.com... I agree. The initial posting doesn't say anything about the "Default Printer" which is generally the issue. -- Duane Hookom Microsoft Access MVP "Ne... 5 Jun 2008 15:48