Search results

Thanks guys, you inspired a thought which I believe may work. If the Fail button is selected, the record is saved to the table but in the background another form opens with a timer (10 minutes). At the end of the 10 minute timer it executes a query to return a true false statement based on...

This would be the process 1.) User enters name & checks appropriate check box of test result 2.) If user selects Pass check box, record is saved no additional actions required 3.) If user selects Fail check box, record is saved & a "count down" begins (10 minute count down). If that user does...

Thank you for your prompt response. I have since added a date/time field for each record. How do I automate the execution of the query 10 minutes after the initial Fail entry record was saved into the table? I only need this query to run when the entry check box for Fail is selected. Thanks...

Hello Everyone, I am using Access 2007 & trying to update a database to include a check & balance. Currently a user enters their name into a form, selects a check box (Pass or Fail) & clicks a save button. Real simple form. The actual testing is performed on a standalone piece of equipment...

Hello Gentlemen, I have a Word doc with some form fields. I would like to save the form with a file name based on the data entered into the form fields. Example: Field 1: Job # Field 2: date File name to be saved as: Job# date.doc Thanks in advance for your help.

You are amazing! Thanks for your help Bob, I really appreciate your input & expertise.

The parent Record source is: tbl_SignIn The subform Record source is: tbl_SignOut subform The forms are table based. I have attached the database for your review.

Thanks for your quick response, but no neither form reference each other in the Record Source.

Hello All, I have a strange error that I can not figure out what is triggereing it. I have a subform with 2 required fields. As I am typing data into the first field an error message window prompts specifying the data in the second field is required. Why is this premature error coming up...

Hello All, I was looking for assistance in creating a feature in my form. I would like for a subreport to open based on a desicion made in a form. Example: If an item was classified as bad , I would like for a subform to open & require additional details. The required details are specified...

Hello All, Some back ground on my DB: 1 Main Table fed by many sub tables. The sub tables are all lookup tables to create drop down boxes for the main table. For the sub tables, column 1 is the ID# & the second column is the actual data. I made sure the bound column was 2. When running the...

Hello All, I am interested for my query result to be exported to an Excel file. What code is required to prompt the user to define a file name. There are multiple people in this DB & multiple PCs so a defined file name or location is not possible. Thanks in advance

For some strange reason a pre-existing select query did not allow for a field to be updated. I created another select query and whatever was blocking that update was not present with the new query. Unless someone would like to explain this wierd occurrence, I would consider this issue closed.

Hello All, I have been away from Access for a while & I forgot how to a create a query where in a Datasheet view I can enter data & it will update the table. Thanks in advance

Almost there... Thanks for that sample DB! My command is stalling on this section of the script: 'open the report, restricted to the selected items DoCmd.OpenReport "rptEmployees", acPreview, , "EmpID IN(" & strWhere & ")" I can't seem to find my equalivalent to your "EmpID". An...

Hello All, I apologize for the question as there are many threads on this topic already, but the method for the multi-select list box is not clear to me. What do I have to do in order to make a multi-select list box? My query is looking for the entry on the form but I do not know how to present...

I was able to insert the qry as a subform within the form in question & that works well. Thanks for your help!!!

Hello All, I was wondering if its possible to open a form & display a query calculation on the form? Here is another curve ball, the query is based on a field on the same form. Any ideas or suggestions?

Thank You very much!!! That code worked perfectly. Have a nice weekend.

Hello All, May someone provide me with the most simple method to lock one field on a form after its data has been entered. Is it a simple After Update event procedure? Thanks in advance.