Search results

Nothing? That sucks...

My database imports CSV files containing 'answers' to test questions. I have a query to calculate the error in the analysts answer. My problem is each test has 12 questions and should have 12 responses from everyone, but it is possible that analysts may only provide 8 responses. Right now the...

I have a database which will search a directory and all of its sub-directories for CSV files matching a certain format (60+ files at a time) and import them into a table to be processed later. These CSV files are generally created and then opened by multiple users for analysis. My current...

Ty Thank you, this helps me out very much! :cool:

This is what i placed in the code section: Private Sub PGID_Field_BeforeUpdate(Cancel As Integer) Dim PGID As String PGID = YourScannedInBarCode Band2.Execute "UPDATE InOut Status SET DateIN=" & Date & ", TimeIN=" & Time() & " WHERE PGID='" & PageID & "';" End Sub I am...

These records already exist, they just do not have time + date values yet. That default value you are talking about does not apply when you want to modify a record...

Yep, i need some sort of script that will do it automatically, i had one that does this when i press a button, but when i do get this running, i will be scanning about 200 items each time, so adding a button press could complicate/ruin the routine. I cant really set that script to run untill...

I'm not entirely sure on how to work this but, How would i create a form/script that would update a record with the current date+time a field based upon the data in another field. ---------------------------------------------------------------- Example: I type in a PGID into a form drop down...