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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.