Search results

  1. C

    Before Update event on a continuous form doesn't work

    TIME OUT! I have been working exclusively in the VBA editor and I just notice in the forms design Before Update event I had a macro. I apologize. Let me convert that to VBA . SORRY!
  2. C

    Before Update event on a continuous form doesn't work

    I've tried a few different things including MsgBox("BeforeUpdate"). They all work in the AfterUpdate but I would like to prevent the record from being added.
  3. C

    Before Update event on a continuous form doesn't work

    Hi, I have a continuous form that is a subform. I am trying to get the forms BeforeUpdate event to work and so far, nothing that I've tried works. I have some code that will check if a condition exists and it if does, I want the BeforeUpdate event to work so I can cancel adding the record, along...
  4. C

    Recordsource Doesn't work after adding data

    Hi arnelgp. Sorry for the delayed response; time differences and the flu. Unfortunately, I followed your first feedback to close the form, reopen it and then set the Recordsources like I do when I open the form. It results in a blank form without any records. I also tried your second suggestion...
  5. C

    Recordsource Doesn't work after adding data

    Hi. Background: Reportfrm has command buttons on it to open various forms and reports. The Startupsfrm shows by town by date the number of orders that are scheduled. The Orderfrm allows work order requests to be added. The user looks at what their customer has requested as a date and on the...
  6. C

    Cancel closing form without error message

    Thanks Doc. I'll internalize your feedback which is always valued. In my customers case, there are times when the customer places an order for what they want, (what they want is entered), but they request giving them an update later with the due date because they may need to check with someone...
  7. C

    Cancel closing form without error message

    Microsoft Access for Microsoft 365 MSO (Version 2407 Build 16.0.17830.20056) 64-bit
  8. C

    Cancel closing form without error message

    Yes. Why do you think it wouldn't?
  9. C

    Cancel closing form without error message

    Update. As I previously stated, the code was in the Unload event for the form. As you know, the Unload gets triggered when the form is closing/about to close. What triggers the closing is a command button on the form with DoCmd.Close. I removed that and with a minor modification moved the code I...
  10. C

    Cancel closing form without error message

    Thanks Doc. I don't think it is being caused by the Current event. At the top of the Current code, I placed "Exit Sub", so I don't think anything ran there. I still received the same message, No Current Record.
  11. C

    Cancel closing form without error message

    Hi, I have in the Unload property of a form the code shown. The code checks if there is an order without a Requested Due Date. If the Requested Due Date is blank it presents a vbMsgBox with OK or Cancel and the message shown. It all works perfectly, almost. If the person clicks on OK, it runs a...
  12. C

    Prevent certain reports from being printed

    Thank you LarryE & The Doc Man. I'll explore this later today, I'm trying to figure out another issue now and I don't want to lose my train of thought. I do appreciate your help.
  13. C

    Prevent certain reports from being printed

    Hi sonic8. I added code to the On Print section of the report that appends data to the table where I am keeping track of what's going on. Unfortunately, the On Print is activated when the report is Previewed. I am looking for a trigger when the report is sent to the printer vs. just viewed in...
  14. C

    Prevent certain reports from being printed

    No, Quick Access is the small menu of icons in the top left that a user can decide what icons they want "quick access" to. Like, Print, Save, Open, etc.
  15. C

    Prevent certain reports from being printed

    Yes, I just need to track what they did.
  16. C

    Prevent certain reports from being printed

    Hi DBG. I am aware that that is a possibility. I have a process going on in the background that captures is an invoice was viewed, printed or emailed. What I'm trying to do is make sure that the user doesn't view and use the Print Preview screen to also print it. Many things you can find a work...
  17. C

    Prevent certain reports from being printed

    Hi, I have a report that I want to find a relatively easy way to make sure it can't be printed. A form opens the report in Print Preview mode which is what I want. However I want to make sure that it can't be printed. As I see it, there are three ways a user could print something; using the...
  18. C

    Inserting multiple rows into an email created by VBA

    Thank you. I’ll try your suggestion tomorrow morning.
  19. C

    Inserting multiple rows into an email created by VBA

    Hi, I have been using VBA to send an email for several years now. The email is generated from a form where payments are inserted for property lots. Things have changed and I now need to include in the email information how much the payment was for each lot. For instance, owner ID number 21 owns...
  20. C

    Having trouble getting a report to use two different recordsets

    Hi MajP. I couldn't use the same query because I created a new table that became the criteria for one of the two queries by joining it to other tables. This is kind of an experiment where I had Access pick on a random basis 100 customer ID's where those clients/ID's don't have an email address...
Back
Top Bottom