Search results for query: *

MajP, Don't worry......figured it out and works good. Thanks again Smalty

Hi MajP Thanks for your reply and suggestion Not being very familiar with public functions, I can follow the code OK and understand the logic so I am quite sure it will work but I don't understand how to pass the 'OriginalDate' to the function?? Would appreciate your further assistance please...

OK.....I think I may be misleading you. Let me say it another way. Lets say I enter an Agreement Date of 01/06/2015 I want a text box (lets call it RevDt)to show 01/06/2016 and then next year on the 1st June the text box value to change to 01/06/2017 etc etc

Thanks for the reply. I understand what you say about the query but I still have the same problem. How do I get them to calculate the same DAY/MONTH every subsequent year???

I currently have four date fields: AgreementDate, RevCompDt, RevDueDt and RevByDt. The AgreementDate and RevCompDt are manual entry fields and RevDueDt and RevByDt are calculated. The formula for each is:RevDueDt = IIf(IsNull([RevCompDt]),[AgreementDate]+335,[RevCompDt]+335)...

In fact I have re read your suggestion and I don't think it will work. I think you are saying when any change is made in either tClient or tClientFeeComms check if the 3 criteria exist for that client using an sql to produce a record set. If the record count for that record set is zero add that...

I am pretty sure that your suggestion will work as I understand the theory. However I am very 'rusty' on most of this stuff and therefore it will take me a while to work out exactly how to write the entire code you have described. I will get back as soon as I have done that. Once again I really...

My apologies for not explaining properly. I will try and be clearer. I have three tables like this: tClients [ClientID] [FullName] [ClientStatus]............. tFeeComms [FeeCommID] [ClientID] [FeeStatus] [AdviceArea].............. tClientFundPerc [FundPercID] [ClientID] [Fund] [Percent] So...

I am using both your suggestions (ClientID and a percent field that has a default value of 100. My problem is getting the new record in the other table if all 3 criteria are met.

I hope this question is in the correct forum. Any help greatly appreciated I have two tables tClients and tFeesComm. Fields in tClient include ClientStatus and fields in tFeesComm include FeeStatus and AdviceArea. What I would like to happen is if ClientStatus = Signed Up and if FeeStatus =...

I am using Access 2013. I am developing a DB based on 'Navigation Forms'. I have a tab which opens a subform containing 'Clients'. Also in this subform is a button which uses the 'BrowseTo' to navigate to another subform (EditDiary) which opens at a record designated by the 'FullName' open at...

I am working in Access 2013. I am using a 'Navigation Form'. One of the Tabs displays various reports called vis a combo box drop down list. This function works perfectly. However some of the reports when called from within the Navigation Form allow scrolling via mouse wheel and others do not...

I am using an Access 2013 'Navigation Form' and on one of the Tabs there is a subform container which is used for the 'BrowseTo function for showing various forms and reports. One of these Forms (fHomeClient)contains a subform (fClientFeeComm)which contains a FirstName and LastName field which...

Thanks for your time and suggestion I've gone with the Visible option and used a 'greyed out' version of the same image beneath the original. Works perfectly well as expected. I was just interested as the I got the original code from a tutorial which was describing how to create these...

Yes 'Visible' works except that the button disappears rather than gets 'greyed out'. I suppose I am just being a bit fussy although it would be good to know if 'Enabled' should work on imported graphics. Should it??????? Anyway appreciate your time looking at it for me......thanks Smalty

It's just a 'graphic (png file)' which I am using as a 'button'

The intelisense list does appear but 'Enabled' is not in the list!!!!!

I am using the following code to Disable the custom First, Last and New Record buttons but receive an error message when I press one of those buttons and being relatively new, do not understand why. Could someone explain please? The code is Private Sub Form_Current() On Error Resume Next...

I am working in Access 2013. I am using a 'Navigation Form' (not a TAB control) with horizontal tabs When the user hits one of the three tabs currently available, before seeing anything in this tab the user must enter a password to continue. The tab will contain 5 controls, consisting of 4...

Apologies.......it is working.............thank you for your very prompt help regards Smalty