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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by signallt03

  1. signallt03

    Item tracking

    I am trying to create a report that list all items someone is signed for. I have a table that has general item description. a table with sn and who has them. a table for quantity if there is no sn. and a table for personal info. how do i get the report to generate so that it lists the sn if...
  2. signallt03

    multiple serial numbers on one line

    scriverb thanks for your help. the database is working great thanks again signallt03
  3. signallt03

    multiple serial numbers on one line

    the problem is the Army has a specific form that should be used for this. It has to look a certain way in order for it to be okay to use. I can email a copy of the database if you would like so you can see what I am looking for.
  4. signallt03

    multiple serial numbers on one line

    i got it to put the serial numbers in one box. I used CosmoKramer's post. Scriverb's kept saying "wrong number of arguments used with function in query expression 'SerialString()" The problem i have now it if i have too many serial numbers they do not all show up. If i change cangrow to yes...
  5. signallt03

    multiple serial numbers on one line

    Printing onto multiple lines is a big possibility since some products could have as many as 15 serial numbers. The reason I want them to display horrizontally is because they have to fit into a specific format. I had to create an army form in access so that it would fulfill the army...
  6. signallt03

    multiple serial numbers on one line

    I am trying to great a form that will print product names on one line then print all of the serial numbers for that product on the same line. then go to the next line and start with the next product. Any ideas?
  7. signallt03

    jet database engine error

    I have a form with several subform inside of a tab control. When i go to enter info in to the main form ie ssn, name, dob i get a error "The Microsoft Jet Database engine could not find a record in the table "tbl_Cadet" with key matching fields "SSN". If someone could...
  8. signallt03

    form with subforms in tabs

    trendsetter- I tried messing around with the code from above but having a hard time trying to figure out where to place it. ie. on form change or what? thanks signallt03
  9. signallt03

    Report based on date

    mpastore- Thanks for the help It worked great!!!!
  10. signallt03

    Report based on date

    yes, but what if one person failed to take it on the last date. How would i show there last completed test.
  11. signallt03

    form with subforms in tabs

    I tried inserting the code in various places and could not get it to work. i.e. subform1 exit. tab2 click. I still get the same errors database is at www.angelfire.com/mi4/moarmy/ROTC.zip
  12. signallt03

    Report based on date

    I have a table that saves test scores based on SSN and Date. I want to generate a report that gives the last test score for each person
  13. signallt03

    form with subforms in tabs

    I have a main form (frm_Cadet) on it there is a tab control with six different tabs. The first tab has a subform (frm_CDTInfo) it contains general information about each cadet ie. Name, SSN, Date of Birth. The other tabs contain subforms linked to the first one, via SSN, with info about...
  14. signallt03

    tab control with subforms

    jdttek- Yes, when i close the form and then open it again it lets me continue and edit the other forms. Not when i click on the save button though. I tried messing around with the requery thing today but couldn't get it to work. Any help you can give me on this I would appreciate. Also, the...
  15. signallt03

    tab control with subforms

    Parent/Child fields are both set to SSN as for opening a new record no but when the tb control changes i have it saving. you can take a look at the db www.angelfire.com/mi4/moarmy/ROTC.zip PRO PATRIA VIGILANS
See more

Part and Inventory Search

Back
Top