Search results

I am trying to update a table It is tbl_incident from data on a form called frm_edit I am using the following code, and instead of changing only the information that corresponds to the Date_of_Incident , it is changing all entries in tbl_incident that have the badge number. I am stumped as...

On the frm_edit in my database, when the save button is clicked, I open frm_info as the last step. I am at a complete loss as to how to close frm_edit. frm_info pulls the field "Badge" from frm_edit to open frm_info. I can't close frm_edit prior to opening frm_info because of that. I am at...

I have a query that looks for previous entries and then makes updates to a table. Is there a way to keep the query result window from showing but still use the results? This will eventually be a user interface and I don't want them to see the window.

Ok, I have a query that is executed when a field is double clicked in a subform Here is the query SELECT tbl_incident.Date_of_Incident, tbl_incident.Badge, tbl_incident.Description, tbl_incident.Code, tbl_incident.Comment, tbl_incident.Points, tbl_incident.Drop INTO tbl_previous FROM...

Let me preface this by saying thank you in advance, I got stuck with a project at work and know next to nothing about Access programming and am trying to fumble through it. My Tables are: Badge Date_Of_Incident Description Code Comment Points Drop Date Here is what I need. The Drop Date...