Can I make this??????

[Gemini32]

Hi Folks

I thought that I saw something about the autonumber for the Access mdb
but I've looked all through and no luck maybe one you very nice folks could help me on this.....I trying to create an (autonumber) in a text box without designing a table....Is this possible or is it hopeless......Thanks ahead of time for any assistance that can be given....I'd appreciate very much.....


:D Gemini32 :D

 

[Mr Ed]

Sounds hopeless to me

You want a text box that automatically finds the next number in... (what if not a field in a table?)

I guess you could have a text box that increments every time you clicked on it by setting an event procedure like this,

Private Sub Text0_Click()
Me.Text0.Value = Me.Text0.Value + 1
End Sub

But perhaps you should explain what you want to do in more detail.

 

[Gemini32]

Hi Mr Ed

I had made a worksheet in excel and like the format (the layout) I had made the work sheet but to massive amount of data entry I knew Access would be my best bet to hold all the information I was going to put into it,


My over all design is


at the top left hand corner handle our company logo and address and phone#,

then over to the right of that had date, O.Q. # ( Office Quote) then under that to the left hand side there were 15 lines of information under the description label that would be enter when a customer would buy our products not all 15 lines would use every time but were there if we need it....

then right beside it followed qty, wholesale, retail, total, profit and this also had the 15 lines under the label names I just mention above.

then followed the subtotal, then HST (sales tax- 15%), visa fee (3%), then grand total....


so in my original designI tried doing the normal follow through of building a table , then query, then a form but in the form it would only give me one line and not 15 lines that I needed so I went and designed a form but had the problem I didn't have the primary key with the autonumber so then I thought I remember seein something on the site for autonumbers....so that's why the question about the autonumber....Thank you for you response you gave very much appreciated....HAve a great day... :D


Gemini32