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

  • 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:


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

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

    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

  • 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:


  • 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:


  • 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

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