Search results

I am attaching a screenshot for you. Thanks!

I don't need the auto number as soon as it opens but before the form is updated. I believe RainLovers code would work for me but my programming skills are very rusty. I posted the code that I added but sure that the error is on my part. I must not have changed something in the code correctly...

Yes it's bound. I did have it working before I rebuilt the database. It was as simple as adding Date() and "short date" to the properties of that field in the table.

I've worked on this all day and just keep coming back with what I posted above. Any insight?

Okay just to clear things up. The moderator wrote in that thread that it should be deleted and start new. A few others on your side of the forum mentioned it too so it's was deleted. Thank you! Does anyone have any insight into this problem of the "auto number"?

I have the date set in the table and it shows up fine in the tblDate cell but doesn't pass through to the txttblDate in the form. I did have it working just fine until I rebuilt my database

Here's the code I used. I'm sure it's an error on my part. RainLover knows what he's doing so it surely has to be me. Thanks Private Sub txttblPO_AfterUpdate() If (conHandleErrors) Then On Error GoTo ErrorHandler ' If we have some data If Len(Me!txtlblPO) Then ' Find...

Hello. I deleted the thread because of all of the fights that were going on. One guy was banned from the thread because of his actions. I stopped posting on #40 and the fights and rude comments when on until #57 or so. I deleted and started a new thread based on moderator advice. Thanks!

I do have that but I can't open it in design view just get the form. I do remember getting instructions from RainLover but deleted the thread. Thanks!

Started a new thread: Rebuilt database and still need help with auto number for multi user form. The code I have works for single user but not multi user. Also if someone opens the form and closes without adding anything to the form the number is used with blank record. This is what I have...

No I didn't reset. I'm reading the links he sent and trying to understand the links he sent in 26. I didn't see them the first time as I think I was in a mode of just trying to fix. I don't understand why they joined the relationships the way they did.

Cj_London are there repercussions if I want to compact and repair my database? I think I'll also put a Next PO button in. I don't like the way the naming convention that they used in tables and fields but I'm a bit stuck with it now. Just and after thought.

CJ_London how would your code: [PO#] = nz(DMax("[PO#]", "Purchase Order Table")) + 1 work in a multiuser environment? Thanks!!

Okay RainLover I changed my field name to "PO". I took the single user code and tried it and it doesn't work for me. I'd also like to know how your single user form is updated. I see that you have it written for AfterUpdate but don't see where it actually gets updated. I am unable to see...

I don't get anything in the table or on the form. No errors either. The field is defined as a number. Thanks!

jdraw I did read the articles and looked at the samples and they were a bit over my head. I also had others check it out and they didn't understand either. gemma-the-husky the code is still not working for some reason? I did allocate at the end. Am I missing something? Could it be because...

The code still doesn't work. This is what I have now. Private Sub Form_Current() If Me.NewRecord Then PO# = Nz(DMax("PO#", "Purchase Order Table")) + 1 End If End Sub So if more than one user will be using the form is there a way that I can make it so the PO# will be unique for each? Also...

Okay. I got that but it isn't working for me. Private Sub Form_BeforeInsert(Cancel As Integer) PO# = Nz(DMax("PO#", "Purchase Order Table")) + 1 End Sub Could it have something to do with the spaces in the table name? My goal is when I open the form a new PO# comes up.

Okay I did read it and it doesn't look like I want to use that. Especially with the dropped numbers on compact. So if I'm looking to set like and invoice number on each form what would be the best way to accomplish this? Thanks!

Hello all I am looking for some help with next number showing up on form. I set tried to setup auto number in my table but my key id is setup as autonumber and it tells me I can't have two. Is there a way to get a "next number" to show up on my form when I open the form? I'm also hoping that...