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 Chriss Miller 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: *

  • Users: Layth
  • Order by date
  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
  16. Layth

    Combining three fields into one

    I have three fields in a query that each give a decimal amount, the three are unique meaning if one is not null, the other two are null. What I'm trying to do is place all three of these fields into one field I'll show an example City Code 1 Code 2 Code3 San Juan...
  17. Layth

    Changing to decimal

    either or, both of these work great! thank you, layth
  18. Layth

    Changing to decimal

    sure I have data that will end up as: 101 132.3 45.3243242 I need 101.00 132.30 45.32
  19. Layth

    Changing to decimal

    I need to return a decimal dollar amount, to decimal places, from the code below, I know its something simple, but I have tried decimal, float, double and none of these work. Here's the code [START THE EQUATIONS HERE].[MIN Of INSERTIONCOST] * ([START THE EQUATIONS HERE].[Total Of AMPORDERFK] -...
  20. Layth

    Combining multiple dates on one record

    Thank you very much, this is exactly what I needed! Layth

Part and Inventory Search

Back
Top