Search results for query: *

I have a table with different types of equipment with fields such as asset tag, category, model, location, issued to and date. I have a seperate table for the categories. I am looking for the best way to create a report on the specific categories. I have 14 caterories and I want to generate a...

I am using a subform in datasheet view. I want to choose by year or quarter. I would have two tests per quarter for a total of 8 tests. They would be grouped by the person's ssn but displaying first and last name of about 75 people. and then view and edit in datasheet view. Playing around and...

I have a form with a combo box to choose employees. about 30 and growing. The problem is the customer would like to choose several employees to be associated with the record. The combo box only lets me choose one. Do I create 10 combo boxes of the name query or have the combo box and a button so...

I have a form whose source is a table. I also have several more text boxes on the form whose source is another table. I would like to add information from this form as a new record to these two forms.

I was given this sql code to add to a form so that the text and combo boxes would be inserted into the tables. but I do not even no where to begin or if the code is any good. Dim strNewRecord As String Dim strSQL As String Dim rst As Recordset Dim dbs As Database Set dbs = CurrentDb...

I am trying to use one form to update 3 tables. I have a form with 3 text fields and 3 combo boxes (the combo boxes are based on lookup queries). 1. is a text box that's uderlying source needs to be a field from another table (how is this done?) control source? 2. source is table which form...

I think I am going to need more detail. I created 3 new seperate queries. So a total of 3 combo boxes based on 3 queries with just the data needed to populate the combo box. I then create a blank form and create the combo boxes with the wizard to lookup the data but I cannot find OnUpdate. and I...

I would like to create 3 related combo boxes. For instance I have a person, tag #, and serial # from a query of 2 tables. If I choose the person in the combo box the other combo boxes would change to the person's unique tag # and unique serial #. Conversely if I choose the unique tag # it...

Good advice LittleSmudge and GingerR. I tried it and it worked. I wouln't use the group footer visable or not visable, just go with the report footer having the sum.

I have a form that has a combo box that looks up data in a query with an autonumber. I would like to search and find a single record and be able to print the complete record. example, I type 14 in the combo box, it shows the person's name that autonumber corresponds to. I want that record...

I am trying to create an Access 2000 database that prints addresses to a Pitney-Bowes w700 address printer. The customer will use 4 different envelope sizes and no labels, just a direct print to the envelope. I believe I either want to create the addresses in the label wizard or design view of a...

bump

I want to send a Access 97 report by e-mail from the user form using a command button or combo box with a send button? or by other means. I am trying to send two different reports to two different e-mail addresses. any suggestions or advice? Thanks