Search results

Hi Gasman Thanks for the reply The file I down loaded was straight from the web page, I had corrected the " in my module Thankyou again all is working now DavRob

Hi Gasman Thanks for the reply I have 8 tables I have set breakpoints as suggested it breaks at "tdf.RefreshLink and now get Run-time error '3024' could not find file "C:\Users\Dave\Documents\Access_Projectb" The code is adding the letter "b" at the end of the folder name...

Thankyou for all the replies OK I got it What I was trying to do is not the way to go I have now split the DB as suggested and setup Linked Table Manager I used the code that I found at https://www.microsoft.com/en-us/microsoft-365/blog/2012/08/03/automatically-relink-microsoft-access-tables/...

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...

Thank you for the reply Pat. I'll give it a try DavRob

you are correct I forgot to requery sorry

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...

Thanks Pat Always handy to have alternate methods DavRob

arnelgp Thanks for the feedback, I thought that there was a valid reason DavRob

arnelgp Thank you for the example it is exactly what I am trying to achieve. Could you please explain why the txtCriteria box is required, I have seen the dummy text box in other examples of search as you type but it seems to work ok without it. XPS35 Thank you for your reply DavRob

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...

Hi Thankyou for the replies Apologies for the late reply I still can't get this to work. I am trying to use a subForm to search records using the search as you type method, regardless of the approach it brings up the "Enter Parameter Value" dialogue box. I have added a sample DB

arnelgp Thanks for the reply, but still get the same outcome. Gasman Thanks also for the reply, I had forgotten about using them, I'll use them in future

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"...

Thank you for the prompt replies Jdraw One of the companies that I contract to uses a web portal to administer our up-coming jobs, invoices, payments etc, in regards to invoicing they use the Recipient Created Tax Invoice (R.C.T.I.) method which common here in Australia Ie they create our...

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...

Thanks for the reply I have tried a Union Query and it gives duplicate records, am I missing something. I'll do a cut down version to submit as suggested by isladog. DavRob

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 isladogs Thanks for your reply No error, I was getting no results from the query I have just realized that I have been over thinking this problem, so I am going back a few steps and taking a different approach Dave

Hi TheDBGuy Thanks for your reply, You are correct I Forgot the "Is" The code INSERT INTO TblCompletedJobsAddressed SELECT * FROM QueryName Is an Append Query, What I would like to do is to have a Query tor code that do both functions ie. run a Select Query then Append the results, is this...