Search results

  1. C

    Runtime error 3011 with import

    Hello all, I have a database with a piece of code that worked up to today. My database connects to sql server. I use cross over queries to run the queries and the queries make temp tables. In the vb code I added one additional query between 2 other queries. then the import stopped working and...
  2. C

    using search function and orderby

    Okay, I am building a database form that uses a sub form. I got the search function to work great, had to copy some code to do so, but now I would like to have the results sorted on a different field. the Search function uses employee id, then I am trying to add me.orderby to the code to sort...
  3. C

    VBA code to copy record and then delete it

    I have a form with a sub form. when a record is choosen in a combo box the sub form is filled out with a record. what I am trying to do is have a button that will copy that record to a history table then delete it off the the main table. I cheeted by using the wizard to get the code to...
  4. C

    combo box within subform

    I have two combo boxes in a subform that use lookup queries. I can get the combo boxes to work correctly out of sub form in a regular form but can not get the combo boxes to work in the sub form. I have narrowed the issue to the logic in the queries in the secondary and tertiary combo box...
  5. C

    Columnwidth vba code

    Hi i have a trigger on a form which once something is choosen goes to a look up table and should auto populate from that table. Since that table has multiple columns I am trying to get the code to choose from the second column. My code doesn't work. help. Private Sub Forum_AfterUpdate() If...
  6. C

    Form button to open another database vb

    I would like to build code to open another database I don't want to use a hyperlink because I need to have options when the button is clicked. The vba code is driving me nuts.
  7. C

    Using Case statements

    hi, I need help making a case statement. I have a form with 9 check boxes. The intent is you are able to choose 1 through eight choices. if you do the 9th check box deactivates. If you unchoose all of them then the 9th box becomes active. If you only choose the 9th box the first 8 becomes...
  8. C

    Auto Send report in body of email via Access 2003

    Hello, I have a very simple report that I need to have in the body of an email. I have a form with a button that should activate outlook, add the simple report to the body of the email and send. The TO: field will be blank due to a distro list. The subject field should also have a standard...
Top Bottom