Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. NOVAmichelle

    Form opens blank when no record

    ...enter the number and click ok it opens the Master form to that record and all corresponding data. The thing is this. Sometimes user error occurs *imagine that* and a user enters an invalid customer number. The form opens anyway, but all fields are blank. Isn't there a way that I can have a...
  2. NOVAmichelle

    Auto ID throwing me off

    Thanks! Have a great weekend!
  3. NOVAmichelle

    Auto ID throwing me off

    One of my teammates has a master form. On this form there is master data etc in the header, including an autonumber field. In the details section she has 5 tabs with various subforms on each. On one tab, for example, if you check a yes/no box, a subform will pop up so that information...
  4. NOVAmichelle

    Multiple Choice in a listbox..

    Is it possible, or what would be the best way, to have an option box with say, 12 choices, and the user can choose as many as they want? Not just one. Also, can I query off something like this?
  5. NOVAmichelle

    Exporting Report to Excel

    I have a report and when I export to Excel, some of the headings of the columns say "Text43" for example, instead of the names of the fields. I have checked in the properties and all have "Captions" which correctly identify the field. Is there something i'm missing?
  6. NOVAmichelle

    What is Nz?

    I know that sounds silly, but what does it stand for?
  7. NOVAmichelle

    # Name

    =[SumOf01/05 LPcom]/[SumOf01/05 Total]
  8. NOVAmichelle

    # Name

    thank you. do you have an example?????
  9. NOVAmichelle

    # Name

    I have a form which has 4 fields across... Column A has a number in it Column B has a number in it Column C has the Total of A & B Column D represents the percentage of the Total/Column A Problem is that when there's no value, meaning no total, then i get #Name in the percentage. How can I...
  10. NOVAmichelle

    Only 1 instance in a field

    okay, the transaction # is the primary so... Trans #1 can have 01, 02 or 03 in any combination. It will not be null. I want to know which transaction #'s have only ONE instance of 01, 02 or 03. Hope this helps. It's Friday, I'm slammed and working on three different databases this...
  11. NOVAmichelle

    Only 1 instance in a field

    I have a query that i need to group by transaction #, and then I have another field which identifies a code for the type of transaction. example: field 1 = Transaction # and field 2 = transaction type which can be either 01, 02 or 03. So, i want to group by trans # and ONLY see those instances...
  12. NOVAmichelle

    Open Form IN FRONT of Current Form?

    I'm advanced enough to not have to ask this but for some reason i am stuck! On my switchboard is a control to open a master form. When a user clicks on this they are prompted to enter the customer # and the master form opens to that record. PERFECT. Only problem, my it opens behind my...
  13. NOVAmichelle

    Combo Box or List Box?

    ok, so if I do that in the list box, how do i get my selections to copy into a memo field on the same form?
  14. NOVAmichelle

    Combo Box or List Box?

    I have a communication form which is being used for customer distribution of various messages etc. There is an auto date field, a field for any comments, and then I have a memo field where my admin manually types which customers are going to receive this broadcast. IS THERE A WAY to have a...
  15. NOVAmichelle

    Trying to put a calculated field on a form

    I have a master form that has totals by month for various things. I want to create an unbound field on this form which will total some of the fields. Please help. Also, I just realized that my fields are text. Should I change them to number fields?
  16. NOVAmichelle

    Query not picking up leading zeros

    I'm running a query but it's not picking up records where the number begins with zero's Any ideas?
  17. NOVAmichelle

    Invalid Argument

    I am trying to run a simple query of two rather large linked tables and when I run the query I get an invalid argument. I thought about importing the tables into a blank database and running them that way as opposed to being linked and got an "Invalid Argument" while trying to import. HELP~!!!!!!
  18. NOVAmichelle

    Too Many Fields Defined???

    I'm trying to open one of my customer forms and I get the message "Too Many Fields Defined". HELP. Do I have too many on the form or too many in the table????
  19. NOVAmichelle

    Requery in Code

    how do i type that in the code? it doesn't seem to like me.refresh or docmd.me.refresh
  20. NOVAmichelle

    Requery in Code

    I have a control button that will run a query behind the scenes when a user clicks on it. What I would also like to happen is for the main form to refresh this data as well. Any idea what code to use???

Part and Inventory Search

Back
Top