I'm working on something and I thought I would see if anyone had some suggestions. What I wanted to do was create a lable report that I could use to print out some lables. What I thought of doing was having a query that would ask for 2 sets of start and stop numbers (example 1 - 10000, and 10001 to 20000) it would then append these numbers to a table (preferably overwriting any data already in the table) then I could use a report to use these two sets of numbers, one running down the left and one set running down the right, to print out the lables. I have the concept but im not sure how to actually do this, im only new to access 2000.
Thanks for any help on how this can be accomplished.
Private Sub Detail_Retreat()
intLeftStart = intLeftStart - 1
intRightStart = intRightStart - 1
This code has one problem - if your browse report up and down in preview window labels number could go crazy.
You could resolve problem easily if you want one value for one page. You could use me.page -value to increase label number.
Great Idea, I just have one problem, when I go to next page the numbers have increased by more then one. Example the last number on the first page is 1020 and the first number on the second page will be 1022 when it should be 1021. Did you get this problem? If not could you please send me your example.
I have attached mine so you can see what i mean.
Also im not sure yet how I make the number ranges variables instead of set by VB. If its to much work don't worry about it, im sure i could figure it out eventually.