Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DMAX User Input on a Form?
Almost there... Still unable to pass ProgramID to DMax statement. Can I email a test file to you? Only 265K. Problem lies in DMax statement. It works if I force Me.cboProgramID to be value I am looking for. Private Sub cboProgramID_AfterUpdate() ' First Insert a New Record...- rprieto
- Post #8
- Forum: Microsoft: Access Forms
-
DMAX User Input on a Form?
Please tell me how to do this in VBA. I need an example. The default Add New Record is currently as follows: Private Sub cmdAddDATARec_Click() On Error GoTo Err_cmdAddDATARec_Click DoCmd.GoToRecord , , acNewRec Exit_cmdAddDATARec_Click: Exit Sub Err_cmdAddDATARec_Click: MsgBox...- rprieto
- Post #5
- Forum: Microsoft: Access Forms
-
DMAX User Input on a Form?
Where do I place this? I had placed it in the Default field value of the form for fldRecordNumber. If it needs to be in VBA how do I do this in combination of adding a new record? =DMax("fldRecordNumber","tblRecord","[fldProgramID] = " & Program_Input)+1 The...- rprieto
- Post #3
- Forum: Microsoft: Access Forms
-
DMAX User Input on a Form?
How can I allow a user to define the "fldProgramID" below within a form? The following works but I must force the fldProgramID=1 to find the last record number and increment by 1 to insert a new record for a specific ProgramID. I do not want to use the Autoincrement since it is...- rprieto
- Thread
- Replies: 8
- Forum: Microsoft: Access Forms
-
Need help in incrementing composite primary key
Thank you for your near immediate reply. Forgot to mention that VBA is new to me. More info is best for me. Will work on later today.- rprieto
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Need help to increment a composite primary
Duplicate post. Please ignore. Posted in Access area.- rprieto
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Need help in incrementing composite primary key
I need help in creating an autonumber like field. Program_Name and Prg_Rec_No are composite primary keys. Originally Prg_Rec_No was an autonumber field type and this was OK when the database was used for only one Program. Now it is to be used for multiple programs. How can I auto-increment...- rprieto
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Need help to increment a composite primary
I need help in creating an autonumber like field. Program_Name and Prg_Rec_No are composite primary keys. Originally Prg_Rec_No was an autonumber field type and this was OK when the database was used for only one Program. Now it is to be used for multiple programs. How can I auto-increment...- rprieto
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Auto Increment Composite Primary Key
What I hope to do is this. Upon entering data for a new Program_Name, say "Program D", I would like Access to recogonize there are no pre-existing records of "Program D" and automatically create a new Task_ID to be "1". Also, I need Access to recogonize upon...- rprieto
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Auto Increment Composite Primary Key
I need help in creating an autonumber like field. Program_Name and Task_ID are composite primary keys. Originally Task_ID was an autonumber field type and this was OK since the database had only one Program. Now it is to be used for multiple programs. How can I auto-increment the Task_ID...- rprieto
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
