Recent content by llkhoutx

I burned (in multiple sessions) a 650MB, 74 Min CD-RW CD which was and is readable on other Win 98/ME/2000 PCs. I add new folders and files to it from time to time. My burner is an external "HP cd-writer 8200." The CD in question is a Sony 1X2X4 rewritable CD. I've tried to read...

My Problem: I need to export graphs generated charts in MS Access to MS Word, but can't find anything about how to do it. Of course "cut & paste" to MS Paint works, but is not satisfactory for my application. My questions to the forum are: 1. Is anyone familir with how to do it? 2. Is...

Use a Crosstab query result as the recordsource for another query.

checkout TransferText in the Help menu

Use the format and decimal places properties for your table field.

You may have multiple copies of the database open. Maybe it is linked to another mdb which is open.

Buy Litwin's Access 97 Developer's Handbook (by Sybex). Use the wizard to build various types of objects, then emulate them.

Even with grouping, if your group fills up a page and runs over, you still have no header on successor pages. Can you build your field header into the page header? I commonly do this, even with multiple line headers.

A make table query deletes the old table before the (new) table is created. Worry about formating at display or use time, not when the data is stored. When displayed or used it can be formatted if and as necessary.

I've seen a post that say use [FieldName]+1 to get to the next record, if this is true, I suppose that [FieldName]-1 would get you the previous record. Personally, I would use a recordset of the table, loop through it with DAO code, always keeping the previous value of a particular field...

Try instr(), left(), right() - see Help menu for these functions.

Your mdb should be stored on a Server(file or folder) that Users are only generally aware of and only have read access (no pun intended) to. That mdb is then copied to each Users harddrive from which it's ececuted, alternatively, each user has a batch file with does the copying at StartUp and...

An overwrite is an Update not an Append. Link the table you want to overwrite to your acctive database and build an Update query.

Litwin's Access 97 Developer's Handbook at page 1136 has a solution.

Once you set the margins for a report in Access, they are set, regardless of the margins in other reports. If you think that you need to set the margin every time you open a report, use Sendkeys (see the Help menu)