Search results

thanks for letting me know about the UCase. I took it off and added Like "*" & and it works. Thank you

:banghead:Please help I cannot get this to work I have a form with a textbox name text_loc and users need to enter a row number for example "074" If I type like "*074*" in the query criteria it works but I need to grab it from the text box and it does not work. How can I get it to run? Ive...

I actually already tried that but it gives me a format type error.

How do I grab a value from a query and put in into a textbox? I need to grab the name that returns. I have attached an image so you guys can see Private Sub text_badgeRDM_AfterUpdate() Dim EMP_ID As String Dim strsql As String Dim sqlempinfo As New QueryDef EMP_ID = Text_BadgeRDM.Value...

Hello guys, I need help with this issue. I have a linked table called par3214_dms_user. In this case I will be needing User_Name and User_ID from that table (both are set to format type Text). In a form I have a text box named Text_BadgeRDM in which the user types in there ID number and...

dim rst as recordset set rst=currentdb.openrecordset("select username from tblemployees where userid=" & me.userid) me.username=rst!username set rst=nothing Thank you CJ London. It is working now. What about if I had a ODBC Connection and I need to use a table from there. What would I...

Someone please help with this issue. I just need to understand how to do it once and after that I can move forward. Something simple: -I have a table with employee information (userid, name, shift, etc...) -I have a form with 2 text box (user id and name) - how can i make my 2nd text box auto...