Recent content by Romulus

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!