Search results for query: *

I need to preview a report numerous times with each report having different data and all the print preview windows need to be open, that is until the user decides to either close or print them. And I'm having no such luck! Any ideas? Thanks so much, lakefun

I've created a report, listing lawsuit names, dates and other information. And I've included a subform that lists the judges that ruled and how they ruled. The report and the subreport are linked by several fields and everything is working just great, EXCEPT when the name of the lawsuit is...

I ran the compact and repair utilities and now everything seems to be working correctly. Thank you!!

I checked and nothing was missing but I do remember that I hadn't been able to use the "Trim" function today.

When I added the code to the Control Source field and opened the report, I get a prompt asking me for "Format". What did I do wrong?

I'm in the process of designing a report and I need a text box that will concatenate a number field from my source table with text (ex. "Over 14,456 people dined at Chili's last week"). The problem is that I need the number to print with the comma and all I can get is 14456. Any...

The chart generates its own chart heading (it was done with the wizard) so I don't need to set up another one - I just need to modify the one on the chart. Is this possible?

One of my reports contains a chart. And based on the data from the source query, the chart heading will need to change each and every time it runs. Can I modify this field with my VB code? Any help/ideas would be appreciated!

Thanks again!!!!

Just one more thing..... I need to add 2 more fields to the statement. When I do this, I'm getting a syntax error. Would you please look at it? I'm very new at VB code and this is throwing me for a loop. DoCmd.RunSQL "INSERT INTO t(q1),(q2),(q3) SELECT " & [Forms]![form1]![q1] &...

THANK YOU - THANK YOU - THANK YOU!!! You are a lifesaver!! Have a great weekend - I'm going to now! P.S. But first, I'm going to fix my fieldnames!

After making the changes, I now get an syntax error message about a missing operator in query expression 'Field 133' (which is the value from the form). Any ideas? Thanks for your help!

I'm trying to run a sql statement where the field names of the table are supplied by the user in a form. When I run the statement below, I get the value of [forms]![form1]![q1] in q1 and what I want are the values of the field that is named in [forms]![form1]![q1]. INSERT INTO t ( q1 )...

thanks for your help!

Sorry about the wording. I know one cannot create an Access executable but with the help of the developer kit, one can distribute a runtime copy of Access with a database. And I was aware that users will not be allowed to view, create, or modify any tables, queries, forms, reports, macros, or...

I'm needing to make my Access database into an executable application for a client. They produce a lot of charts (through "Reports") and I was wondering if the charts would still be available from the executable application. ANY ideas or suggestions would be appreciated greatly...