Search results

This is probably easy but it is giving me fits. I have some simple code that transfers an Access table to Excel. Now, I need to know how to close Excel. Obviously the code ActiveWorkbook.Close True doesn't work. I've tried defining the application, workbook and worksheet and tried .Close and...

I need help with this code. What I want to do is associate the Check.pdf file with the value "Test1" and determine if it has a certain number of pages to open one file; and if not to open a different file. I'm not even sure if I HAVE to open Test1 in order to count the number of pages...

I have a page number field on a report; not related to the query that produces the report. I have a subreport on the report that has a PAGE field. I want the cell from the Field of the sub-report that is 1 to print on page 1 of the report and cell that is 2 to print on page 2, and so on. Is...

Although the table I am exporting to a .txt file has all fields set up as text data types, when it pulls into the .txt file it adds a ".0" to the end of the cield. Does something in the Export specs need to change, because nothing I nothing I have changed on it seems to help. :confused:

Until recently, I would pull all of my tables off of the AS/400 (IBM System i) through the ODBC external data interface in Access. Now when I try to pull anything over, I get the ODBC call failed error. It was suggested to me that the error was caused by a change to our SQL server...

Problem: How do I delete an empty table by identifying a field in the table as null. DoCmd.OpenTable "TableName" If Field Is Null Then DoCmd.Close acTable, "TableName" DoCmd.DeleteObject acTable, "TableName" Else DoCmd.Close acTable, "TableName" DoCmd.OpenForm...

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

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.

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

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

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