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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Layth

  1. Layth

    Running a macro from a report.

    That sounds right, do you know where it is located?
  2. Layth

    Running a macro from a report.

    If I wanted access to run a macro when the user clicked on a report how would I do that. I have two reports that both run on code that is in an AutoExec macro, one of the reports needs extra automation, so as soon as the user clicks on that report I want access to run the other set of code that...
  3. Layth

    Reserved error (-7711)

    Thanks, I ended up using the workaround
  4. Layth

    Reserved error (-7711)

    Does anyone know what "Reserved error (-7711) there is no message for this error" in Access means. thanks, Layth
  5. Layth

    Too many fields in a union query

    When I run a union query the I see a message box that says "To Many Fields Defined". What does this mean and how do I get around it? Thanks, Layth
  6. Layth

    Updating linked tables.

    Actually, I figured this out a few days ago, sorry I havn't written back, my whole database runs like a dream, Thanks so much!!! Thanks again, Layth
  7. Layth

    Updating linked tables.

    Alright, this is very cool, one more question How do I get this to immediately update in vba when someone opens this access database, or perhaps have the update linked to a command button. THANK YOU!!! Layth
  8. Layth

    Updating linked tables.

    Thanks for the help, I'm not really familiar with append queries, I think this is what I want to do, but if you could elaborate I think I could use this method more clearly. thank you for your help. Layth
  9. Layth

    Updating linked tables.

    I have an access database that has multiple linked tables. One query pulls out all of the information I need, I then turn that query into a make table query and query the subsequent table. From there I use other queries to count records, manipulate records mathematically based on their fields...
  10. Layth

    Searching by Date

    Thank you this works well.
  11. Layth

    Searching by Date

    I have a report that shows all 310 records from a query. I have one field called stopdate, I want to do search in the field stopdate so that it only shows the records that correspond to the date that the user will insert in the beginning of the report in a text box. The report would look like...
  12. Layth

    Too many Fields

    Thanks a bunch! This works very well! Layth
  13. Layth

    Too many Fields

    I'm making a report based on a query with 30 fields. When I run the report I get an error message, "The wizard is unable to create your form or report you chose too many fields, please try again with fewer fields." I have made a form based on the same amount of records, so how do I get around...
  14. Layth

    Combining three fields into one

    Close, the city field was just used as an example the code actually unioning total prices, this is what ended up working for me. Also I had to tweak the queries a bit submasterpiece=MASTERPIECE, thanks for your help SELECT *, [MASTERPIECE].[Total] AS CombinedTotal FROM [MASTERPIECE] WHERE...
  15. Layth

    Combining three fields into one

    I actually have fields in all three of the queries that are the same that I need to have in the final union as well, what happens to those fields
See more

Part and Inventory Search

Back
Top