Recent content by JRickman

Thank you for your response. I seem to be still having trouble, however. I agree with your view that redundancy of data is not necessary. What I really want to see is the following. Here's the table: ID AutoNumber StaffID...

In a form, I have a combo box for staff ID which displays staff ID, staff first name, and staff last name, and fills in the last name and first name text boxes as well as the staff ID box based on the selection. I have the following code to do this: Private Sub cboStaffID_Change()...

Thank you much. I've narrowed the size of the table as you suggested and, voila, that gives me a lot more flexibility when doing queries and reports.

We have a Guardian table which contains the following fields: Guardian_Record_ID StudentID G1_Name G1_Relation G1_Phone1 G1_Phone2 G1_Email G2_Name G2_Relationship G2_Phone1 G2_Phone2 G2_Email G3_Name G3_Relationship G3_Phone1 G3_Phone2 G3_Email...

Can you display a month calendar in a query for the user to choose 'from' and 'to' dates? How would I go about doing this? Thanks, Jim

Thank you for your response. Next question: how do I save the database to a more recent version of Access? When doing a "Save Database As" of the database, the only option presented in "Save as type" is "Microsoft Access Database". Thanks, Jim

I have a more basic question regarding the attachment data type. I'm using Access 2010 and would like to use this data type. However, I do not see "attachment" in the drop-down list when choosing which data type to use. Anyone have an idea why this is happening? Any help would be appreciated as...

I'm getting "undefined function 'Date' in expression" when executing an update query. The expression in the query is simply Date() Perhaps this is the result of a less than complete install of Access 2010 -- I'm not sure as didn't install Access on the computer I'm using. What could be...

I've created a number of modules. I wish to see a list of all of them for possible editing or just to review them. How do I get that list and pull them up for viewing? Any help would be greatly appreciated. Thanks, Jim

I answered my own question. In the Report, right-click on the field, click on 'Total', and choose which operation you want to use. Very simple. In Layout view, you can adjust the width of the column if the resulting number is too large for the column width.

I have no problems getting the Sum of a column of numbers in a Query. However, when I create a Report based on that Query, the Totals record at the bottom of the query does not appear in the Report. Is there a way to get that totals record at the bottom of the Query into the Report? Many thanks, Jim

How does one get the Totals at the bottom of the query (Sum, Average, Count, etc.) directly into the Report? I know I could export the query into Excel, import the Excel spreadsheet into a Table, and create a Report from the Table, but that seems a very round-about way of doing things. Any help...

How does one get the Totals (Sum, Average, Count, etc.) at the bottom of the query into the Report based on that query? Thanks, Jim

Hmmm, I've read that there's a maximum of 255 columns in a query. However, I can't seem to get beyond 16 columns... When I press Tab to go to the next column, it returns me to the 1st column of my query. Except for the first 5 columns, the columns are calls to modules -- which are used to count...

Yep, that's what I did... I changed the name and it runs like a charm. Thank you for all your help. Jim