Recent content by chuckcoleman

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!

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.

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

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

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

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

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

Yes. Why do you think it wouldn't?

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

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.

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

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.

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

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.

Yes, I just need to track what they did.