Search results

I have a VB program that access' a Access DB. I have one form set up where the user selects which fields he wants the data from to be placed on the data report. 2 questions: 1) Do I need to design the report layout, or does VB automatically place the controls on the form? Currently I only...

Ok, I apologize for all the questions tonight but I am running into things I can't find an answer on through web searches etc. I have a db with 2 tables and 2 forms. 1 table has personal info of my soldiers. 1 table has info on each crew. ( A crew is 4 soldiers). Here is what I need to do...

One more question please. I have several different page tabs on my form, how when I am tabbing through and get to the last field on a tab page I can get it to tab to the next data field in the next tab page instead of going to the next record. Thanks again, Robert

Is there a way in the Form Caption when open it will display the name ( a field in the form)of the current record being viewed? Thanks, Robert

I want to be able to archive my records for later retrieval. How can I through VB, copy the contents of a record from a form to another table within the same database? I plan on placing the code for this within the same module that deletes the record. So that when the person selects to delete...

I have a combobox that is filled from a table field. There could possibly be several records associated with this field. I want the user to be able to select one of the items in the drop down box then generate a report showing only the records related to that particular field. However, I also...

I'm interested in making a multiple choice question answer program. Basicaly what I am looking for is I will have a pool of questions by subject and a pool of answers by subject. When a question is asked it will display the correct answer and 3 other randomly wrong answers. The user then makes...

I asked this before but wasn't able to get it working, here is what I need to do: I have a field called "passengers" based upon the number in this field, I need it to calculate the number of trucks I need. For every 100 passengers and any portion of 100 I need 2 trucks. For example if I have...

I know how to email an entire report based on my records, but how do I email just one report? Robert

I've got another question for you all: How do I open a form based upon the record selected? I have a combo box that is linked to a list of records, depending on the record, it uses a unique form. How do I open a record in it's specific form? Thanks, Robert

I have a field on my form that displays a calculation based upon the amount in another field. IE: [Forms]![Wheels Up]![Passengers]/100+1 What this does is set the value for another field based upon the number inputed into the passengers field. However what is happenning is if the passengers...

Here is my situation..I need to create a report based off of 1 table..but some records don't have data in some fields and some do. I need this report to omit the fields for each record where there is no data in the field. Example: I have 2 records..each has the field name of "mission" , 1...