Search results

Hi, I have a form with a list box (lst) and a button (cmdbutton), I have a stored query (qry). I want to click the record, then click on the command button and run the stored query to update the record selected in the list box? Thanks

Hi, I have a login form and a table of users. In the table of users there is a column called TempPFlag that is set to '1' if the password has been reset. I have the following code and want it to first check if the username and password entered matches what is in the table but also check if they...

Hi, I have a list box that is used for navigation. If the user clicks on a list box item (row) then open the from with that name. I have a table tbl_controls that haves [ID].[Form Name]. I.e on click, lookat column o of the listbox and open the form that match the ID in the table What is the...

Hi, my form has a textbox (txt_PIN), when the text box is updated i want to check the user table to see if it already exists. I keep getting errors, i think itt is because of the way the numerical value is being referenced? Private Sub txt_PIN_AfterUpdate() Dim PIN As Integer Dim...

I have a form with 5 unbound checkboxes (chk_1, chk_2, chk_3, chk_4, chk_5) I want to click on the checkbox, then click a a save button (On click event btn_save.Visble = True) then to insert the value (0 (unchecked) 1 (checked) into the tbl_data.Chk1, chk2 etc Thanks

Hi, I have a form with a subform. On this subform i have a report and a list box.I want to be able to click on the listbox item and then display the record details in the report. I have tried this code: DoCmd.OpenReport "Report", acViewPreview, "[ID] =" & lst_Items.Column(0) but because the...

Hi, I have a form that populates information from tbl_home. The bound text box on the form is txt_ID How do I update column tbl_home.Project where form.txt_ID = tbl_home.ProjectID?