Search results for query: *

That did it. I wasn't listing the destination DB correctly and you helped that. Many Thanks Terry (heehaw)

Looking a line of code that would enable a user from inside of Access to move a file to the Floppy Drive that is contained outside of Access on the C: Example: User needs to move a flie to the floppy drive and by clicking a button, a file is copied to the A: The file would be on the C: and...

Thanks. That was kind of what I was looking for and enough of a clue to write it myself. I did and it worked. Now I will expand on that. Heehaw

Want to do a QBF (query by form) for data in a SQL Server. Using Access (project) as the frontend and SQL7 as the db. In Old Access I used to write Like Forms!SearchForm!SearchField & "*" Or Forms!SearchForm!SearchField Is Null This was written in several query fields and using an...

Does your network backup from time to time? If the DB is open, then it can be hurt (corrupted) and sometimes, hurt really bad. We have a DB that is near 1G with 30 users and it works great. But we had a similar problem and ours was caused by the Novel and NT Servers backing up when the DB was...

Northwind sample DB has validate macro that will do exactly what you want heehaw

This probably won't help, but we had a similiar problem. Thought it was memory, but it was determined that a network card had fried and was not releasing the Database when the application was closed. Wierd. New networking card fixed our problem, but I remember it had the look of a memory...

Hope this is the right area to post this thread. This is report problem that I am having trouble with. I have a header and footer with data and form lines. The detail section is where the problem lies. This area can print three records to fill the area and then it forces a new page...

Been there, done that. In the long run, you are better off starting from scratch and the end product will be much better. JUST a suggestion. Using your security file, make a blank .mdb file (database) Import all the objects including the menus and MAKE SURE THE DATABASE IS LINKED TO...

This code works fine in Access and VBA, however, in an Access Project connected to SQL 7 it errors on the DCount line. I'm stumped and need help or advice why this errors. The code is designed to select a specific record from a list box and show it to the user. Any help is appreciated. Dim...

This code works fine in Access and VBA, however, in an Access Project connected to SQL 7 it errors on the DCount line. I'm stumped and need help of advice why this errors. The code is designed to select a sepecif record from a list box and show it to the user. Any help is appreciated. Dim...