Hi Minty,
Thanks for the response. I think pretty much all of that might have gone over my head.
So I looked up ODBC it looks like that is something I access from control panel -> administrative tools?
I looked up SYSWOW64 as well but I'm not sure how I check on it.
Are these things...
I had a split database that I wanted to do some structural work on so I made a copy for testing and converted the tables to local tables (Right click -> convert to local table) to help me keep from breaking anything too permanently. The changes ended up taking longer then I expected them to and...
I have a bit of code that uses controls on a form to batch add records to the tables. Before the code executes, it needs to do a check to make sure that all of the needed data has been supplied. I've set something up that works, but I wonder if there might be a more preferable way to do it or if...
I was working in my database going back and forth between form view and design view to test the row source in a listbox when the property sheet changed on me. The text in the right column is all bold and there is no longer any border around the values. It appears to have affected the property...
Got it! :D
This is what I did:
Private Sub Command11_Click()
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim rs2 As DAO.Recordset
Dim ctl As Control
Dim VarItem As Variant
Dim lngNewID As Long
Set db =...
I think I found a way to import the records using rs.AddNew But db.Recordset("Select @@ IDENTITY")(0) is returning random columns from my listbox instead of the most recently created primary key in tblLabels. If I can store the primary key of the record I just created as a variable then I could...
Hi TJPoorMan,
So I have a linked excel spreadsheet in my database which contains the records to be imported into the parent table plus records that are not ready to be imported. I have a form that uses the spreadsheet as a datasource and displays them in a listbox. I want the user to be able...
Thanks vbaInet,
Correct :)
I thought that was what I did with the query in my last post. Perhaps I'm confused on what an append query is. Is that any different between an Append and INSERT INTO query?
When I create an append query in access and then view the SQL code it gives me...
I had another thought on how I might go about this by calling a stored INSERT INTO procedure from vba that already had all of the parameters spelled out. This is how i've written the query:
INSERT INTO tblRevisions ( LabelID, RevDate, RevisedBy, RevAuthorizedBy, RevDesc )
SELECT...
Thanks for both of your responses.... I'm hoping I'm not too far in over my head.
When I run:
Private Sub Command8_Click()
Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("SELECT Count(*)" & _
"FROM tblRevisions " & _...
Hi Isskint,
I've been playing with this Dcount thing you suggested, but I'm having troubles fleshing it out. Could you help me out with the syntax? I've tried a number of combinations but i keep getting an error message 424 (Object Required) when i run the code.
Dim rs As...