An Access database is not a file in the same sense as a Microsoft Office Word 2007 document or a Microsoft Office Power Point 2007 slide deck.
Instead, a typical Access database is a a collection of tables, plus a set of objects built around those tables — forms, reports, queries, and so on.
is it possible to update a table using the records on the listbox? You will need to provide specific info for detailed How To i know how to work with update but am not sure how select query works. what i want really is a listbox using a temp_table as a record source, upon exit on the form, once the user exits and press save (the form is unbound). Refinance Repay ID) Is Null));", db Open Dynaset) Msg Box rst!
say you added new record so in the temp table then append the records to the perm table. i have used update mysql but i only know how to use this on a single field but have not found success or know the proper way to do it with a listbox. Once you are satisfied you have the correct Recordset, click for the query to be changed to Update. is the basic step one of query/sql/mysql A List Box/Combo Box can use a table as it's Record Source. Refinance Repay ID) Is Null)); 'check data on record to determine if Refinance ID is required If Pay Method = "Refinance" Then If Refinance ID = 0 Then 'Refinance ID is required 'set control properties to allow use Refinance ID.
The query "qry History" is set at runtime through VBA; I've looked at the query and the expected results are in it. FAQ181-2886: How can I maximize my chances of getting an answer?
After the query is updated I call the .requery procedure for my Listbox control but the listbox does not update. Thanks, David What about replacing this:your List Box.
In addition, those objects must adhere to a set of design principles or the database will either work poorly or fail altogether.
A control on a form will update by a combobox/listbox.
The other problem was you didn't set the Row Source string correctly.
Microsoft Office Access 2007 provides a number of tools for updating existing records, including datasheets, forms, queries, find-and-replace, and the new Data Collection feature.
Your choice of using a Temp Table should be for some other reason then to supply records to a form Control.
If you use a Temp Table you need to be aware of the code looking for the table when it may not yet be created. guess that's the side effect of learning this differently than normal. ADPK)=DLook Up("[ADPK]","TBLLOAN","[ADPK]=" & [Forms]!
If you then wish to Automate this you include your working sql in vba code on your Form/Form Control and all should be fine. Recordset Dim lng Old Loan ID As Long 'Loan ID to be Refinanced Set dbs = Current Db 'populate variables lng Old Loan ID = Loan ID 'Check if record exists in Tbl Refinance for this Loan ID and Repay ID combination Set rst = dbs. Old Loan ID)=" & lng Old Loan ID & ") AND ((Tbl Refinance. Record exists in Tbl Refinance but SID not recorded in Tbl Refinance - allow user to populate the combo box With Refinance ID . Old Loan ID)=" & lng Old Loan ID & ") AND ((Tbl Refinance. Refinance Repay ID = " & Repayment Ref & " " & _ "WHERE (((Tbl Refinance. Requery then allows the form to display the data and not allow any further activity in the combobox. what i planned to do with the delete was move it in another temp table then of the id is found on the tbl_delete it would delete.