Search results

A pleasant Good Day to all members and programmers of World Access Forum World Wide!! :);) Dear Sir, I have a question about for combobox. I have a field from my tables that a text only then I make in the look up property field to become combobox then row "source type is a value list"...

Sir, Thank you so much.... now I've done my Database thank you for both you and Mr. Gemma... thank you so much... and more power!

ah.... "VEHILCE INFORMATION FORM" AND :VEHICLE EVALUATION FORM" hehehhe! Thank you so much sir... :)

Thank you Sir,, so much.... but sir can you do in my last reply about in the combobox in the form for FIND RECORD.. thank you much.. :)

and also sir, please help in my thread before that I want in the combo box showing if there's no record, there's a msgbox will appear no record found.. please sir.. fix that for me... in the form sir, in the label FIND RECORD. and combobox for search.... I want that if there's no record found it...

I attached my database... please try to help me in the log-in file... its almost Ok but the problem the first username are change to number 1, 2 3 & 4... I will become crazy for this.... :( :'( Please Sir, I'm begging for your help.....

Sir, there's a big error.... I put an unbound textbox to be get the value of empass to emplogID and empname and it will become BIG ERROR... please see the attached pictures screenshots. after I follow what you said the SQL COMMANDS it will become big error.. please help me.... waaaaaaa :( :'(

Ok sir,, I get now and its working Properly now... check the attachment and its working properly now... but I have another question.. I want in the form load the txtempass will not showing the password automatically.. becoz when the form load its showing the password. and also one more.. I want...

the emlogID is a Auto Number empname is a text which is a combobox empass is also a text..

thank you for your response... but still an error mentioning "Run-time error '3464' - Data type mismatch in criteria expression" please find attached printscreen for your reference. please help me.. thank you so much.... here's another printscreen with highlight debug...

sir this is another printscreen for your reference therefore you can help me... Please sir try to help me... thank you so much... Thanks,

and also the coding of my username and password form I refer only on this site... http://www.databasedev.co.uk/login.html

ahh... Sir in the table the field name is.. LogempID - no caption I put empname - the caption is "ENTER YOUR USERNAME" empass - the caption is "ETNER YOUR PASSWORD" I put the caption in the table properties that's why in the printscreen it showing the caption not the exactly fieldname.. but...

Sir, I already found the site your recommend to me.. I try many things, remove the [] and remove the double quotes arrange my fields but still dubug the codes... can you look at the if else statement..? in your opinion, the arrange is correct or no... only in the Dlookup function the code is...

Dear Sir, I have an error message or debug message in my code in username & password log in.. it has an error in if else statement empname is a cobobox empass is a txtbox logempID is a autonum I.D usrnmpass is a table name there's an specific record in a table of usrnmpass showing in the...

this is the given code from macro when I used the combobox for search.. -afterupdate property field -SearchForRecord Action where condition = ="[asstnumbr] = " & "'" & [Screen].[ActiveControl] & "'" that's is working whenever I select the assetnumber and I input the specific assetnumber it...

Sir, Please dont angry with me.. First the combo box is connected to the field in the query not in the table. I try to use your given function to me via expression builder this is what I Input.... If DCount("*", "[vehcleinfoquery]", "[asstnumbr]=" & "'" & [Screen].[ActiveControl] & "'")=0...

Dear Si, I want a Messagebox to be appear if the selected item or if the input item in the combobox was not in the record. I used this condition in combobox ="[asstnumbr] = " & "'" & [Screen].[ActiveControl] & "'" but when I try this run code function in macro via IFF will become error...

and sir, I want that if there's no record found in the search using combo box... there's a msgbox that will display... "No Record found in your search" waiting for your response... Thanks,