Form help.

[Macgyver1234]

Hello

I'm a basic beginner and do not know much about Access.

What I need help with is quite basic for you guys.

1st. On my form there is a invoice label. I would like the invoice to update it self rather than me checking the invoice table and typing the next invoice number.
I used a number of beforeupdate:=dmax yadaydayda.
I must have copied them in wrong so I need help on what I'm meant to enter in.

2nd. When entering information in the form I would like if it told me if I missed something, such as I didn't enter info for P.O number.
I would like if it told me this if I was about to make a new record but left something out in the current one.

[ansentry]

Macgyver1234,

Are you using auto-numbering as your primary key?

If you are then this is the way to automatically add a number for each new invoice. (see attached file)

The format is 2003, I don't have 2007.

Your second part of the question; you can use the "Tag" property of the control on your form. Have a look under TAG in help.

If you need further help then post back.

[Macgyver1234]

Thanks for reply ansentry.

I could use autonumbering, but rather leave the database as it is, as everything has been set up well.
If this is the only way it can be done then I will do it.

[Macgyver1234]

Alright never mind.
I made a backup and changed the invoices to auto numbers.
Its working fine.

Thanks mate.


Just wondering.
When I make a invoice say 00014 and I delete it, if I make a new invoice it will show up with 00015.
Is 00014 taken for ever?

[ansentry]

Have you read the code that creates the new number?
It look for the current maximum number then adds 1. If your last number used was 0014 and then you delete it then your new max number is 0013, so 0013 + 1 and the new number would be 0014.

[Macgyver1234]

How do I find the code for it?
I can't find it in Access 2007.

[ansentry]

The code is behind the form which is in the sample db I sent you.

Open the form in design view and then use Alt-F11 and you will see it.

[Macgyver1234]

Hmm this is strange. When I open your Access form in the code page I get plenty of code and can select labels and such.
But when I open mine up, nothing is listed to choose from....

why?

[ansentry]

I don't have access 2007 so I'm not much help.

[SteveH2508]

Hmm this is strange. When I open your Access form in the code page I get plenty of code and can select labels and such.
But when I open mine up, nothing is listed to choose from....

why?

Make sure your database is in a Trusted Location.

[Macgyver1234]

Make sure your database is in a Trusted Location.

I open the file in the same location where the number file was(there poster above gave me).

Still won't show me code.

Why is this happening?

[Macgyver1234]

Any one?
It seems really basic, if only I could see the code.

[SteveH2508]

Option Compare Database
Option Explicit
Private Sub Form_Current()
Me.txtCusID.Enabled = False
Me.txtCusNumber.Enabled = False
Dim iNumber As Integer
iNumber = Nz(DMax("[CusNumber]", "tblCustomer"), 0)
If Me.NewRecord = True Then
Me.txtCusNumber = iNumber + 1
End If
Exit Sub
End Sub
 
Private Sub cmdNewRecord_Click()
On Error GoTo Err_cmdNewRecord_Click
DoCmd.GoToRecord , , acNewRec
Exit_cmdNewRecord_Click:
Exit Sub
Err_cmdNewRecord_Click:
MsgBox Err.Description
Resume Exit_cmdNewRecord_Click
End Sub

This is the code.