Search results

Hi @Isaac , As they say, every time you make something idiot proof, they invent a better idiot... I came across this because I have a custom module pulling in the date entered in this field to calculate the number of business days elapsed from the date of receiving to the date of entry to our...

@MajP , this is in fact Access, I referred to it as a cell because it's a single cell on a datasheet view of a form. Is there no way to do this using the Validation Rule property of the control? I'm fine to add it as an event in the after update property if I need to, but the validation rule...

So the SQL view you can switch to when you create a query? Interesting. I expected it to throw an error for not having a FROM clause, it didn't--it threw up prompts for each of the fields (EmployeeID, DocumentID, Forms...txtDate, Forms...txtNotes, Forms...cbSuperID). If I open the form before...

Hello all, I am trying to make sure that the entered value in my form is a date. I've avoided using an input mask because I don't like the UI problems inherent with those--gotta enter dates with 4 OR 2 digit years, but not both, for example. Is there a way to retain that sort of flexibility...

Ah, okay. That's one step closer. I'll play around and see what I can do. Forgive my ignorance, what's QBE?

Thanks @theDBguy . These forums seem super friendly and helpful. Tagging @arnelgp too here-- Weirdly, the SELECT query could/should potentially refer to more than one record. It's in a textbox control displaying a field from an underlying recordset, which does frequently contain multiple...

Hi Pat, thank you for your help here--I would agree that the statement shouldn't work, and yet it absolutely does, somehow? As in, it successfully selects the appropriate record when you double-click the the lastname field, and inserts it to tempTraining table, adding the fields completed on...

Hi all, Brand new to the forum but here because I was working on a highly similar situation. Interestingly, the database I'm working on uses the DblClick event to do exactly what OP is describing: shunt the selected record into another table. The overall purpose is displaying a list of staff...