Search results

I'd like to re-visit an old problem. If the problem required viewing the database I can strip out the data and e-mail it. I don't want to post it though on the forums. On the combo box on the form Row Source Type = table/query: Row Source = SELECT EmployeeMaster.EmployeeID, Lastname & ", " &...

Hi All, I am looking for a small code example as I wouldn't be able to code it. I'd like to use the control 'On Got Focus' and have the text flash only while the text box has the focus. After the focus is lost then I wouldn't need it. I now flashing text can be considered annoying, but I was...

Can IDENT_CURRENT be used in Access 97 or above as shown in the example below? Set delayTable = db.OpenRecordset("SELECT * FROM tblDelay WHERE DelayId = IDENT_CURRENT('tblDelay')", dbOpenDynaset, dbSeeChanges) When I go to Debug->Compile Loaded Modules I get no errors. When the code runs then...

DoCmd.OpenReport "JSA", , , "[JSANo] Like 'B*'", and "[Area] Like 'Knife'" I get a Runtime error 13, data type mistmatch. I have played around with this for a while and here is what drives me crazy. It will test clean in the compiler and then throw the error at you when its run. Is Access...

Hi All, I am looking for what I hope to be multiple opinions on this. I'll be up front. I was over at Utteraccess and someone was trying to help me. I didn't quite follow the examples he was giving. Probably my fault and not his Here is what is going on. I have a form and on it is a comb box...