Separate OnChange And AfterInsert Events

Jul 12, 2006

I use the events afterInsert of a Form frmA and the onChange of a field in the same form in order to make some changes to another Form frmB.

Everything goes as expected when the field (with the onChange event assigned) of an existing record changes.
The problem starts when I add a new record which triggers both AfterInsert event (desired) and onChage event (undesired).

Is there a trick to separate the two events?
Basically I want to call a Sub when the data on the field change (onChange)
and a different Sub when I add a new record (AfterInsert).

Thanks in advance

View Replies

Forms :: AfterInsert Sub Sends To Last Record

Sep 26, 2013

I've a form, which is sorted and I want to add a new record. After inserting the record, I want to go to this record. I wrote this code in the form's AfterInsert event :

Private Sub Form_AfterInsert()
intID = Me.ID
Me.Requery
Me.RecordsetClone.FindFirst "ID=" & intID
Me.Bookmark = Me.RecordsetClone.Bookmark
Exit Sub
End Sub

The problem is when Exit Sub is reached, the form goes to the last record, instead of the new inserted record (which is somewhere in the middle, because the form is sorted)

View 2 Replies View Related

Modules & VBA :: Subform Itself Has AfterInsert Event Handler

Jan 14, 2014

On a subform, I have a text box control with an AfterUpdate event handler. The subform itself has an AfterInsert event handler.

If a user enters data into that tb control for a new record and then moves on (tab or click elsewhere), the AfterUpdate fires and does what it should, including setting Me.Dirty=False immediately before it completes. Then the form's AfterInsert event fires and does what it should, but finishes by returning program control to the ErrorHandler label within the control's AfterUpdate routine, reporting either an error 2101 (The setting you entered isn't valid for this property) or 3270 (Property not found). The form's AfterInsert handler does have its own ErrorHandler label, but it is not being executed.

View 6 Replies View Related

OnChange Or AfterUpdate

Feb 28, 2005

Is there a central reference on the net that explains the pro's and con's of each of the event types. I historically have used the OnChange event until the other day when someone suggested using the AfterUpdate instead.

Would like to ensure that I have the best event trigger being used where possible in various situations

Thanks in Advance

View 1 Replies View Related

OnChange Triggered Before Change In Value

May 30, 2005

I have a combobox which needs to call a function f(combobox.value) during its onChange event. Currently though, combobox.value appears not to change before the onChange event, and so the function receives the wrong (last) value.

Note - the actual text in the text field of the combobox *has* changed to the new value before the onChange event occurs.

Any ideas why this might be?

Edit - Also the problem doesn't happen when selecting with the mouse, only when using the up and down arrow keys to move through the list.

View 3 Replies View Related

Move Cursor To Next Field 'onchange' Etc..

Apr 17, 2005

I have 4 drop down lists calling values from a query.
This part works as expected.

However, I would like the focus to automatically change to the next drop down field after ANY (valid) entry is made.

IE

Drop Down 1: "any value" ----> focus automatically set to Drop Down 2, etc

The code I have only relates to 1 of the drop down values, I want it to rerlate to any of the values.

*************
Private Sub Question1_AfterUpdate()

If Me.Question1 = "Yes" Then
Me.Question2.SetFocus
End If
End Sub
*************

My values are simple, just "yes" "no" "I don't know", etc.

OR

If this cannot be done with drop downs, how about with field lists?

:cool:

View 2 Replies View Related

AfterUpdate Or OnChange For A Bound Textbox

Jun 1, 2006

Hi there,

I'd like to call a function when a bound textbox is updated and for some reasons it doesn't seem to work. It works when the textbox is unbound (or maybe I missed something)
Here is a very simplified version of the form:
http://img207.imageshack.us/img207/3618/apf4ax.jpg

MyFunction() is just a MsgBox for now and I'd like it to appear when the textbox in the main form is updated (i.e. when the text in the subform is updated). I set .AfterUpdate= "=MyFunction()" and .OnChange="=MyFunction()" but nothing happens.
(see attached code)

Thank you in advance !

View 2 Replies View Related

Forms :: Default Value In Onchange Event

Jan 27, 2014

On my form i have a control called WeekDate (this is always the start of the week (monday), below i have a subform (sbfrmWorksheetDetails) contained in a tab control (tabWeek) with 5 pages for each day of the week, i have written a select case statement in the onchange event for tabWeek which selects records based on the day of the week (so = WeekDate for Monday, +1 for Tuesday, +2 for Wednesday etc), this works great, i have also put a bit of code in the same onchange event that makes the default value for a new record for the field WorkDayDate in the subform +1 and +2 etc. this works great for existing records, each new line in the subform puts the right date in, however this seems to cock up when clicking on a new tab that doesn't have a record in..Here's the code.

Private Sub tabWeek_Change()
Select Case tabWeek
Case 0 'Monday
Forms!WeeklyWorksheet!sbfrmWorksheetDetails.Form.R ecordSource = "SELECT * FROM tblWorksheetDetails WHERE (((tblWorksheetDetails.WorkDayDate) = [Forms]![WeeklyWorksheet]![WorksheetDate]))"
Forms!WeeklyWorksheet!sbfrmWorksheetDetails.Form!W orkDayDate.DefaultValue = SQLDate(Me.WorksheetDate)
Case 1 'Tuesday
Same as above but WorksheetDate+ 1 for both select and default value.
Case 2 'Wednesday
Same but +2 etc.
End Select
End Sub

the SQLDate is some code that converts the american US date formatting to UK formatting. i'm not sure if that's the problem, but i'll post that anyway:

Function SQLDate(vDate As Variant) As String
If IsDate(vDate) Then
SQLDate = "#" & Format$(vDate, "dd/mm/yyyy") & "#"
End If
End Function

I can't quite work out what screwing this up upon adding a new record.

View 14 Replies View Related

Forms :: OnChange Event - Setting Password Protection On Tab Control

Nov 4, 2013

I have an Access 2010 form within my database in which I have a series of 8 tabs on a tab control. I am the only user who will have access to these tabs. I want to require a password in order to permit access to the tabs. The very first tab on the tab control works as a cover tab. There is no relevant information for anyone to view...only a graphic.

How to code the "on change" event of the tab control.

View 1 Replies View Related

Events And Participants

Jul 10, 2005

Here is what I want to do:
I'm organising 15 training events, for 60 participants. These 15 training events fall in three themes: running, swimming, cycling. So there are 5 training events held on running, 5 on swimming, 5 on cycling. Each has on average 4 participants, but in reality, some have 6, some 2.

Everybody has to attend each of the three themes, so three of the 15 events.

I have a table called "events". each record contains data on a certain event (place, date, speaker, participants,...)

I have a table of 60 participants, with: their names, their age

Per event, I want to indicate who is participating, with a combobox. Now, the number of participants per event is not limited, so it could be 5 or 30.

Also, it could be nice if the combobox content is limited to the people that haven't been selected yet. So if John Doe is already taking the swimming training in event Swimming1, if I pull down the list of participants in event Swimming2, I do not want to see John Doe's name there.

Also, I want to calculate the average age of all the participants of a certain event.

I want to print out two reports:
1) per training event, an overview
2) per participant, an overview of all the events he has inscribed to

How do I go about this?
Currently I am using 30 comboboxes, and 30 fields in the table "events", called participant1, participant2, participant3,..., participant30
But it is becoming messy, and when I ask for a report per participant, he only gives me the details for the people in participant1.

View 9 Replies View Related

How To Deal With Events Across More Than One Day

Oct 7, 2005

Right this is a fundamental issue for me here and I cant get my head around the problem!!!

The database I am working on is a database which records the training courses (run by the NHS) which staff at GP surgeries in our area have attended and acts as a booking system for them.

So we have the obvious tables - one for courses (including the name, cost, etc) and then one for course dates (linked by courseID) and one called training_record which contains who went to what when.

It seems simple but it has come to my attention that for example, "Course A" may in fact take place over 2 days, which could be a week apart. The surgeries are billed in one invoice, i.e. Course A would be �100 for 2 days.

How would you recommend I have this data? I can see all sorts of confusion arising... :(

The only way I have thus far thought would be to put each one in like:

course name: cost date
Course A: day 1 �100 - 29/10/2005
Course A: day 2 n/a - 6/10/2005
Course A: day 1 �100 - 01/11/2005
Course A: day 2 n/a - 08/11/2005

However this seems long winded as some courses may be a few days long and this means adding each person to multiple ones!!!!

Any assistance with getting my head around this would be ace! :)

View 1 Replies View Related

Tab Control Has No Events

Feb 15, 2006

Is just me, or are all of the events on tab control tabs disabled?

View 3 Replies View Related

Events Not Triggering

Jun 23, 2006

Access front end, SQL Server backend.
----
I have a continuous subform (part of a tab control on a main form) whose name and sourceobject are both "sbfCannulae". There are about 10 fields on the subform, and all are bound to fields in a table. The primary key of this table must be generated by combining two other fields, which must happen just before the record is saved. (I know calculated data should not usually be saved in tables, but trust me. In this case it is necessary.)

Right now the user COULD enter data into the primary key-bound textbox, but since the user is me, I make sure not to do that.

When I enter data into all fields except the primary key, I get an error because the primary key cannot contains nulls...of course.

I use the following code to tell me when an event has been triggered.

Code associated with sbfCannulae:
Option Compare Database

Private Sub Form_Activate()
MsgBox "cann activate"
End Sub

Private Sub Form_BeforeInsert(Cancel As Integer)
MsgBox "cann before insert"
End Sub

Private Sub Form_BeforeUpdate(Cancel As Integer)
MsgBox "cann before update"
End Sub

Private Sub Form_Current()
MsgBox "cann current"
End Sub

Private Sub Form_Dirty(Cancel As Integer)
MsgBox "cann dirty"

End Sub

When I enter data into a new record, the Dirty event is triggered, but I cannot for the life of me figure out how to trigger any of the other events. No combination of values and nulls in any fields, clicking in other tabs, clicking to other records, or using the navigation buttons will ever trigger any events but Dirty.

The only msgbox I ever get is the one giving delivering the SQL error about the primary keys not taking null values.

What am I doing wrong?

-Matt

View 1 Replies View Related

Field Events

Sep 10, 2006

Dear friends

I request your comments please...
I have a form with bound and unbound fields and have linked the [Event Procedure] on these fields base on there respective action.

Now when I open or click a particular field with the event procedure, the procedure is names are like -
Private Sub Rate_Exit(Cancel As Integer) or
Private Sub Quantity_Exit(Cancel As Integer)

but others events are name like Private Sub Quantity_Enter() simple. Why is that ms access (Cancel As Integer) uses only for specific events only.

View 1 Replies View Related

Problems With Events

Oct 1, 2004

I have a main form that calls several other forms for the user to input data. When the user closes one of the sub forms I would like to know what event is fired when the main form gets the focus back. I have tried several different events and can not figure out which one will work. Hopefully someone knows the answer I'm going crazy tring to figure it out, oh wait I'm already there.

Thank you

View 3 Replies View Related

Events In Forms

Mar 16, 2007

I have a database in which people add little bits to different fields as they go. For instance, person 1 puts in appointment, person 2 verifies info for the customer, person 3 checks the customer in, person 4 takes their money. What I am trying to do in a form is track the time when each department accessed it, and which user. I can do this on a new record, but for some reason, I can't get the event properties to work correctly on my form. I have a field for each department set aside for when they update their part of the record. What I am trying to do is, when the record is updated, having the time autopopulate the field.

Example:

Appointments enters |DATE OF APPT| |TIME OF APPT| Appointment timestamp should = time()

Verification enters |PATIENT INFO| |VERIFIED y/n| Verification timestamp should = time()

Reception enters |PULL TAB#| |CHECKED IN y/n| Reception timestamp should = time()

Cashier enters |AMOUNT COLLECTED| Cashier timestamp should = time()

All of these fields are on the same database (I have 2 linked tables: Customer demographics and appointments linked one to many by account # for the customer), and obviously, there's a lot more to it, but this is just a short example of what each department will enter. Appointments starts the appointment, so their timestamp will work, as they are starting new record. However, all of the following departments will be adding to this appointment record. When the other departments open their form with the fields in which they will be filling out, I want it to timestamp when they update the record as well as inserting their login "currentuser()" into the "updated by?" field for each department. For some reason, when I put time() into the event portion the field, it doesn't work. I tried it on dirty, on exit, after update, and it just doesn't update. Am I missing something?

View 5 Replies View Related

Recurrent Events Calendar

Jun 19, 2005

Hi guys, ..and girls ;)

i have a calendar that works like a charm, but i would like to add the possibility to add recurrent events in it.
for instance if a user has to perform a task at a choosen time schedule, it is shown in the agenda, like each week or each two weeks or each month.
Anybody any idea how i would aproach this problem or has a sollution?

Thanks

View 1 Replies View Related

Question About Events And Compilation

Aug 19, 2005

Hi everyone,

I try to implement a function that looks for broken references in my Access project, so that I won't need to modify the needed references for every workstation. Here's my problem: Where could I put the call of this function so that this code will run before trying to compile the forms and, as a result, avoiding the compile error that access pops-up when a reference is broken or missing.

Thanks in advance! :D

View 1 Replies View Related

Append Events By Date

Jun 23, 2007

I have a series of events that have a start date and an end date. How do I write an append query to append an event to a table as an individual event for every day in the given range?

View 2 Replies View Related

Order Of Events Help On Code

May 13, 2005

I have a start and end date fields plus a txt box called wDays.
I'm trying to make sure the user puts in both dates but end cant be earlier than start and vs versa....
If not provide a message as to which is missing....
If alls well do the calulation with the module "GetWorkDays"
I f everything goes bad, dont save the record at all!

I have this behind a cmdButton. Used to unhide the wDays field because it displays #error otherwise...and to do the calculation... with the BeforeUpdate
Private Sub Command8_Click()
If IsNull(Me.sDate) Then
MsgBox "Please enter a Start Date"
ElseIf IsNull(Me.eDate) Then
MsgBox "Please enter a End Date"
Else
If Me.eDate < Me.sDate Then
MsgBox "End Date cannot be earlier than the Start Date"
Exit Sub
End If
End If
Me.Requery
End Sub

Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim myDays As Integer
If IsNull(Me.eDate) Or IsNull(Me.sDate) Then
Me.wDays.Visible = False
Else
Me.wDays.Visible = True
myDays = GetWorkDays([sDate], [eDate])
Me.wDays.Value = myDays
End If
End Sub

Any help would be really appreaciated because I have tried many combonations of code placement to get it working correctly....

View 1 Replies View Related

Before And AfterUpdate Events Not Firing

May 26, 2005

Hello all:

I have a split, shared database in which the Before and AfterUpdate events on my forms are not working at all. I tried setting a breakpoint to verify this and, sure enough, they are not firing.

Does anyone have any clue as to why this may be occurring?

Thanks so much for the help. I have tried searching the forum with no luck.

View 2 Replies View Related

Tab Control Loses Events..???

Aug 15, 2005

I have a form with a number of controls with code behind - this works as required.

However, recently I decided to use a tabbed control to hold the controls and simply cut/pasted these control onto one of the pages of the tab control. The events now no longer fire as they did and I have no functionality on the form - the code still exists in the design of the form though..... any ideas?

View 1 Replies View Related

Cancelling Events In BeforeUpdate

Aug 15, 2005

Hello all,

I have a form where I want to validate enties before moving off the record.

I put my validation in the BeforeUpdate event of the form. If validation fails, then I set Cancel=True. So far, so good.

But if the user closes the form (either with my close button, or the standard close button), or presses 'Page down' to move to the next record, then even if validation fails, the form will close (or move record). What I want is for the user to be left with the form open, on the current record.

Can someoneon point me in the right direction ?

Thanks,
StepOne

View 1 Replies View Related

Datasheet Navigation Events?

Sep 27, 2005

Ii there such a thing as events fired by Navigation?
I have a Form displaying records in a Datasheet which has a Navigation
control and I need to be able to detect when the User selects various parts of this control.

View 1 Replies View Related

Events Calendar Date HELP

Mar 3, 2005

please help!

I have added a calendar into my site, I have a new table in my access database called: Cal

I want to ADD AN EVENT

The records I have in that table are:

eventID
eventTitle
eventDesc
eventDate

so I designed my ADD NEW EVENT form

my problem is:
what do I put in the form for eventDate (3 select form fields? Day/Month/Year?) it doesn't work??!

View 3 Replies View Related

Table After Events Not Working

May 20, 2014

I am just starting find my way around Microsoft Access However I am currently stuck on something to do with table events (data macros).I added a Before Change and After Update macro to a table and added a RaiseError method to each of them.

I tried to update a record in the table. A dialog appears corresponding to the Before Change method. I deleted the Before Change method and then once again tried to update the table. No dialog box appears The After Update macro does not seem to fire.I tried all the other "After Events" and nothing seems to fire.

View 1 Replies View Related