Search results

Is there a way to print the Import File Specifications out of Access? WINXP-ACC97 Thank you.

I have been working in Access for 5 years now, and have never seen this issue !! When I go to the Query tab and try to right click on a query to "Copy" and "Paste" it, after I click Copy, (if it is a query with a parameter) the parameter box pops up, I click cancel, then it pops up 3 or 4 more...

All of my reports are opening in "FIT" view. I cannot find the option to have the reports default to 100%. (They do open Maximized, but not "100%) Can anyone tell me where this setting is located? I am using WINXP and Access 2003. Thanks! Michael

Hello, I am using the following code to add a field to an existing table. DoCmd.RunSQL "ALTER TABLE [AES GROUP AUDIT] ADD COLUMN GROUP TEXT", -1 I would like to be able to check the table first, to see if the field is already there. pseudocode: If fieldMyField exists then don't add the new...

Sounds easy. Actually, it is. That is, when the user closes the report with the 'Close' button. But when they close the report using the 'X' in the upper right hand corner though.... Here is the code I have in the report's Close Event: Private Sub Report_Close() Dim stDocName As String Dim...

Not a big deal - I am more curious than anything. I have a simple import spec. Imports a text file into a pre-existing empty table. The first field in the table is RecNum (not part of the text file). Most of the time, after I import the file and check the table, the table is in the same order...

Is it possible to have as the criteria for a field in a query: [Is Null or Is Not Null?] Where the parameter box pops up, the user enters Is Null, and the query runs using Is Null as the criteria for the specified field? (It didn't work using the above example!) Thanks!! Michael

I would like to figure the average without including the zeros. REC# MyCOUNT 1 0 2 5 3 12 4 0 5 3 6 5 7 16 I'm not a great mathematician, so using a calculator, the Average for the above...

I have been working on this for some time now, and I am hoping someone can look and it and say: "All you have to do is this......." I have a report "Detail Report of..." based on the below query which works wonderfully - the report is exactly what I need. What I have tried to do is, based on...

Unbound form - frmABC Textbox - txtBeginDate Textbox - txtEndDate Report - rptReceived I would like a textbox on the report's page header to read: Accounts Received Between xx/xx/xxxx and xx/xx/xxxx I just can't seem to get the syntax exact. I have: "Accounts Received Between "...

Simple query. Field: CompID In a query - drop the field to grid. Criteria line - [Enter a CompID] Works great when user enters ONE CompID. What I would like, is for the user to be able to enter 1,2 or 3 CompIDs as the criteria. How do I do this? :confused: Thanks! Michael