Search results

  1. D

    Export to Excel and Import to Access

    I'm trying to export a query to excel and I'm using the OutputTo macro. I can't choose which version of excel to output to and it's getting stuck in an old version. This older version won't import into Access. Is there a patch for this? Has anyone else seen this problem? Fixed it? Does...
  2. D

    Help!!! Using AfterUpdate Event

    I need to update two combo boxes by selecting something in another combo box. I know how to use afterupdate to do this for one combo box to another, but i can't get it for two! Here's the way I do it already for the combo box I have the info in: Me.combo2=Me.combo1.column(1) do i just need to...
  3. D

    Not in the list SQL

    I want to create a SQL for when something is not in the list in the combo box I created. When you are trying to type something in the combo box I want it to realize that it's not on the list and a msgbox should tell you to double click on the field. Then I want a separate form (Target Species...
  4. D

    Subforms with lists and combo boxes?

    i'm trying to figure out a way to use a combo box in the list formated subform. I want you to be able to start typing the name and for it to pop up for you automatically. I also want a combo box for another property within the subform. I would like to still use the list format instead of the...
  5. D

    Storing combo box data to tables

    i'm having a problem storing the data from my combo box onto the appropriate table. which property is this on the list of properties for the combo box? right now it is storing the autonumber(ID#) instead of the name associate with the number. does this have to do with the row source? i need to...
  6. D

    automatic updates in a combo box

    I have 2 combo boxes - one called QUADNAME and one called QUADCODE. Each one of them is a combo box with the quadname and the quadcode. The QUADNAME box has the quadname first and then the QUADCODE. The QUADCODE box has the code and then the name. I want to be able to scroll through the...
Top Bottom