User Profile
Collapse
-
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) -
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
-
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.Leave a comment:
-
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.Last edited by NeoPa; Jul 14 '15, 12:18 AM.Leave a comment:
-
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.Leave a comment:
-
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... -
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...Leave a comment:
-
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.) -
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...Leave a comment:
-
Edit- Yes, this worked. Very sorry.
Thank you for the help!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-Leave a comment:
-
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
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
Leave a comment: