Search results

Unfortunately that didn't work, thanks for your help though Spike.

The control itself is actually on a subform, if that would make any difference?

No, no errors are returned when i run the Debug Compile.

Yep, the code is Private Sub BookingStatuslbl_AfterUpdate() Debug.Print "Booking status is " & Me.BookingStatuslbl If Me.BookingStatuslbl = "Cancelled" Then Debug.Print "Calling the macro " DoCmd.RunMacro "CancForm", acNormal End If End Sub

Yes, the handler is there as an Event Procedure for After Update. I've double checked the naming of the controls, and it all matches perfectly. Can't think any other debug.

The control type is a Text Box, but validation on the control restricts users to entering only three options - Confirmed, Awaiting Confirmation or Cancelled. I inserted the red lines as you said, nothing was displayed in the Immediate Window. I then saved, re-tested and it's still the same...

Good morning all, I have a field called "BookingStatuslbl". When the word "Cancelled" is entered into this field, i want a macro to run that will open a form to enter a Cancellation reason in. I've entered the following code into the AfterUpdate event for the "BookingStatuslbl" field, but it...

Hi there, I'd maybe take a look at this http://www.access-programmers.co.uk/forums/showthread.php?t=205388

No problem at all, i'm glad i helped!

If it's a continuous form, the tick box should be relative to each individual record and should NOT affect all records. Not sure why yours is, can you post an up-to-date copy of your db?

Firstly you need to create an update query that will set the 'archive' field to -1 (active). You also need to decide which records you want to archive, do you want to archive them all? Otherwise, set a criteria parameter. Once you're done, save the query. Secondly, on the OnClose event for...

Okay, thanks lagbolt!

I tend to have an "archive" field in my tables. Once i'm done using them, rather than deleting them or moving them to another table, i use an update query to set the "archive" field to 1. In your Frm_DiaryPage, set it so that it selects only records where "archive = 0". This way, you're...

Ahh i think i've cracked it, does anyone envision having any issues with using: Private Sub newpqe_AfterUpdate() If Me.newpqe = True Then DoCmd.OpenForm "Anal-PQEPOPUP", acNormal End If End Sub

Good morning all, The title pretty much explains my query, but just to clarify... If the checkbox "PQE" is ticked (-1), invoke the form "PQEFORM". I thought about using the OnClick option, but i do not want the form to be invoked if the checkbox is unticked (-1 to 0). I'm sure it's just a...

Hi, I don't think this is actually possible to do in a Macro, i'd suggest using a login form. This is a nice little login form which you can add into your db, thanks to the great Bob Larson. http://downloads.btabdevelopment.com/samples/misc/LoginSample.zip Cheers,

Unfortunately, i couldn't get your code to work. I entered it into the OnClick of the button, but it asked me to debug it, and i'm not sure where to start debugging. Is there a way i can invoke the Export to Excel window? (please see attached) FYI, im using Access 2007

Thank you David, i'll give that a whirl and get back to you with my results!

Morning all! Probably a very easy question, but how do i export the data in my pivot table to Excel? I understand that i can do this via menus etc, but i want this to be hardcoded into a button. I've tried using the TransferDatabase/Spreadsheet option, but i can't seem to get it working. Any...

Afternoon all. Very simple one i'm sure... I have a form that's using the TabStrip function. I have three tabs; Details Tasks Attachments Along the bottom of each of these tabs are "Next Record" and "Previous Record" functions. However, when you select one of these, instead of the "Details"...