Search results

Thanks for trying but I have checked all the ldbs and they are all closed.

I have a very large report with subreports based on quite a few linked tables. The report opens just fine but when I go to print the report I get the error "Cannot open any more databases" and one of the subreports doesn't print. Does anyone know why this is happening or how to fix it? It...

Ok I figured out how to reference a different database using the SaveAsText function but when I try to use it on the forms/reports from the corrupted database it gives me the currupted database error and it doesn't save.

Is there a way to use the SaveAsText to save the forms and reports from a seperate database. I can access the VBA modules from any other database just not the corrupted one.

Where do I need to place that in the VBA module of the object? If so it won't work because I can't access the VBA module of that database that is when I get the error unable to load vbe6.dll.

Well I downloaded the jet utility and it creates the new database but I have the same error in the database. I've also submitted the database to the owner's of this site and I was told they can not recover forms or reports. So I guess my only option is to recreate the all the forms and...

Ok I tried the decompile but it gives me the error message that the database is corrupt and doesn't finish decompiling. I'm using Access 2003 and I tried converting it to an earlier version but again I get that error message. I've also tried importing the forms one at a time but it won't let...

We did that. The tables and queries are fine but the forms and reports won't import. Is my only option to recreate all of them? And how and why did this happen?

Out of no where VB has some how become corrupt in one of my databases. When you try to open a form or report that has VBA code written I receive an error stating the database is corrupt and to do a compact and repair. I tried this and it didn't help. I also get the error Microsoft is unable...

I have a function and the word Beep in my on my form_timer event. The function works but my computer doesn't Beep. Does anyone have any idea why. Is there a setting I need to change?

It is linked to other access databases.

I was wondering if anyone knows a way to help make reports run faster. I am runing a report that uses a very complex query with linked tables. When I am in design view I get a 30 second lag. When I go to run, save, or open in design view it takes at least 2 minutes to open. I have 512 mb...

I'm running a complex query and I'm trying to get an average of a field for a 2 week period. The only problem is sometimes there will be zeros and I receive an error because of the division by zero. I don't know how to get around this. The calculation is Sum([Pledge...

Thanks for your help Pat.

Thanks Pat. So I will have to translate that stuff but will my VBA code automatically translate or will I have to do that myself?

Thanks for your reply. A friend just gave me the Access Cookbook so I will look into this. Thanks again.

Right now we have offices in Canada, US, and Australia. We have no problems designing databases in English since each of these countries use English. My question is if we decided to expand to France or Germany would access be able to translate everything if they use a French or German version...

Thanks both of you for all your help.

Yes, and I do understand how to do all that. I was just wondering if in my code where I import the spreadsheet into the table that I can tell it to instead of deleting the dup orders to place them in the new table.

I understand that, what I'm confused about is how to import records that have matching primary keys in the main table to a serperate table? Should I just import the whole thing?