Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. lakefun

    Problem with "openreport"

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

    Trouble with text box on report, effecting results in subform

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

    Need help with text box field containing numbers

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

    Need help with text box field containing numbers

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

    Need help with text box field containing numbers

    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?
  6. lakefun

    Need help with text box field containing numbers

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

    Needing to change the chart heading

    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?
  8. lakefun

    Needing to change the chart heading

    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!
  9. lakefun

    SQL statement where the table field names come from a form

    Thanks again!!!!
  10. lakefun

    SQL statement where the table field names come from a form

    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] &...
  11. lakefun

    SQL statement where the table field names come from a form

    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!
  12. lakefun

    SQL statement where the table field names come from a form

    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!
  13. lakefun

    SQL statement where the table field names come from a form

    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 )...
  14. lakefun

    Anyone use Office 2000 Developer for Access application?

    thanks for your help!
  15. lakefun

    Anyone use Office 2000 Developer for Access application?

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

    Anyone use Office 2000 Developer for Access application?

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

Part and Inventory Search

Back
Top