Recent content by AKATemp

  1. A

    Import from Excel into Access table changes number format

    Hello all, I tried searching and am unable to find a solution to this annoying little problem I have an excel table called Parameter with a column called "Test" -- The column contains integer numbers only. So all the numbers in the column are like 5,10,15,20 etc I have an access macro...
  2. A

    Combine 3 Forms into 1 Tabbed Form

    Hi vbaInet, What do you mean by the same record source? The same tables? Yes, some of them do. Attached is a pic of the database and the forms. The forms build query from the tables listed on the left. Regards,
  3. A

    Combine 3 Forms into 1 Tabbed Form

    Hi vbaInet, Sorry, I did not post any code. There is a ton of code behind the three forms. But the basic gist is that each form has combo-boxes, list boxes and using IsNull condition statement, I dynamically make a query from tables that are also in the database and create a new table to...
  4. A

    Combine 3 Forms into 1 Tabbed Form

    Hello all, I will try to give a little background. I made a form for our office to search data through our MS Access database. It was a big hit, and people started using it. Then came another request to make a new form - to search through another few tables. This was a big hit too. The same...
  5. A

    If no selection made show all values including Null

    Hi plog, Thank you for replying. Let me see if I understand you correctly. I thought hard and looked at how MS Access creates queries and I realized something that you have reconfirmed -- If that value is null, you don't need criteria for it so it should be omitted. So now, I will be...
  6. A

    If no selection made show all values including Null

    Hello all, I tried searching and I can't seem to find the solution to this relatively simple problem. I know the mistake I am making, but I do not know how to solve it. I have a Form with multiple comboboxes and listboxes whose selections are assembled into a query. The combo-box selection...
  7. A

    Numeric comparison and Null values

    Hi JHB, Unfortunately that did not work. It gave me an error saying that the expression is too complicated to evaluate. How would the criteria look under column A? (>[Forms]![MainForm]![Criteria]) Or Is Null
  8. A

    Numeric comparison and Null values

    All, I tried searching the forums for something similar and unfortunately, haven't been able to find the help I need. If someone can point me in the right direction, I'd appreciate it. I have a form with a textbox, where one inputs a number and then I run a query with the form criteria. The...
  9. A

    VBA-Query Loop - Unable to convert to Form reference

    THIS HELPED! Thanks!
  10. A

    VBA-Query Loop - Unable to convert to Form reference

    Hi CJ, Thanks for the prompt reply. I appreciate it. With regards to table design- Yes, the column names are named after animals. Once the animals are in column, I can put a 'weight' limitation for the animals and get a list of all the zoos with the following animals within a weight...
  11. A

    VBA-Query Loop - Unable to convert to Form reference

    All, I've tried searching through the site and now, I am unable to find an answer to this question. If someone could point me to the right direction- I'd appreciate it. Background: I have a form with 10 combo-boxes. Once user selects a value in CB1- CB2 becomes visible and active. I am trying...
Back
Top Bottom