Recent content by Data Slave

  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

    Help with subforms and subreports

    the subform should have a field in the table that is an integer to link it to the main form's primary key. you can do this when you create the subform. the easiest way to create subforms is from the wizard. about the reports. you can choose fields from any table to put in the report. define the...
  4. 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...
  5. 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...
  6. 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...
  7. D

    COMBO BOXES

    tracey75 i figured it out! are you using the combo box wizard? if not, it's easier to use than trying to do everything yourself. if you don't have the wizard you should try installing the advanced wizards from your office 97/95 cd onto your pc. anyway, travis was right. if you go through the...
  8. D

    automatic updates in a combo box

    I can't figure this out. I have even changed the QUADCODE combo box to a text box to try to resolve the problem. It seems like it shouldn't be that hard to do. Am I missing something? I tried to create queries and relationships and I can't seem to get it to work. Does anyone know how to do this...
  9. 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