Search results

My objective is to create a backup and restore of all the tables in my DB, I have viewed many ways of doing this, most of the threads in the forums relate to exporting from Access into an Excel workbook, I would like to: Backup - Export the Tables into a specific folder as separate workbooks...

I have a main form "frmContactsNew" which has 2 subforms "frmCustomersSub" and "frmContactsNewSub" "frmContactsNewCustSub" is the results of a search using the search as you type method "frmContactsNewSub" has a record source of tblContacts The objective is to search for a customer then add...

My scenario is to create a form where I can search for a customer then edit their associated Contacts I have a main form that has an unbound text box "txtSearch" that searches the Customers Table, using the search as you type method, the results are populated in subform -1...

I have a form which uses a combo box to populate fields in a sub form which works as it should, the issue that I have is that I wish to use this form as a sub form. The combo box "txtSearch" is in the Header of form "SearchCustFrm" this has the control source "SearchCustQry" column "CustName"...

Hi I know that has been asked many times before as I have read through almost all of them, but I just cannot get it to work. I have 2 tables Payments and Payments_Import I have a web portal for my work, any payments made to me is listed in a spreadsheet in the portal, which I copy into an Excel...

Hi All, I have a search form based on a query "completed_addressqry" which has 2 tables "Completed_Addressed" and "Payment" the search works fine. My issue is that some time ago I began to capture the full address not just the suburb, so I updated the query "completedqry" which was based on 2...

Hi All I am trying to append the results of a Select Query, I have read about and tried many variations, but can not get it do want I want I have a Query that is based on 2 Tables "TblCustomers" and " TblCustomersData" both Tables have identical Fields When I run the Query I would like to...

Hi All I am using a query to compare the "Address" field in 2 tables "TblCustomersNoDuplicates" and "TblCompletedJobsAddressed" The query below works fine but I would like to have all duplicated addresses displayed I attend households and businesses to complete service work, therefore, there...

Turn off "Microsoft Access can't append all the records in the append query" Hi All I have an Append Query to add records from "TblCustomerImport" to "TblCustomers" the problem that I have is duplication of the existing records in"TblCustomers" I have tried the SQL below: INSERT INTO...

Hi All Previewed many posts over the years, finally took the plunge and joined. I have been using Access for a few years, I have learnt a lot by searching through posts, reading, videos etc, managed to work through most problems. DavRob