Search results

Sorry still getting the runtime error

Sorry found a typo - updated and now get a new message " Run time error 2465 cant find field 'vehiclechecklistsubtb' referred to your the expression"

Hi have updated as you said but I am still getting the error message :-(

Thanks have tried the code out and I keep getting "Compile Error Method or Data Member not found" do you have any other suggestions !

Hi thanks for the quick response - just a quick question, when you say use the subform record set are you referring to the Record Source on the subform or would I have to put the command button onto the subform - sorry if I am a little bit slow to grasp this :-)

Hi, hope someone can help. I have a main form with a tab control. In the tab control I have a subform. I wish to update the data in the subform with values entered into unbound text boxes in the tab control on the main form. Main Form Name: VehicleDetailsFormUPDATE - Primary Key: VehicleID...

Yes we have success - many thanks for your help Arnelgp:)

Hi Arnelgp this looks great but how do I use it - I currently have a text box I wish to use on a form and thought I could use the control source but I am having no luck :-(

Hi Plog - it would be #StartDate# less #LeavingDate# or #Date() to give years, months, days employed by company et 3 years, 4 months 2 days

Hi thanks for getting back to me but this does not really address my problem.. I have a StartDate field and a LeavingDate field. I need to calculate the length of service from the StartDate to the LeavingDate in years, months and days taking into account that the LeavingDate may contain a Null...

Hi hoping someone can help. I am creating a personnel database and need to show the length of service as years months days from StartDate to EndDate. Where EndDate contains a null value then the Today () or Now() needs to be used. There is alot of info on the subject but none that I can find...

Hi thank you so much this now works a treat :o

Hi have attached a stripped down version for you :)

Hi the code is still in the AfterUpdate Event in the txtPassword box. The Me.cboUser refers to the combo box which has the following row source, Column count 0;1;0;0 with the UserID being numerical: SELECT tblUser.UserID, [Lname] & ", " & [FName] AS Fullname, tblUser.Password...

Hi its on this line Select Case Nz(DLookup("Access", "tblUser", "AccessLevelID=" & Me.cboUser), "N/A")

Hi sorry but I did not know what a code tag was - just googled it so now understand. Just wondering if you have any insight on my runtime issue :o Select Case Nz(DLookup("Access", "tblUser", "AccessLevelID=" & Me.cboUser), "N/A")

PS - I did paste the coding indented but this website has justified the lines :-(

Hi JHB thank you for your reply and your good advice - will make sure I will Indent and use code tags and the first problem is sorted but I am now getting the following debug message: Run time error '2001' you have cancelled the previous operation. 'Check that User is selected If...

Hi all hope you can help - I have the following vba code but I keep getting the End If without Block If error message - cannot figure out what I have done wrong - can anyone help please Private Sub txtPassword_AfterUpdate() 'Check that User is selected If IsNull(Me.cboUser) Then MsgBox...

Hi thank you both for replying - this is what I get for not being totally awake and working on Access - put the code behind the buttons click event and it now works beautifully thank you both for your help. Pauline