Search results

I have a table of people (subscribers table - primary key subscriberID). Each subscriber can have multiple addresses (address table - Primary Key AddID and foriegn key SubID). I want to note which address I should ship a book to in the month of May each year, so in the address table there is a...

Thank you, the dcount worked.

I have a form (Family) that has a subform (children). On the main form, the is a next button, previous button and a combo box that allows a user to navigate to a specific family. I need to be able to know how many children there are when I navigate to a record. I have tried a few options that...

I have an unbound form. There are two text boxes on the form, one for TotalRecords and the other for CurrentRecord. When I click the start button a process starts where I append records to a table (that part is working fine). Since this process can take a long time (10 minutes or so), I want...

That did the trick. I did have to add this code as well to force the form to update (save) as well. If me.dirty then me.dirty = false end if

I was able to add the code to the main form button that navigates from one record to the next. That way it only fires when the record is first brought up. Thanks for pointing me in the right direction with the RecordCount code.

On Current runs whenever I click on a button in the subform. When I click on button 2 (to bring up the 2nd child) the On Current event fires and sets the button back to 1. The only condition I can think of would be to add an invisible text box that would initially have 1 value and then change...

Well, I thought this was solved, but it caused another problem. Because this is set to on current, the only buttons that light up is 0 and 1. If I click on button 2 the code on the on current turns it back to 1. I need to find a way to use this code on an event that ONLY happens when the...

Got it! Thanks. Here is the code that worked for me: Private Sub Form_Current() If Me.Recordset.RecordCount > 0 Then TurnOnButton (1) Else TurnOnButton (0) End If End Sub

That was what I thought as well, but then where do I put the code to do the recount?

I am not sure what you mean. I get that you want me to add code to the On Current event of the subform but what do you mean about doing a recount?

I have the code as part of the add new record routine. If a user clicks the button to add a record this code is run: If MsgBox("Add new child?", vbYesNo + vbQuestion) = vbYes Then DoCmd.GoToRecord , , acNewRec Me.Form.Recalc End If The current code is not updating the...

I have a client that does not want to use the Access navigation buttons. Instead wants to have toggle buttons. On the subform there can be up to 6 children. I have set up the buttons and have the code to turn them on or off as I move from child to child. I have created a subroutine I call...

No recalc available. I tried anyway and the code failed. I did find I could do Me.Recalc, but that did not work either.

I have an unbound text box called ChildCount on a subform. It's code is =count(*). When I add a new record in the subform, it does not update. I have tried to add Me!ChildCount.requery to the code that adds a new record, but that doesn't seem to work. If I move to a new family (main form)...