Search results

Yes!!! Thanks so much Mark, all of this stuff is starting to make sense :)

Good to know. I have the coding for the timestamps set as: Private Sub btnRPRLLogout_Click() With CodeContextObject .DateOut = Date .TimeOut = Time() End With 'Timestamps DateIn mm/dd/yyyy, and TimeIn column hhmm (24hr) MsgBox "Paperwork Sucessfully Logged Out"...

After my last post and before you responded I also came across this option. Is this describing a similar approach to what you are saying? See the last response on this page...

Thanks for the tip Mark_, I know nothing on subforms, so I'll start researching that. Just so I have an idea of what you are saying, for option 2, I have a form which will allow me to select the batch, and the subform is what will have the multiple records format to allow for editing on a...

I've got that part down, I'm applying "Between (Now()-2) and Now() to the Date field and that part works. I've got two options going forward with my design I think. 1) Make a multiple records form that has all the editing fields, with a combo box on the batch number field. When that box is...

Now comes the experimenting since I want to drive the form with a combo/list box that populates from a query that will only show the batch #s that were entered in the last 2 calendar days... hopefully I won't break my brain/database too badly :D

Hold on, may have just found the answer to my own question in this thread: https://www.access-programmers.co.uk/forums/showthread.php?t=213540 I'm exploring this option right now, but if anyone has other ideas, I'm all ears :)

I currently have a form which is populated by data pulled from a single parameter query [Enter Batch Number to be modified]. When I open the form an the popup appears, if I enter a batch number that exists in the table, it returns the appropriate record to the form. If I enter an incorrect...

We can get values that range anywhere from 0.00 (less than one minute by our current system) to something that may span 3 days. We are always looking for something in hours down to 0.01

Thank you for the simple explanation on why code will be better. I'll start digging around and see what I can find

Thanks! I'll start digging through those

Okay, so I've dug around here and found several ways to do this, but none that meet my specific need, or the solution isn't clear enough for me as a new Access/VB user to understand where to implement it. My dbase has a table to track samples that come into our chemical lab for QC approval...

Welcome Titan! I'm a new Access dev. and new to the forums too. I think you'll like it here. Definitely one of the better forums I have ever used for research!

I'm going to consider this thread closed, since the discussion is mostly over on the other thread: https://www.access-programmers.co.uk/forums/showthread.php?t=298348

Right after I posted that code, I corrected it in VB and now I am getting a compile error. So allow me to post the code correctly below. modDateTimeIn: Public Function DateTimeIn() As String DateTimeIn = Now() End Function Code from the Form I am using which runs (according to the popup...

I tried it both ways, and using just DateTimeIn doesn't work at all. But if I use modDateTimeIn.DateTimeIn it finishes out the script, but the record is never added to the table?

Ahh okay, so you use a similar naming convention where modCustomExports is the name of the module and the subroutine inside could be called Custom_Exports() That makes more sense Using that naming convention, I have this module: modDateTimeIn Option Compare Database Option Explicit...

Wait, don't you write subs and functions in modules to use in other places? IF that's the case then what do you call them?

So if I set the module to: Function DateTimeIn() As String DateTimeIn = Now() End Function I get the same error. But if I put the main button code as: Public Sub btnLoginPaperwork_Click() With CodeContextObject .DateTimeIn = Now() 'Timestamps DateTimeIn Field Beep End...

Option Compare Database Option Explicit Private Sub btnClosefrmRPRLLogin_Click() DoCmd.Close 'Closes Form on Click End Sub Private Sub btnLoginPaperwork_Click() DateTimeIn 'Timestamps DateTimeIn Field MsgBox "Repack/Relabel Paperwork Sucessfully Logged In", vbOKOnly, "Thank...