Recent content by rhay

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

Thanks Jack, It worked great! Robert

That did it, thanks DBL. Robert

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 know this is an Access forum, however, can this also be applied to an html document? I.E. hiding an empty data field? I have an ASP page that calls up records into a table but as in the report example above not all fields will have data. Anyone know of a way to hide this in HTML? Robert

How do you convert Macros to Code? 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...

Where is the setting for the query to set it to Unique values? Robert

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

Pat, Couple questions here. I don't see anything on the label where I can select Shrink and Grow, I only have that option on the data box. That being said, I can use this method, but where there are several fields that are hidden there is a gap between the field before and after. Is there a...

Yes, it does work to some extent, however if the number of passengers is 151 or higher with that formula it will give you 3 trucks..when only 2 are needed. Robert

I started out with exactly that, however as I said in my initial post, the formula does not take into account the portions of 100. Using that formula, if I have 130 passengers it only calculates for 1 truck when I actually need 2. Robert