Search results for query: *

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)

Check TransferText in the Access Help menu, that's what you want.

Build a query with the correct field, then use that query as the recordsource for your combo box. Youn can have any number of fields displayed in the combo box drop list.

Trap your strSQL when it's finally built utilizing a breakpoint and put in the QBE SQL frame to see if it will execute. Alternatively, build your query in the QBE frame, test until it executes properly, and then look at the SQL gerenated for that query. compare it to your original code and make...

First put a field in your query to select the first 2 characters of the field: Expr1:left(Article,2) with a criteria of "tx" then add another field in Expr2: right(Article,len(Article)-2) - this allows for the right most portion of Article to be other that a fixed length.

Look at "TransferText" in the Access help menu.