Search results

burrcm, thanks again for your help. But I found a much easier a easier way. I ended up using 3 unbound text boxes (1 for starting year, 1 for starting sequence number and the third automatically counts starting at 1) I then used a update query that is activated by the "print" event. The...

burrcm. thank you for your reply. Since the user wants to be able to specify the starting number for for each group of membership cards your method won't work in this case.

I am trying to create Membership cards. Each membership card has a unique consecutive number (the starting number iis determined by the user entering it in a unbound text box). What then needs to be done is to update the members information in the table with this now assigned membership number...

Can a UPDATE query run from a report? I have tried to update the table by using a unbound text box by placing the update query in the Control Source. That doesn't work. I then tried to use a bound text box and placed the update query in the Control Source of that text box. That does not work...

burrcm, thank you for your reply. I am confused as to how the numbers will automatically increment. The report currently is based on the table. I want to set the starting value for the numbers by using a unbound text box so that it "pops-up" a form to enter the starting value. Can you please...

What I need are membership cards with sequential numbers (with the starting number entered by the user). Each number is assigned to a member and needs to be saved in a table. To accomplish this I created a table and my own custom label that corresponds to the size of my membership card. I did...