Search results for query: *

Private Sub Closeform_Click() Hamzagm, Place a button control on your form then right click on it and select build event. Cut and paste the following code: ______ On Error GoTo Err_closeform_Click DoCmd.DoMenuItem acFormBar, acEditMenu,acUndo, ,; acMenuVer70 DoCmd.Close...

Swaggel1, I could be that you do not have the property security permissions to delete the file. That is why you are getting the access is denied error. Talk to your IT folks about deleting the file. They should have full admin rights to delete it. Chuck

Datathumper, Make isonumber either a primary key in both tables or set the index for no duplicates then make sure you have a 1 for 1 relationship. That should solve it for you. Chuck

Sid, I'm a little confused on the locking issue. I thought you just wanted to restrict user input for a given period of time. What it sounds like you want to do is take the database at a given point in time and save it to a location, then allow users to start inputing data in a fresh database...

Sid, The way I see it, you have 2 issues. The fisrt being user access. The only trouble with copying the database to another location is that someone could log on to the database in the original location and enter data. A better option would be to open the database in exclusive mode. The...

There is nothing wrong with selling an workbook that uses VBA. What you are really doing is charging for your time that was used in creating and coding the workbook. The only legal issues is that you used a licensed copy of excel when you created the workbook. Also, like VBAjedi stated above...

Does anyone know what "Row Level Tracking" is under table properties? When would you want to turn this feature on?

Thats what I was looking for. Thanks and enjoy the star. Chuck

Works like a champ. Enjoy the star & thanks.

I won't be around to do the carryover so I want it to be as transparent as possible to the end user.

I guess I needed to be a little more clear on what I wanted to do. I need to copy all the tables in my database (structure only), queries, reports, and macro's. Any ideas?

I have a database that works on a fiscal year basis. At the end of each fiscal year I close out the database and transfer any carryover data to a new database for the next fiscal year. One table I have in the database tracks data within the FY on a daily basis. It has 365 records starting...

I have a database that needs to be closed out on a fiscal year basis (FY2004.mdb). What I want to do is create a function that will copy my database (structure only) to a new file called FY2005.mdb Once that is complete I can fill the new database with the information that is carried over...

Had to make one adjustment, but it works. Thanks for your help and enjoy the star. Function DoCompression() SendKeys ("%{T}DC") End Function

Is it possible to put a button on a form that would force my access 2000 database to complete a compress and repair? I know I can set access to perform this option when the database closes, but I dont want it to run everytime, and I really dont want to have to explain to people at work how to...

Roy, This is actually the second post you have helped me with today. Thanks to BMPMike and Roy for the help. Enjoy the stars. Chuck

Jeff, It took some time, but I finally got it to work. Well worth the effort. You and Roy both deserve your stars today. Chuck

I have an access database that is located on a network drive that is accessed by 2-3 users at a time. When compressed the database is only 9mb but can grow to 40-50mb in a session. When I run the database on the local hard drive it runs fairly fast, but doggs down on the network w/multiple...

Jeff, Copied all the code and tried again. I am getting a Error 71 Disk not ready. I even tried setting the location to C:\ just to see what would happen. I have a couple of linked tables in my database that are offline right now, would that cause the funtion to error or am I just missing...

Roy, Thanks for the help. I gave you a star for all your help an patience. It finally runs, but now the errorbox pops up because of an invalid procedure call. I used the this code to call the function: Private Sub Command6_Click() Dim blnBackupSuccess As Boolean blnBackupSuccess...