Search results

Thanks very much .... i had done the [squarebracket] thing, earlier and i also removed the .Value. there was nothing wrong with the query syntax as u rightly said. the error was from a line directly beneath/after the query. me.cusname.enabled =true it had been commented out but became...

i tried this but nothing happened ... where would i see the printed stuff ?

Public Function MaxOID() As String Dim CUS As String Dim newCus As Integer CUS = DMax("CustomerID", "CustomerInformationTable") newCus = Mid(CUS, 5) + 1 If newCus < 10 Then MaxOID = "CUS-00" & newCus ElseIf newCus > 10 And newCus < 100 Then MaxOID = "CUS-0" & newCus Else MaxOID = "CUS-" &...

appreciated. thanks

Bro .... im tryna help someone with a problem, string would have been the ideal format, i know that. the INSERT worked fine, now im simply tryna resolve this UPDATE issue, do you have any suggestions for this particular issue ???

left off the .Value aspects and the same error persisits...

@theDBguy dude, hey wassup man. thanks for all the previous help and suggestions .... tired wat u suggested, and is the same problem

dude, yes, didnt you see the screenshot of the table structure ?? i used msgbox to ensure my variables were not empty. any suggestions on how to solve the problem ??

im a nub so lemme ask the most nubbish question, ...... how do i do that ?? the only way i kno of displaying a value thus far is to use MsgBox()

DoCmd.RunSQL "UPDATE CUSTOMERS SET Firstname = '" & Me.fname.Value & "', Lastname = '" & Me.lname.Value & "', PostalAddress = '" & Me.paddress.Value & "', City/District = '" & Me.city.Value & "', ContactNumber = " & Me.contact.Value & ", RegistrationDate = #" & Me.datej.Value & "#, Gender = '" &...

hey. took what u said and worked with it. this is the result. the error is this: is there any way to add an integer to a string and store as a new string ?? any suggestions ?? how do you typecast a variable in vba ??

ive tried, the value i keep getting is 0

i understand what you are saying. is there any way to split the CustomerID ? like in java u can split a string , can tht be done ?? additionally using DMax may be a problem since it retuns the max integer.. im just trying to increase knowledge and try to solve this problem.

works like a charm ....

WOW .... thanks a million man.

just did

YUP. did the Compact & Repair. then closed the file, then reopened. same eroor persists. attached is the file im working with. the from is called CUSTOMER FORM

never mind. i just remembered

no i havent. how do i do this please ?

this is the option button im talking about