Search results

  1. C

    Question Generate report from data just entered in a form

    Where is VBA help? What's an argument?
  2. C

    Question Generate report from data just entered in a form

    Thanks! Is there a way to allow the user to press a button to see the report instead of just printing it? And then on the report is the button to print and email the report? Is there a way of saving the new report, or does it count as the same old one because it's just been restricted?
  3. C

    Question Generate report from data just entered in a form

    But I'll make the report with the records already created, and then when a new order is made in the order table, and they press the receipt button, a report will pop up with a whole heap of records that don't even include their order.
  4. C

    Question Generate report from data just entered in a form

    So when a new record is added, what happens?
  5. C

    Question Generate report from data just entered in a form

    And I put the name of the report in "ReportName"? Does the data in the report change when you press the button? Thanks for your help. I must be very frustrating!
  6. C

    Question Generate report from data just entered in a form

    Thanks :) DoCmd.RunCommand acCmdSaveRecord DoCmd.OpenReport "ReportName", acNormal, , "([OrderID])=" & Me.[OrderID] That's the code I put on the print button's event OnClick. Am I supposed to have a report already made for this to work, and replace "ReportName" with the name of the report...
  7. C

    Question Generate report from data just entered in a form

    I made a print button and added the code like you said, but this error came up. What did I do wrong? I also changed the cycle to This Record. Was I supposed to change DoCmd to something else?
  8. C

    Question Generate report from data just entered in a form

    I'm sure it makes sense, I just have no experience with Access (with exception for the last couple of weeks), so I am unfamiliar with the terms it uses and how to adapt the code for use in my own database, and where to put it. Does the code you linked me to generate a new report, or does it just...
  9. C

    Question Generate report from data just entered in a form

    Could you please explain what it means?
  10. C

    Question Generate report from data just entered in a form

    Hello, I was wondering if there is a way to generate a report (maybe through use of a macro or something) from the data you just entered in a form. So, there is an order form and the user fills out their details, saves the order, and then they can press a 'Generate Receipt' button, and a...
  11. C

    Question You do not have exclusive access to the database at this time

    I just copied and pasted this to another location, and the problem went away.
  12. C

    Question You do not have exclusive access to the database at this time

    This is the error message
  13. C

    Question You do not have exclusive access to the database at this time

    I've researched this (and apologise if it's a stupid question :confused:), but it seems that this error message: "You do not have exclusive access to the database at this time" should only appear if I have multiple users trying to change it. This is just a school assignment, and no one else...
  14. C

    Question Make a report on one record only?

    Thank you :)
  15. C

    Question Make a report on one record only?

    Hi, I was wondering if there was a way to create a report on one record from a table only instead of the entire table. Should I make a query first, one that eliminates all the other options, and then generate a report from that?
  16. C

    Macro for creating a field in a table

    The database is for the owners of a business, and they want to be able to navigate their database easily with buttons, but also to be able to view already input data.
  17. C

    Unchangeable fields in my table?

    Thanks, changing it in the form worked. What's the Form Locking Property? Is that in the property panel?
  18. C

    Unchangeable fields in my table?

    I cannot change the value in one of my fields in my Customers table. Is there some function that locks tables that I am unaware of (I am unaware of a lot :P)
  19. C

    Form not working? Expression trouble...

    Thanks for your time :)
  20. C

    Form not working? Expression trouble...

    My friend fixed it. All he did was delete the field on the form, then pressed Ctrl+Z. I don't know what was wrong with it. Obviously not the expression... I have no idea.
Top Bottom