Search results

  1. B

    Sever backend Connection

    Sorry, back end is Access.
  2. B

    Sever backend Connection

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

    Sever backend Connection

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

    Improving code to check that certain controls on a form have values

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

    Property Sheet looks different

    A few minutes after posting, my database crashed. When I opened it again everything was back to normal. Go figure.
  6. B

    Property Sheet looks different

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

    Insert multiple records into child table using VBA

    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 =...
  8. B

    Insert multiple records into child table using VBA

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

    Insert multiple records into child table using VBA

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

    Insert multiple records into child table using VBA

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

    Insert multiple records into child table using VBA

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

    Move field on tabbed form

    You could put the field on both pages and then control which one is visible programatically (me!Field.Visibe = True/False)
  13. B

    Insert multiple records into child table using VBA

    I don't know if it will be useful or not, but I thought I would include a stripped down version of the database I'm working on. Thanks again folks!
  14. B

    Insert multiple records into child table using VBA

    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 " & _...
  15. B

    Insert multiple records into child table using VBA

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

    Insert multiple records into child table using VBA

    oooh, I like the sound of that. I'll play with that idea. Thank you for the suggestion!
  17. B

    Insert multiple records into child table using VBA

    Ok, I think I can do that. I'm a little unsure how to handle the setting of the foreign key though. Do you know how I could set the Foreign Key field value on the child table to the primary key value of the parent table? Keeping in mind that I only want to add revision history notes for...
  18. B

    Insert multiple records into child table using VBA

    Yeah, I was wondering if the problem might be the query itself. Since I'm creating a new record in the child table, would I need to Change this to an INSERT INTO query?
  19. B

    Insert multiple records into child table using VBA

    I have a parent table (tblLabels) and a child table (tblRevision) where the revision history for the parent table is kept. The parent table is populated via an excel import and may have several records imported at once. Instead of having the user manually enter a new record note in the child...
  20. B

    Using a query as a record set to check if a path exists

    I have a module that I am using to verify that file paths in my table point to valid jpg files. The table has grown quite a bit since I first created the module and it has gotten to the point where it's taking too long for the module to execute. I'm in the process of trying to change the...
Top Bottom