Search results

In MS Access 2007 (VBA) a select query statement is utilized to create a temporary table with the same data. I want to access the temporary table to verify an id field, but it appears that the data is missing and the system does not recognize the variable. I double checked that the name is...

Thanks for the reply John. ps

There is an existing application which allows new records to be created from a button off the main form. When using this button to add new records the above-noted error is returned. This error is returned when the system attempts to execute the following code: intCoNo =...

An existing application no longer allows data entry in new record. Typing yields no affect. Has anyone encountered this issue before? Any help is appreciated. Thanks.

Yes. I tried this option several times, but it did not work. ~Phyllis

The requested report is attached. I was unable to find any extra line by selecting the page header area or changing the page header background to black. Any help is appreciated. ~Phyllis

MS Access 2003 (Windows XP) application recently migrated to MS Access 2007 on Windows 7 platform. Now reports page header height is set to 22" and cannot be modified. This is the case for all included reports. Is there a fix for this yet? ~Phyllis

No. Do you have any guidelines for creating a good CT query? The results continuously return "You can't specify Group By, Express, or Where in the Total row for this colum" error message." That is, during the first attempt session the query was not able to run. Any advice? Please advise...

There is a requirement to display the results (Tope 3 Dates to flow side-by-side) for a single column query in MS Access. The application was written in 2003, but has been converted to 2007. Any help is appreciated. Thanks. psimpson

There is a need to produce a report from several tables. The report generates fine, but some listings are printed 2 or more times giving different telephone numbers only. It appears, as in one case that the business telephone and business fax numbers are printing. When I look at the telephone...

A specific dataview has been set-up on a partner server for company to access. Can someone provide specific directions on how to retrieve the data? The database is looking for the data on my home drive, not the server to which I am connecting. I import the data into a blank database and write...

Thanks for the confirmation, additional information.

Is there a way to comment out a specific section of a SQL query within MS Access? The normal SQL commands such as, rem text; ' text ; - text ; or /* text doesn't seem to work. Any help is appreciated. Thanks.

I want to use an existing public encapsulation and set a value. However, the default.aspx.vb will accept the input value, but not assign it to the new encapsulation. Does anyone have any idea as to the possible problem(s)?

Thanks for your response.

Currently there is a MS Word application that runs a MS Access query to generate data for the Mail Merge with a document. Does anyone have a suggestion as to how this process can be optimized? Specifically, looking to reduce the amount of time required to produce letters (best practices)...

We recently experienced network issues here at work. Now I need to make sure the current version of the MS Access application is running. Is there a version compare component with MS Access? Does anyone have a recommendation on software that will work well with MS Access 2003? Help? Thanks.

Thank you. That worked. Thank you so much.

While attempting to create an MDE file, the system hangs-up. User must exit system using "End Task" option, because system isn't responding. This continues after performing "compact and repair." This feature works fine with tables only in the container. Does anyone have any suggestions? Help!

While working within MS Access--and using debug tool--I received the following error when selecting the find button on a specific form: Command or action 'Find' not available at this time This is an existing application and works fine normally.