Search results

Thanks for the initial responses.... I have attached the actual DB to this note.... Password = 123 All the code exists under the login form.....thanks in advance for your assistance

I have this Code on a Login screen to an access database.....The Login works as expected...My only issue is i have to click on the OK button twice for the login process vs a one click.....Cant figure out whats going on...any assistance will be greatly appreciated...

Thanks on the Normalization Issue.....was able to get the desired results and it works as expected: SELECT [New Discplinary Cases].[DAN No], [New Discplinary Cases].LNAME, [New Discplinary Cases].FNAME, [New Discplinary Cases].[Pass No], [New Discplinary Cases].[Violation Number 1], [New...

ok tried the =3 ....it only returns an exact match from the first column

Can anyone Help.... I have this code running which works fine....except that it returns values like 33, 34, 63. I would like it to find an exact match IE: "3" SELECT [New Discplinary Cases].[DAN No], [New Discplinary Cases].LNAME, [New Discplinary Cases].FNAME, [New Discplinary...

Thanks Plog. I will redesign the Db as you described and create necessary links to see how it works out. thanks

Thanks for the explanation here: With regards the query.. Access added all those additional fields when i started testing out the form. My initial query had only one criteria in each field Criteria ...Everything below the OR field was added automatically by access when i started using the...

Thanks All. I have uploaded the sample data...If you go into query design you will see all the additional lines access added (im still not sure why) The query also does not filter the data correctly from the form. Im totally confused on this one.

SO i'm using a form to filter data via a query: I have this code in there and it works perfect: SELECT tblEmployeeMaster.[Charge RC], tblEmployeeMaster.[First Name], tblEmployeeMaster.[Last Name], tblEmployeeMaster.HDQMGT0084, tblEmployeeMaster.HDQMGT0085 FROM tblEmployeeMaster WHERE...

Thanks, Your last comment mad me realize i had it reversed: This works perfectly Combo27 = DLookup("Desc", "[HPEMProblemCodes]", "TaskCode= '" & [Problemcode] & "' And [category] = '" & [Temp1] & "'")

Cj, Here is the setup of my table: Taskcode ----- Description ------------Category 12345-----------Repaird Device --------Production 12345 ----------Replaced Device --------HPEM (Ignore the dashes of course..only used to line up the text here) When i run the lookup on taskcode=12345 and...

Th lookup table HPEMProblemCodes consists of 3 columns: Taskcode Description Category In the three columns, Only the Taskcode are the same... Description and Category are all different.

i got this to work with the additional "&" to the end. However it still does not return the correct record...returns the first record Combo27 = DLookup("Desc", "[HPEMProblemCodes]", "TaskCode= '" & [Problemcode] & "' And [Temp1] = '" & [category] & "'")

Thanks CJ, But i got a compile error on execution

HI All, Need some assistance with a dlookup code…..I previously had this function which worked out to my needs..... Combo27 = DLookup("Desc", "[HPEMProblemCodes]", "TaskCode= '" & [Problemcode] & "'") Now I am trying to add a second criteria to the dlookup where temp1 in my form must also...

arnelgp, I tried your formula but got an error 3464 - Data type mismatch in criteria expression. However in comparing your formula to mine...i reversed the criteria like you did and that seemed to have worked.... Combo27 = DLookup("Desc", "[HPEMProblemCodes]", "TaskCode= '" & [Problemcode] &...

arnelgp, I have renamed the tables and forms to remove the underscore as recommended by another user: ---------------------------- Option Compare Database Dim currentdb As String Option Explicit Private Sub Problemcode_Change() Combo27 = DLookup("Desc", "[HPEMProblemCodes]", "Problemcode=...

Galaxiom..thanks for the response... I created a new thread but unfortunately cannot post links as i am a new user. ----The Change Event fires every time a character is entered or deleted in the control. Probably not what you want. -Yes, this is how it is meant to function. -----The...

Can anyone please assist: I have this dlookup code setup..but for some reason i only get the first record....I tried several things but cant seem to get over that hump... Anyone please assist. --All fields are setup as short text in the table. However Task_Code is a numeric value Option...

DLookUp return first value only Can anyone please assist: I have this dlookup code setup..but for some reason i only get the first record....I tried several things but cant seem to get over that hump... Anyone please assist. --All fields are setup as short text in the table. However Task_Code...