Search results

OK, I have the form counting!! When it's open by itself, it doesn't count when loaded as a subform. I get a compile error, method or data member not found. I have the formula correct, or atleast I thought I did, since it's working by itself... Me.Run = Nz(DMax("Run", "[Time Entry]"...

Woohoo!!! I've got a number coming up in the run field now, only problem is that it's always 1, it doesn't count up, here is the code I've got... Me.Run = Nz(DMax("Run", "[Time Entry]", "[Run] = " & Me.Run), 0) + 1 I think I've got a loop in there or something, but I don't know? Going on...

I tried your code and I got the same error. Here is a link to my database, I don't want you to do it for me, I am just hoping this will better help you understand what I'm doing, I suck at explaining things. parts washer Take a look at the file, Data Entry is the main form with subforms of...

I am getting the error, "can't find the macro Me" Do I need to create one of these?? Here is the code I have now... Me.Run=Nz(DMax("Run","[Time Entry]","Forms![Data Entry]![ID] = " & Me.Forms![Data Entry]!ID),0)+1 The ID field in the Time Entry form is set to copy the ID field in the data...

Ok, I think I understood what you said... Here is the code I am using now... =Me.Run=Nz(DMax("Run","[Time Entry]","Forms![Data Entry]![ID] = " & Me.Forms![Data Entry]!ID),0)+1 Now with this code I'm getting an error, "the object doesn't contain the Automation object 'Me.'. I'm pretty sure...

First off, thanks for helping me out!! I want the Run column to be the sequential number... does that mean I need to change the me.senum to me.run?? Should it look like this?? Private Sub Form_BeforeInsert(Cancel As Integer) Me.Run = Nz(DMax("Run", "[Time Entry]", "Run = " & Me.Run), 0) + 1...

I'm trying use this formula, but I'm messing it up somewhere. I have a form, called Data Entry, that uses the autonumber and the field is ID. I have a subform, called time entry, to insert times that machines have run. The form has a run #, time start, time stop, and run time field. Here is...

NM, I got it figured out... Is there any reason why it should take like 30 seconds to clear the field for nine records with subforms?? I'll put a link in here so you can see it first hand... Thanks!! http://www.crawfordmachineinc.com/db6.mdb

I am having the same problem... RunTime error 3144 Syntax error in update statement. here is the code that I'm using Private Sub Update_Button_Click() Dim dbs As Database Dim sql As String Set dbs = CurrentDb sql = "Update Data Entry Set Check to Print = 0" dbs.Execute (sql) End Sub I...