Search results

I'm using the Dlookup and it's not checking the case sensitivity, Upper or lower case doesn't matter. What else do I need to do to the table or form in order to check the case?

when the application hanges and you go the code window, type in the immediate window ?username.value and hit enter it should give you what the value will be in your combobox, correct? if you don't see the Immediate window go to menu item View and select the Immediate window, this will open the...

still need the quotes around the table name.. That i'm sure of.

here is someone elses response to a earlier post For text data: dlookup ("Field1Name", "TableName", "[Field2Name] ='" & SomeVariable & "'") For Date data; dlookup ("Field1Name", "TableName", "[Field2Name] =#" & SomeVariable & "#") For numeric data; dlookup ("Field1Name", "TableName"...

when you get the error and you click on the debug button what is highlighted?

i did a search in access this is the correct dlookup format DLookup("[LastName]", "Employees", "[EmployeeID] = 1") Notice the quotes around the table name. in the example they hard coded the number 1 or Employeid, this is a good way to debug your code. After looking at your code again...

I may be wrong but I would try this DLookup("[Password]", tbl_SystemUsers, "[UserID]='" & UserName.Value & "'" when you have a numeric value you sometimes need a single quote around the value.

put quotes around the table name "tbl_SystemUsers"

Well this is weird, the line errors but seems to doing the transfer anyways?? This is sick..

this is the code i'm using DoCmd.TransferDatabase acExport, "Microsoft Access", StrApp, acMacro, "Create New Field", "Create New Field", False DoCmd.TransferDatabase acExport, "Microsoft Access", StrApp, acModule, "Adding Field", "Adding Field", False the StrApp = the file path of...

thanks for your response, I guess I should have been a little more clear. I have been programming in Access for many years. I have check all the items you suggested. I checked all the references and made sure the security was allowing macros. everthing is ok there. Like I stated before...

I have been using this command in an application for a long time all of sudden the command is not working on one of the machines using the application. This application is still in mdb format, the main reason is not all the machine is using the 2007 or greater version of Access. Has an...