Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gurbaitis

    HOt to let the user specify the location of an Excel file output from

    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!
  2. gurbaitis

    HOt to let the user specify the location of an Excel file output from

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

    How can I copy the value of a cell from Table2 into Table1

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

    How can I copy the value of a cell from Table2 into Table1

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

    How can I copy the value of a cell from Table2 into Table1

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

    How can I copy the value of a cell from Table2 into 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...
  7. gurbaitis

    How to have 1 Sub call a 2nd Sub after closing a query

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

    How to have 1 Sub call a 2nd Sub after closing a query

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

    How to have 1 Sub call a 2nd Sub after closing a query

    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!
  10. gurbaitis

    How to have 1 Sub call a 2nd Sub after closing a query

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

Part and Inventory Search

Back
Top