Recent content by brettatexplace

I have started to migrate users from NT4 to Active Directory/WK3 Server. When a user under NT has an Access app open (creating a lock file), and, as a Active Directory user, I also try to open the app - NOTHING HAPPENS! But when I open access, and point to the app through file open, it works...

What is the VBA code to run the Export cmd from the File menu when i have a report on the screen (can I do it all at once?)? I need to loop through a form, calling each line to export that report saved as snapshot file on the network (or word) open form x, start at top loop.. open report...

Try not using any queries. Go into them, and view them as SQL, then copy the line to the DataSource of the form, then delete the query because it will no longer be needed.

You can also turn off the menus in the Tools -> Startup screen. For you to turn them back on, hold down the shift key while starting up the app.

Compile the Access Database as an MDE. Under Tools - Database Utilties - Make MDE File. They will not be able to go into design view of rpts,frms etc.

What's the simplest way to call the MS XP OS to get the User Name or their group into my Access2002 App?

I am using an old MSPress Access97 ref book. Can anyone suggest a newer reference book for Access/VBA Application development? (especially the newer stuff like Web Pages linked to the Access Database)

I have been able to open the report with the filter and, if still open then E-mail it like below, without the report regenerating without the filter... sort of like this... strTitleLine = [lngID] & " Is my person TILTE" ' in the on_open of the rptGOData, set this as the title...

I would check to see if the Regional Setting on both pcs are the same (especially if anything is using dates)

Sorry, it is Access2002

I have a form that displays a record, and it has a "clear" button on it. When the "clear" button is pressed, I wish to secretly copy the entire record to an identically structured database (using VBA), and then clear most fields displayed on the from to null. ie. Everytime the clear button is...

If the query is made from at least two tables, the displayed line may represent a combination of tables, and you will not be able to delete the line (since it is not a single record in a table).

Excellect, worked great. Thanks. (I didn't know weather the last detail would remember what color he was so I could just alternate)

It seems that you are filling a box behind??? My detail sections are not fixed heights, but grow or shrink depending on content. (as per line on page == details that fit on page) I tried it but got something weird.

I have a Detail section that I would like to alternate the background color when it is formated. (from gray to white so that this is used instead of putting a line between each detail) Can anyone suggest how to do VBA on the OnFormat section of the Detail. ie: Detail.BackColor = grey I would...