Search results

Bob I hope i'm not being a pain but i dont understand what you are saying here.

thats exactly what i'm doing. On mouse down/click, the calendar is called, date is selected from calendar to combo by the on_click event without any problems but its as though the form is not updating the combo box when a date value is selected because after_update on the combo, a query should...

This question involves VBA as well so i hope i am in the right area. I have a form that has 2 combo boxes and a calendar control. I also have a datasheet subform in the form. I have set both combo boxes to call the calendar on mouse down and whatever date is selected off the calendar writes to...

Hey Bob Quick update for you...should have got back earlier. The above didnt work. Still generates the error message. Ended getting what i needed by going through the close button onclick event with another piece of code. Thanks for looking into this anyway

I have attached a test file where you can see your code being tested Bob and it fails on both vbyes and vbno

Ok As per your suggestion, this is what i have now in my before update event. I really appreciate your patience looking into this. Private Sub Form_BeforeUpdate(Cancel As Integer) Me.lstloan.Requery If MsgBox("Are you sure you want to abandon changes to this record?", vbExclamation +...

Hey Bob Thank you for getting back. My code was updated in the after update event because if the user didnt make any changes i didnt want anything to happen. I only wanted a popup box if changes were made to the record or a new record was created. When i run the code above in the afterupdate...

Just like i thought. The close action does not appear to work on Before or After Updates. I actually have my code in the afterupdate because I will like for the form to only request for a save if the user makes any changes My code is as below Private Sub Form_AfterUpdate()...

?? Can i close a form using the before update event..thought i could only do this from Unload or close events Are you saying putting a docmd.close in the before update should work?

I have spent the whole day trying to figure this thing out and must say my patience has run out. This is very simple logic. I have a form that opens as a popup and a new record when the user clicks a button (open form). If the record is new and no data is inputted, when the user closes the...

Ok Scooter. Again thanks a mil for all your support men..

You know...never mind my previous question...I tested it and it works like a charm. Truly appreciated Scooter...and also thanks Bob for looking into for me the other day. Well Done to you.

Scooter...Quick Question...I'm testing now but the issue i am thinking may come up is that I am comparing against a query..ie Select field from FieldNameFromTable Where condition is true. Doesnt the above line of code just compare of a whole field as supposed to a query that populates the...

Scooter...You're the man..This is exactly what i needed. I am going to try and implement this into my main database..I appreciate your help in this. I am kinds new to VBA so may need to go over some tutorial on loops and listbox iterations. But nice idea to compare details to the table as...

Hey Guys Sorry i wasnt able to get back yesterday..The nature of work. I have created a very simple database and form that demonstrates what i am trying to do. The user will enter text in the text box and if the entry exists in the listbox, a message box should popup saying ("This value is...

Hey Scooter Thanks for the code. I'll implement the code and test. Thanks again for the help.

thought as much. I'll get that round for you when i get into work tomorrow Thank you Bob

Not sure if that will work as i have some queries in here running of a SQL server. I will see if i can export the tables into a new database and the form in question..Bob you rock men..Thanks for even trying to look into this for me...i'll get back in a sec

As per your suggestion i ran code like so Private Sub cmbstag_AfterUpdate() Me.cmbasset.Value = Me.cmbstag.Column(1) MsgBox ("This laptop is a test" & " " & Me.cmbasset.Value) End Sub Its pulling the correct name everytime...the list box runs off a sql query that is also pulling the correct...

Well I give up...The text is updated in the cmbasset text box but does validate or generate any message boxes even with the value in the list box entered. I have tried this also in the afterupdate event of the "cmbasset" textbox and still no luck. Thank you for the input Scooter. I might just...