Search results

Attach your DB and I'll take a look.

The Doc_Man has a good point. Previously you wanted to reference the previous record now you want to reference two records previous. But, if you are always in control of your record entry it should be fine. You need to first find the ID of the previous record and then use that to find the...

Are you trying to show all the records of the table in the form? If so, you would need to do: [code] Private Sub cboTaskListName_AfterUpdate() 'On Error GoTo cboTaskListName_AfterUpdate_Err If Me.cboTaskListName = "111111" Then Me.RecordSource = "SELECT no1 from test" End If End Sub...

You can do this in a couple of ways, both may require more coding than you've done in the past so it might be easier as a learning experience to attach you DB and I can show you. 1) Assign criteria to each field in the recordsource of the subform so changes on the main form affect which records...

You could set the criteria for ship date to: [Forms]![yrFormName]![ShDate] Or Is Null

I would place 2 hidden controls on the form, 1 to be used as the criteria for the Start Date field and one to be used as the criteria for the Ship Date field. Then, based on your toggle, assign these values depending on which is to be used as the actual criteria: If Me.Toggle1 = 0 Then 'assume...

Is this query used as the record source for the form? How are you using this query?

Go ahead and attach your latest DB. Are base 3 - base 1 network number on the same record?

You already have it setup to allow value list editing. You can add, delete or edit any record in your list by either right clicking and selecting Edit List Items or selecting the floating icon that appears at the lower left of the list.

Thank You Mihail. Sometimes things click and you can come up with a simple solution.

Well said Spike. It's bad enough when you help someone and they don't thank you but this guy gives little to go by and expects the world. Some people.:(

I find myself in the same position, this time I was able to come up with a solution. I'm glad I could help, good luck with the rest of your project.

Here is the query: SELECT MemberRecognition_Final.ORG_NAME, MemberRecognition_Final.PERS_PK, MemberRecognition_Final.PERS_NAME_LAST, DCount("*","MemberRecognition_Final","[ORG_NAME]='" & [ORG_NAME] & "' And [PERS_PK]<" & [PERS_PK])+1 AS BdMbrCount FROM MemberRecognition_Final ORDER BY...

If you have an autonumber primary key for the table you do something like this to count based on the Org_Name: SELECT tblOrgs.PKID, tblOrgs.ORG_NAME, tblOrgs.PERS_NAME_LAST, DCount("*","tblOrgs","[ORG_NAME]='" & [ORG_NAME] & "' And [PKID]<" & [PKID])+1 AS BdMbrCount FROM tblOrgs; It will just...

Is your ultimate goal to show this list in a report? The reason I ask is the report has an easy way to do so, it allows you to create a control with the datasource =1 and then do a running sum over the group essentially counting by 1 so your list would be 1, 2, 3 etc. You then setup the report...

We all learned this way, glad you solved your problem.

Could you explain how you are determining the value of BdMbrCount and is this something that is only used on a temporary basis? Are you just counting by 1 - 7 and starting over again and it doesn't matter which record gets what value?

Are you trying to save a value to a table? You can't save a value to a query. In a query you can use an equation or reference a function to show a value that is not in the underlying table.

For both forms, in the forms On Open event add: DoCmd.GoToRecord , , acNewRec

When you are working with a text field you will need to surround the variable with single quotes. Dcount("*","maintable","[fldText]='" & Me.fldText & "'") ... DoCmd.OpenReport "rptMaintable", acViewPreview, , "[fldText]='" & Me.fldText& "'"