Search results for query: *

Thanks. Yes, that would work, but it would require them to not only type in the whole path, but know where it is exactly to type it in - which I know they are going to balk at. But thanks for the input!

I found this free code, which works fine: Private Sub ExportOneTable() 'EXPORTS TABLE IN ACCESS DATABASE TO EXCEL 'REFERENCE TO DAO IS REQUIRED Dim strExcelFile As String Dim strWorksheet As String Dim strDB As String Dim strTable As String Dim objDB As Database 'Change Based on your needs...

HQ - Please! Don't be sorry - I appreciate the help! That worked perfectly. Thanks!!

HQ - Thanks. Yes, I understood what you meant - in my case the line is: DoCmd.RunSQL "UPDATE Variance_Report SET eCommerce = 'Online' WHERE Variance_Report.Acct_Num = tblReportForms_eComm.COCDB_NUM". I've made sure I don't have a typo - the table is indeed tblReportForms_eComm & the...

HQ - If I add that, it prompts me for table2.MatchingField, instead of looking at table2 & finding all the matches. It's as if it needs to run through table2 for each record in table1.

Hello - A quick overview: I have a Table1 which reports on accounts that had a varrience. I have a Table2 which reports on accounts that managed their account online. I want to add a column to Table1 called eCommerce, and if they exist in Table2, put "Online" in that field in Table1...

The problem with that is that they're not exact duplicates, so it takes viewing them to make a judgement call. For example McDonalds, 123 Fountain, Hollywood, CA is, for us, a duplicate of McDonalds, 123 W. Fountain Ave., Los Angeles, CA. So we need the query to show the results (We base on...

The sub CmdLoadFIT1_Click executes properly, so queries 01 to 03a. It doesn't do CmdFIT1qry3b - queries 03b-06. Theoreticaly I need a user action event triggered by closing query 03a to start up CmdFIT1qry3b.

vbajock - true, that will do it. However, I'm trying to be fancy and not make the user have to do that (There are actualy more steps in the real process - I just cut out a couple as an example - so it would require a number of buttons). But thanks!

I have a number of queries that I'm trying to automate. The stickler is that one of the queries, a check of duplicates, opens so that the duplicates are displayed and can be deleted. What I want to happen is that once that query is closed, it procedes with the rest of them. How do I do...