Start Report Numbering at 4

  • Thread starter Thread starter fhwa
  • Start date Start date
F

fhwa

Here's my dilemma, I'm trying to create a report with a subreport in
the query. And what I need it to do is instead of starting an item
numbering at 1 when the source =1, I need it to start numbering at 4.
I'm getting quite frustrated and am very new to VBA code and whatnot.
All the other cells except for total come off a query, but the
numbering is automatic with the report. I appreciate all and any
help!

My report looks like this:

1 Description Price Quantity Total
2 Description Price Quanitty Total
3 Description Price Quanitty Total
4 Description Price Quanitty Total

I need it to look:

4 Description Price Quanitty Total
5 Description Price Quanitty Total
6 Description Price Quanitty Total
7 Description Price Quanitty Total
 
What is the ControlSource for the control that displays the line numbers?
 
What is the ControlSource for the control that displays the line numbers?










--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200706/1- Hide quoted text -

- Show quoted text -
Click to expand...

Currently the numbers come from a textbox with a controlsource =1.
I've tried to change it to =4 but then the numbers start at 4 and
increase by 4 (ie 4, 8, 12) This should be something extremely easy
however it is throwing me in loops. Thanks
 
Make your current TextBox invisible and create a new TextBox with the
ControlSource = Me.1stTextBox + 4. No running sum on this one. There are
several ways to solve this problem. Post back if you need further assistance,

What is the ControlSource for the control that displays the line numbers?
Click to expand...
[quoted text clipped - 27 lines]
- Show quoted text -
Click to expand...

Currently the numbers come from a textbox with a controlsource =1.
I've tried to change it to =4 but then the numbers start at 4 and
increase by 4 (ie 4, 8, 12) This should be something extremely easy
however it is throwing me in loops. Thanks
Click to expand...
 
Make your current TextBox invisible and create a new TextBox with the
ControlSource = Me.1stTextBox + 4. No running sum on this one. There are
several ways to solve this problem. Post back if you need further assistance,
[quoted text clipped - 27 lines]
- Show quoted text -
Click to expand...
Click to expand...
Currently the numbers come from a textbox with a controlsource =1.
I've tried to change it to =4 but then the numbers start at 4 and
increase by 4 (ie 4, 8, 12) This should be something extremely easy
however it is throwing me in loops. Thanks
Click to expand...

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200706/1
Click to expand...

ok using that controlsource =Me.1stTextBox + 4... I'm supposing
1stTextBox will equal Text16 because thats the name of the current
number box. however when I use that it asks me for a parameter for
Me?? I've never used Me before how do I get rid of the parameter part?
 
OK, just set the ControlSource to =Text16 + 4 and see what happens.
Make your current TextBox invisible and create a new TextBox with the
ControlSource = Me.1stTextBox + 4. No running sum on this one. There are
Click to expand...
[quoted text clipped - 18 lines]
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200706/1
Click to expand...

ok using that controlsource =Me.1stTextBox + 4... I'm supposing
1stTextBox will equal Text16 because thats the name of the current
number box. however when I use that it asks me for a parameter for
Me?? I've never used Me before how do I get rid of the parameter part?
Click to expand...
 
OK, just set the ControlSource to =Text16 + 4 and see what happens.
Make your current TextBox invisible and create a new TextBox with the
ControlSource = Me.1stTextBox + 4. No running sum on this one. There are
Click to expand...
[quoted text clipped - 18 lines]
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200706/1
Click to expand...
Click to expand...
ok using that controlsource =Me.1stTextBox + 4... I'm supposing
1stTextBox will equal Text16 because thats the name of the current
number box. however when I use that it asks me for a parameter for
Me?? I've never used Me before how do I get rid of the parameter part?
Click to expand...

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200706/1
Click to expand...

I swore I tried that same thing before and it didn't work. Oh well
it's working now. thanks alot for the help...
 
Back
Top