Recent content by swilliams2785

I wanted to add a button with an event procedure to an existing form that would skip to the next record unless the end of the file was encountered in which case it would jump to the first record. I envision the code would look something like this: If (test for end of file) = False Then...

Thanks for the suggestion, I'll look into it when I have time. I was able to write code that solved my original problem.

Attached is a sample database with demographic and grade tables as well as a form for managing the contents of the demographic table. I have the relationships set up and the delete function works as expected, however, when I add a new student I need tblMarksEntry1 to contain 4 new records with...

I have a table with student’s demographic information. I have another table with student’s grades. The two tables share the student’s ID Number field. The grade table has four records for each student, one for each grade period. In the application I will need to add and delete students and...

I am pleased to report successful resolutions to all issues encountered to date. Your help was the key and is greatly appreciated. Thank you.

Thanks for the suggestion, I'll give it a try. I think this may help me solve another problem I am having trying to load a function into the Control Source property of a text box on my report. I get an error message saying that you can not load the Control Source property during a print...

The array worked great until I changed the detail section's visible property to No. After that no values were displayed. I just checked the file you sent me and it does the same thing.

Success. I had to fugure out how to use multiple criteria (the link you suggested really helped) and discovered that both fields referenced in the criteria had to be present in the footer where the DLookUp function was being used. Thanks again, hopefully for the last time. I guess I must...

An additional problem has surfaced with my report. Although the fix suggested solved the original problem, in my application I need to have the detail and GP footer invisible. Is there a way to make this work with these conditions in place? See attached file.

The DLookup function didn't work with repeating sets of records but the array will do the job. This is my first foray into VAB within reports. I'm sure I'll use this technique many times in the future. Thank you.

I’m trying to capture values of repeating numeric and text fields in the report detail and display them in a footer. The attached database is a better explanation of what I’m trying to do.

This seems to work. I can't figure out why but I'm not going to lose any more sleep over it. Thank you for the solution and the link.

This is strange! Out of frustration I saved the database, created in Access 2007, in Access 2002 format and put it into a laptop I have running the 2002 version. The problem disappears and data displays as expected. The latest twist . . . . I put the database on yet another laptop running 2007...

It happens to me after I save the database then close and reopen Access. The attached .jpg is what I see.

vbaInet, Yes, this is what I'm looking for and I can tweak my layout and get it but once the database is saved then reopened the #ERROR? appears. Right now the table is what I'm using. It is original data pulled from a spreadsheet that will be supplied to me. I was testing layout options...