Replies

I do have the .MDA file for the database in question. As I remember I did set the owner to other than Admin and Admin was removed from the Administrator security group.

I did try to simply copy the objects from the old db into a new one, but received the same “user does not have permissions” error.

I think if I could simply remember the ID I was using, I would be able to log into Access with that ID and then pull some of the objects out of the old db into a new one.
seems like I had done something similar in the past.

Thanks to all for your help.

Thanks Hans

That works great

Thanks.
I have chnaged the icons for the shortcuts in the folder. What I would like to do is
change the icon for the folder itself. When I right click the folder and view the
properties, I do not see a change icon option.

This is an icon on hte desktop.
My OS is Windows 2000.

Thanks

Thanks.
I have chnaged the icons for the shortcuts in the folder. What I would like to do is
change the icon for the folder itself. When I right click the folder and view the
properties, I do not see a change icon option.

This is an icon on hte desktop.
My OS is Windows 2000.

Thanks

The code is set up to import files based on the names of the files. The zip file will contain the same six files each time. It is downloaded to the C:Temp folder. I would like to unzip the files to the same directory. The code will then go to that directory and import a given set of files.

Thanks for the help

I have attached some OLD code we used to compact and repair db. Part of this function makes a backup of the db before starting the compaction.

Hope this helps.

Try opening a blank db in Access 200 and then importing the objects from the older db.

I have had this work for me on some older secured dbs.

You can see most of the standard tool bars by going to View/Toolbars/Customize from the database window.

This shows a list of the tool bars available for customization.

Repairing and Compacting a database on a regular basis is always a good idea.

Access should be able to handle a db up to 1 gig (1,000,000kb).

Hope this helps.

One way to filter the subform combo is to set up the “recordsource” property of the combo box to use the supplier selected on the main form.

the code would look somthing likw this.

SELECT ItemName FROM tblOrderDetails WHERE Supplier = Forms!MainForm.cboSupplier

Good Luck

Richard Aheron
raheron@hotmail.com

I have code that loops through the querydefs and puts the source table and fields in to a table.

Two limitations this code has is it only reports fields for Select queries and it does not report criteria.

Are these available through the proprties? I have not been able to find a way to get this info so far.

Thanks for you help.

If you have WinZIP you can compress the file.

If you do not have it go to WinZip.com and it is a free down load.

Richard Aheron
raheron@hotmail.com

After typing you post, go to the “Preview/Attach a File” butotn.

Use the “Browse” button to find the file to be attached.

This should get the file on the post.

Richard Aheron
raheron@hotmail.com

To assign a value to a label on a report…

1. The report must be open
2. You set the Caption of the label equal to the desired value.

Example Reports!rptReportName.lblLabelName.Caption = “Date Report”

You should be able to do this from the contrl that opens the report on the form where you have checked the value that controls the report label.

Hope this helps.

Richard Aheron
raheron@hotmail.com

Do you have any code in the combo box events that is trying to assign values?

Can you attach the form and tables with a small data sample? I will be glad to look at the form to see if I notice any thing that would give you error.

Richard Aheron
raheron@hotmail.com