Recent content by stotzc001

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...