Search results

Need help with import error. A week ago I would import data from AS/400 into Access - no problem. This week, I get this error [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0400 - Routine SQLSTATISTICS in SYSIBM not found with specified parameters. (#-440). Not only will the import not...

Thanks very much

In Access 2007 on the Office Button, there is a button at the bottom for Access Options. In the Current Database tab (once the Access Options button is clicked) under Application Options, there is a checkbox for Display Document Tabs.

It looks like almost anything you can do manually in Access you can do with code. Here's one I haven't been able to find an answer to yet. What is the code to turn on and off the Display Document Tabs? Thanks for the help.

I didn't really understand the Second Form part, but your link did help me figure out how to fix it. Thanks for your help.

This is probably very easy; but I don't know how to do it. I have a report with seven pages. I only want to open page 5. Can someone help? Thanks

Thanks for the help. That worked!

I have a report that produces a voucher. The user inputs the date and the date is printed on the form. The field has =Format([What is the date that you want the check to cut?], "mm/dd/yyyy"). This worked fine January 31. February 3 when I tried to do it, instead of the date I got an...

I designed a report and saved it in my database and when I tried to reopen it, I got this message - "This object was saved in an invalid format and cannot be read." I had saved it before without this problem. Sadly, I did not back this report up before the error occurred. Is there any way to...

Thanks for the help, Ken. I could have searched days looking for that without finding an answer. The sample database explained everything nicely.

First time poster. Not proficient VBA user by any means.:confused: Ok, here's my dilemma. I have a popup form with three options. All three options will open the same report; but two of the options will populate different fields and the third option will populate both fields. When one of...