Search results

I posted this on the Reports board, but now I am thinking this is probably more of a query question. I have not developed any database yet, but I am preparing. I will have a table that contains test number, date tested, test answers and test scores for every subject. Each subject will take the...

I have not developed any database yet, but I am preparing. I will have a table that contains test number, date tested, test answers and test scores for every subject. Each subject will take the test 3 times at different times of the year. For those who do not pass test #2, a retest will be...

My user wants to be able to e-mail reports to people who request them. In the startup menu, I set it up so that users do not have access to full menus. As a result, the 'send to' option is not available to the user under the 'File' menu. Is there another way the user can send reports as needed?

I currently have a main table with all person information such as name, id number, phone number, etc. A given person belongs to one of 3 groups. I have set up tables containing relevant information that is specific to each of the 3 groups. I have set up a query that brings some information...

I created a pivot table for one of my users and now want them to be able to refresh and save the table whenever they want. The problem is that their changes don't get saved. I don't really know much about pivot tables beyond creating them and refreshing them, but I did some testing. My user...

The general problem I am having is when I calculate my percent, it displays the same percent for each row. My report is based on the following query...... Table 1 (testing information for each person) LEFT JOIN Table 2 (person information) In the query, I count the number of people that fit...

Specificallly, I want to reduce the field size for a number of fields. The values that are currently in the table will not exceed the field size I want to change it to, but I am wondering if it is possible that I will lose data if I reduce the size. I would rather not change the size if data...

My form is based on a query. The query pulls first name and last name from table 1 and the rest of the fields from table 2. The form has 3 combo boxes at the top: one for the first name, one for the last name, and one for an ID number. The bottom has text boxes with fields from table 2. When...

I have two forms that are set up as follows. The user can open the first form via the switchboard. The first form has a button which takes the user to the second form (this is the only way to get to the second form). Anyhow, the user has the ability to select a person by their ID number on...

I have a form that allows the user to either select a person in the database based on their ID number or to add a new person to the database using a combo box. When the form first opens, the form is automatically populated with values from the first record in the table. What I want is for the...

I am trying to establish a particular tab order for my form. Five of my 155 fields are missing from the tab order list. They appear in the field list, however, and when I tab through the form, the cursor indicates that they are last in the tab order list. I just can't find them!

I have the following code: Private Sub Form_Current() Dim ANS As Integer ANS = MsgBox("Click on the button to generate a monthly report of followup items to be completed", vbOKOnly) If ANS = 1 Then DoCmd.OpenReport "rptFollowups", acViewPreview, , "[IActToBeDt] = Date()" End Sub...

When a user opens up the database, I want pop-up notices to appear telling them who they need to follow-up on. For instance, there may be 10 people that need to be called or have letters sent to on a given day. I want ten messages to pop up with each person's name and what needs to be done...

Because I needed to define more than 255 fields for my form, I created 3 tables and used a query to bring them all together. This query is the source of my form, which has a tab control. When I tried to bring up the field list to design my form, it balked saying, "Too many fields defined." My...

I have two problems related to Tab Controls and Switchboards. 1) When I open up a form with tab controls from the switchboard, I am not at the top of the page (i.e., I cannot see the tabs). What can I do to see the true "top of the page" when I open up a form? 2) From the switchboard, I would...

This is probably a simple matter, but I cannot figure it out. I have a data entry form with text boxes. The validation rule option has been defined for each text box. When the user enters incorrect (i.e., invalid) data, an error message pops up that is driven by the validation rule. After...