Search results for query: *

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...

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

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.

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...

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...

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?

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...

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

mpastore- Thanks for the help It worked great!!!!

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

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

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

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...

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...

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

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...

I am now getting a could not delete from specified tables pop up. Comes after my confirmation pop up.

WildHare Thanks for the help! However, when i click on the delete button nothing happens. it goes through the prcocess and displays my pop up msg but the record is not actually deleted from the table. The following is the del qruery sql code: DELETE tbl_Cadet.SSN, tbl_Cadet.*, tbl_ROTC.*...

How do I delete a record using a combo box with multiple columns i.e. Last Name, First Name. I can get the delete query to work when there is just one column ie Social Security number. Thanks, SignalLT03

thanks mas5. I'll try it out