Search results for query: *

I have had no luck doing that. There is tho a workaround, develop a Make-Table query that puts in the local database the data you want to use in the Word document. Then tell Word to use the local table as its data source. Frank kegley

What about a macro that does a Find and Replace, it could for instance find all the tabs and replace with ,s. Then it export the worksheet to a text file. Frank kegley

There was something recently that I saw about files with a WMF extension being susceptible to infection. That, I believe is proprietary to Microsoft, so they may have arranged for Hotmail to block opening those kinds of files. Frank kegley

I think Organizer can do this. Open the Word document, then Tools--->Templates And Addins... Organizer. You should be able to then copy the macro from the one it is in now to the one that is open. I am using version 2003, so the menus and commands may be different for you. Frank kegley

Try developing a macro that unprotects the sheet, puts in the outlining, and then reprotects the sheet. Frank kegley

It would be simpler to rename the AutoExec macro. Frank kegley

Use the Control Wizard to put a Save Record button on the form. Have the Print Record disabled until they click the Save Record button. You'll need to modify the code produced by the Wizard to do this: In the Click event of the Save Record button (get the properties of the button, Events...

I would probably uae an AutoNumber field as my primary key. The only reason I wouldn't would be if gaps in the numbering were unacceptable. You will have more gaps with AutoNumber than with other ways. Once you do that, then you can have multiple records with the same ProductID, so I would have...

This sounds like an incomplete or faulty install to me. Have you tried uninstall and reinstall, ensuring a complete install? Frank kegley

Look into Documenter. It will create a report of all the objects in a database. Frank kegley

I too have noticed this in some of my macros. All I can suggest is that you record for the OLDEST version of Excel that you have out there. This may mean keeping several versions of Excel on your development machine. The difference I noted (the only one I remember anyway) was in the Sort...

kim00 the symbol you're trying to get rid of IS the carriage return that you just inserted. It has to be there or there's no way Excel knows to do a CarriageReturn at that point in the text. Frank kegley

What about opening the one she could open, copying the data, closing and opening the other one? The data will stay on the clipboard once it is pasted there. Frank kegley

If the data is coming across a network, I would suspect the network connection. Frank kegley

The DateDiff function can do this. The help files can steer you to the correct syntax much better than I can. Frank kegley fkegley@hotmail.com

Basically, when your database stores data, it stores it in a way such that it can be read by anyone with the specialized software, I believe it is a sector editor, and the time to root thru your hard drive until they find your database data. I have used a text editor that enabled me to root thru...

I think you ought to know that Word does not always do a good job of displaying Access reports. Frank kegley fkegley@hotmail.com

It could. Sometimes the service packs turn out to be disservice packs. Frank kegley fkegley@hotmail.com

WHERE Action <> "Rejected" OR Action <> "Transferred" When you put in this WHERE clause, you forgot that computers do what they are told to do, not what you want them to do. If Action is 'Rejected' then that is not = 'Transferred' and vice versa. That is why you were getting more records than...

You also need to examine the rules regarding which recordsets are updatable and which are not. From Access Help: When can I update data from a query? In some cases, you can edit data in query Datasheet view to change the data in the underlying table. In other cases, you can't. The following...