Search results

  1. T

    importing db into another

    I want to copy my whole db file.. tables, forms, code, etc.. into another db file but when I try to import and then look at the code it gives me an error that it cant find the file. Does the VB code get imported too?
  2. T

    Update query question

    thanks for the advice.. im a little confused about how to write this left join. I want to have the code under a button and was just wondering if you could help me write it out fully as I not that familiar with this.
  3. T

    Update query question

    hrmm.. thats not a bad idea.. take the unmatched query, append a blank table with the Yes/No field set to default YES and then do an update query on the table i am using.. that may work. that may be tricky.. ideas?
  4. T

    Update query question

    Yes, I need this Yes/No field because we need to have a way to display if the student is no longer in the university
  5. T

    Update query question

    I want to run a query between two tables to see if there is a matching record or not. If there is no record, I have a Yes/No field in the table called "notInSystem" that I want to be clicked YES then. How would I go about this? ex: student table: ID NAME notInSystem 1 Tom...
  6. T

    Exporting to excel and stating path?

    I want for the user to be able to choose his or her own path for the exported table to go to instead of statically stating it in the code. I know I can have a textbox to put the path in but I want to click on a button and be able to dynamically select the path as you would for example opening a...
  7. T

    checking if record exist.. why won't this work?

    this is for adding new records. Ideally, I dont ever want the error to occur but there may be times when someone enters a duplicate ID. This just makes sense. How would I use a combo box?
  8. T

    checking if record exist.. why won't this work?

    sweet! I did a search before and found a few examples but I just didnt understand why I needed the " ' " with the string. didnt make sense but it works now. I must have had the syntax wrong before. Thanks!!!
  9. T

    checking if record exist.. why won't this work?

    text, and i tried Str(Me!StudentID) also
  10. T

    checking if record exist.. why won't this work?

    Why would the following code say data type mismatch in criteria expression? Private Sub StudentID_AfterUpdate() On Error GoTo Err_Handler If Not IsNull(DLookup("[StudentID]", "tblStudent", "[StudentID]= " & Me!StudentID)) Then MsgBox "Student Record already exists...
View older results
Back
Top Bottom