User Profile

Collapse

Profile Sidebar

Collapse
RadioWriter
RadioWriter
Last Activity: Aug 11 '15, 08:25 PM
Joined: Jun 26 '15
Location: Cincinnati, Ohio, United States
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • RadioWriter
    replied to ADODB.Connection General Error only for some users?
    in Access
    Yup. (Or, well, I guess I'm a little unclear on what a DSN is... After some fairly extensive searching, I'm pretty sure I've got this right.) Same file path, file name... I'm PRETTY sure this should be a DSN-less connection string anyway. It's an ODBC Driver. (I got the Connection String structure from https://www.connectionstrings.com/mi...dard-security/ <-- there)
    See more | Go to post

      Leave a comment:

    • RadioWriter
      started a topic ADODB.Connection General Error only for some users?
      in Access

      ADODB.Connection General Error only for some users?

      Hello all-
      Working on a tool which imports old Excel workbooks into a formatted workbook, then exports the formatted workbook to Access tables. It's working perfectly on my machine, but when my co-worker tries to run it, he gets "[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process" on line 6 of the following code-
      Code:
      Sub exportInformation()
    Dim cn
      ...
      See more | Go to post
      • RadioWriter
        replied to ADODB.Recordset Related record required
        in Access
        Not a problem. When I actually stop to think about it, it makes sense to keep the original questions in play (so others with similar problems can find the answer to whatever they've searched). I just hadn't really thought about it. ^^; I'll keep it in mind in case something similar happens in the future.
        See more | Go to post

          Leave a comment:

        • RadioWriter
          replied to ADODB.Recordset Related record required
          in Access
          Solutions Found - Assistance no longer required

          Sorry for the inconvenience-
          After posting I tried editing a few more things and found that all of my problems were caused by a space in the table name.
          See more | Go to post
          Last edited by NeoPa; Jul 14 '15, 12:18 AM.

            Leave a comment:

          • RadioWriter
            replied to ADODB.Recordset Related record required
            in Access
            Many apologies, Jim. The table being populated was called BOM Detail. But because of the space, the code was referencing a different table called BOM. The issue no longer occurs (added square brackets around the name). Thank you for your time, and I'm very sorry for the inconvenience.
            See more | Go to post

              Leave a comment:

            • RadioWriter
              started a topic ADODB.Recordset Related record required
              in Access

              ADODB.Recordset Related record required

              ADODB.Recordset Related record required
              Hi all-
              I'm working on a tool that exports worksheets from Excel to Access tables. On an Update statement, I'm getting the following message: "Run-Time Error '-2147217873 (80040e2f)': You cannot add or change a record because a related record is required in table 'Customer'." But the error is thrown (apparently) at random. Not only is there no relationship with the 'Customer' table, but...
              See more | Go to post
              Last edited by NeoPa; Jul 14 '15, 12:17 AM. Reason: {NeoPa} Original reinstated.
              • RadioWriter
                replied to Stop a form from updating a table
                in Access
                Sorry, don't know if I was unclear or if I'm just not understanding the given links... I have a form that consists of 5 dropdown menus. The top one uses an SQL query to get all of the distinct values in the manufacturer field of a table. The second gets all distinct values in the supplier field that also have the selected manufacturer. The next gets all the part numbers with those manufacturer and supplier values. There isn't any code on these...
                See more | Go to post

                  Leave a comment:

                • RadioWriter
                  started a topic Stop a form from updating a table
                  in Access

                  Stop a form from updating a table

                  Hi all- I'm currently using a form to look up records based on a few fields. Problem is, it's overwriting the first record in the table! Is there a way to avoid this, or should I write code to restore the original value every time a search occurs? (It's not every time a search occurs, but whenever the record is no longer being edited, whether in form view or when it's clicked away from in the table itself.)
                  See more | Go to post
                  • RadioWriter
                    replied to While loop hitting EOF before last record
                    in Access
                    Well, definitely faster. (Looping clocks in around 1.5 minutes to go down the list and then back up, but the above method takes only 10 seconds.)

                    Unfortunately, the return is necessary to flag all of the initial entries being checked against. Another field contains prices which need to be compared to find the current/correct one. Once they've been properly updated, the excess entries will be deleted and another method will be used...
                    See more | Go to post
                    Last edited by RadioWriter; Jun 26 '15, 08:33 PM. Reason: Further explaination-

                      Leave a comment:

                    • RadioWriter
                      replied to While loop hitting EOF before last record
                      in Access
                      Edit- Yes, this worked. Very sorry.
                      Thank you for the help!
                      See more | Go to post
                      Last edited by RadioWriter; Jun 26 '15, 06:59 PM. Reason: User Error

                        Leave a comment:

                      • RadioWriter
                        replied to Auto populating Table from Data's from other Table
                        in Access
                        How are you tracking the login/logout times? I might be able to help you figure something out, but would like to be able to test it first-
                        See more | Go to post

                          Leave a comment:

                        • RadioWriter
                          started a topic While loop hitting EOF before last record
                          in Access

                          While loop hitting EOF before last record

                          I'm working on building a database in Access 2013, and I'm coming across an error in a subroutine which checks to see if there are duplicate entries in the field PartNumbers (and marks a True/False field as true if an entry is a duplicate).

                          Code:
                          Public Sub CheckDupes()
    'Create variables; myNum and numCheck refer to the value in the 'PartNumbers' field
    'cur- first- and lastRec refer to record ID
    Dim RecSet As
                          ...
                          See more | Go to post
                          Last edited by RadioWriter; Jun 26 '15, 06:54 PM. Reason: Changes made to code per jforbes's suggestions-
                          No activity results to display
                          Show More
                          Working...