I finally had a chance to get back to this little project of mine.
Through a bit of reading, and trial and error, I figured out that this was the syntax I needed to use for my Dlookup to make it work.
If IsNull(DLookup("JobName", "Table1", "JobName = '" & Me.Text0.Value & "'")) Then
I do...
There is only a single record for each Job. The times being logged pertain to the job being put in an oven, "TimeIn" and then, when the job is removed from the oven, "TimeOut.
It's even more simplistic than that.
I just recreated this table based on your feedback with an AutoNumber PK. JobNames are unique and when the input is provided, it should add the record if it doesn't exist, with the current date/time in the TimeIn value. That piece is working. If the...
Perhaps that is part of my underlying issue. My PK is the JobName field. I'll run with your statement that my table is not correct and work on that, but I am also trying to update a different value (TimeOut), if the record exists.
I did notice that and that's why I was tinkering with that piece of the code, but I'm very unfamiliar with vba and having to research anything that doesn't make sense one piece at a time. Your suggestion corrected that runtime error, but it now gives a message that states "The changes you...
Once I set the Record Source for that textbox to Table1 that works perfectly to add a record with the current date/time in the TimeIn Field. Now, if I attempt to add a record that already exists, I get a run-time error 424 (object required) and refers to this line: "Set Me.Bookmark =...
I just tried this. While it will take the input I provide, and add a record (if it doesn't exist) to the JobName field, I additionally need to have it add the current date/time to the TimeIn field associated with that record. Also, if it already exists, add the current date/time to the...
I suppose it wouldn't hurt to explain what I'm trying to do to...
I want to provide input from a text box. If the record does not exist, and the new record from the input to the JobName field, and add a timestamp of the current date/time, in a "TimeIn" field. If the record already exists, add...
Hi Cheeky and thanks for the greeting and quick response. I'm VERY new to VBA, in fact the last time I really did anything with VB was in 1999 with VB6. I recall very little of that class. Anyway, JobName is a string. I added the piece to enter a job number if missing because if I double...
Howdy,
I've been struggling with this for a bit and suspect I'm missing something simple or not doing it in an appropriate manner. I have a form that takes user input and it works to update a record if it doesn't exist like I'm expecting. My struggle pertains to checking to see if the value...