Search results

Thank You, Thank You. You saved my life with the BOOKMARK app. I was up most of the night troubleshooting the code only to finally find that I had a fat-finger hiccup in your answer causing the errors. Once I moved the tempvar to a txt file it worked.

tried it as you wrote and also replaced the tempvar with a txtField and still couldn't get it to work, but thanks a lot for the effort. Still have to get this done by Monday.

Bookmark looks as my best chance. how do I code this line: lngBookmark = Me.[TempVars]![VolID]

btw, the value I am trying to use as the lookup key, VolID is a tempvar

I am trying this DoCmd.GoToRecord "Volunteer_ID" = Me.volid volid is a number that I need the table to go to

is there some way I can send you what I have, posting it has too much in it

I get the error message " The expression you entered refers to an object that is closed or doesn't exist"

thanks again. I did look up your page and I have tried them with no luck yet.

I need to do the lookup "on Load" of the form.

I am desperate at this point, I have looked everywhere and I know it is something simple but I need help. I am a novice at access and am trying this because no one else will. I am in a form that uses a table and I need to look up a record that matches a particular field. The table is...

plog thanks for the suggestion, but I just cant get it to work, the table is "tblPositions", the field I need to count by a group is "Qty" and the result field I would like is "signedUp". Can you make a suggestion? I have read your recommendations but still confused.

I would appreciate any specific recommendations for making this work.

I appreciate the comment about its poor form but I am a beginner and inherited this mainly because I knew how to spell the word volunteer. :-)

Thank you for your observations. The school course catalog is a very good analogy, however, most of the Classes listed in the POSITION table have unique starting dates times and only for specific duration. For this reason, the shift start and end times have to be a part of each position in the...

Attached is a sample of the data base I need help with. I need a way to show how USERS can sign up for a VOLUNTEER POSITION in the VOLUNTEER POSITIONS table and increment and save the count each time someone joins that ASSIGNMENT.

I understand. an assignment is assigning a person to a position. Is there some way I can send you the tables or the entire data base. I am getting desperate due to a deadline looming for a working application.

Thank you. Wasn't even sure anyone would reply. I have 3 tables: Volunteers Roster Available Positions Position/Volunteer Assignments I need to be able to assign a volunteer to an assignment, see how many have already signed up for each position and keep a tally of each position. Hope that...

Greetings, I am fairly new to Access and have enjoyed some success developing very simple forms and queries for my volunteer group. But now they have asked me to get a little more sophisticated with the data and I will agree I am over my head and need some assistance. Help with incrementing a...