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

Thanks Rakier! I'll give it a try.

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

Hi Jennifer, Maybe you can set the default value of each box to their respective PLU numbers, if the field is numeric.

Jennifer, It takes me to this part of the code: Me.RecordsetClone.FindFirst "[ID] = " & Me![Combo205] I didn't step through the code because honestly I can't remember how to do that. I learned it in class a long while ago. I'll have to rummage through my books at home to find out. I created...

Simply setting 'limit to list' to yes worked. Thanks Jennifer. I guess I should look at all of my properties more carefully. There is one more thing that I can't resolve. I have some VB code written for an "After Update" event for that combo box. I did a little testing. I typed in an...

I ran into a problem with that. I sorted the list by last name, but if the data entry person only knows the person number (for confidentiality purposes) and tries to type in a person number (for more efficient data entry) that doesn't exist, Access does not give any warning messages. Instead...

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 went to the form properties and the pop-up option was already set to "no". I am still stuck.

This was just what I needed. Thanks!

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 know. It's not pretty. I did find a solution. I just deleted the missing fields and recreated the text boxes on the form. Once I did that, they appeared in the Tab order list so actually it doesn't have a limit of 150.

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!

Ian, Thanks for the suggestions. I tried adding Date() to the query again as you suggested and it worked this time. I think the problem was that I used the criteria for the form and not the report - my mistake. I left my code below the same except I changed Integer to Byte as recommended...