Search results

Thanks for the advice I'll check out Vbulletin. Cheers

I have been an avid user of this site and the MrExcel site to help in my work developing applications for work. They are an impressive tool in my job now. I am thinking of setting up something similar to support our client/licensee base and was wondering if anybody could provide some guidance...

Found answer thanks Found that by simply modifying the DateDiff function I could obtain my answer.MonthsElapsed: DateDiff("m",[customers]![startmonth],[startdate]) Works a treat.

I found the following code on this site in a search for a method to subtract two dates ie [Startdate] and [EndDate] and display the result as a whole number. ie 2, 6 etc. This code finds the difference but displays the results as 1 year 5 months 2 days, where I need the equivalent as 17. Can...

Moving DB to another machine RG That link did help explain what was going on, Thanks. This does highlight the following problem:- I am building a DB in A2k with data transfer to Excel. I have had to add a reference to the MS Windows Common Controls 26.0 (SP4). I need to be able to make the DB...

I don't know about that RG. If it's been a long "TIME" since you were born it's going to have a significant impact on your age. :) I'll check that link. Thanks for the suggestion.

I have been using the following code in a query to calculate age. It has worked fine in my Office 2k system with service pack 3. I have installed the database on other office 2k machines and had to upgrade to service pack 3 or else I received Undefined function "format" in expression errors. I...

no recordset Hi RG. Tried the syntax with no luck. Then tried the diagnostics and as you predicted I get 0 on the new ones. Is it problem with my Income query? Can't understand why it works at times and then doesn't.:(

Thanks Thanks Neil and RG for your suggestions. I will see how they work. Hey RG after all that work and apparent success I came in on Monday and blow me down, it was doing it again. (I am getting a good lesson in controlling frustration). Any way I got rid of the After Update code on each of...

Hopefully a simple one that is eluding me at the moment. I have a control on a sub form that refers to a value on another subform. When I enter data in the controls subform it will display the correct answer. However, when I close the form and return to it later the control is blank and will...

I have a sub form in a tabbed control that collects client income data. A subform of that [Tax table calc frm] calculates the tax payable and the following code displays the result in the [c1TaxMedi] and [c2taxmedi] fields on the income form. Private Sub Command122_Click() 'Calculate taxation...

OK I'll upload to our website. Get back to you in a minute. May need to give you a sign on and password. How can I do that securely?

Hmmm, not sure what your after but I can tell you that the popup form is not modal and border style is sizeable not dialog (if that is significant). What I don't understand is that after doing the delete by using the popup form the word #deleted appears immediately in the display subform. If I...

Now you have me stumped. What does the "ACDialog" argument do. I haven't knowingly come upon that one yet. Can't find it in help. Heeellllp! By the way your last message was received here at 5.00pm Thursday, 3 November. So I figure your about 9 hours ahead or 15 hours behind. Whatever, you've...

:confused: OK I have added a me.requery to the open form button (no change except that if I open it again the #deleted vanish) I added a me.requery to the onclose event of the input pop up form with no change. It is puzzling that the desired outcome is achieved by moving to the next record or...

I will do the refresh thing now. Private Sub capmvmntinputbtn_Click() On Error GoTo Err_capmvmntinputbtn_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "CapitalMovementFormInpt" DoCmd.OpenForm stDocName, , , stLinkCriteria Requery...

Done but no change. Still displays the #delete until I press the save button.

Hey RG here it is Private Sub Form_AfterUpdate() DoCmd.Echo False Forms![Customers]![CapitalMovementQry].Form.Requery DoCmd.Echo True End Sub Would the fact that the delete button controls the delete function affect the after update event of the form that it is placed on. IE the add and...

Hi RG The form that I want to update is a subform in a tabbed control. The popup form holds the requery command in its after update event. As I mentioned this works well for new records and changes but not for deletes. I have now gotten around it by placing a save button on the subform so that...

I have a "display only" subform that is updated by a popup form. If I add or amend an entry the details of the changes are displayed immediately in the display window by requerying the form "afterupdate". However, I have a delete button on my popup form which will delete a record but replaces it...