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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. smalty

    Automatic date change

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

    Automatic date change

    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...
  3. smalty

    Automatic date change

    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
  4. smalty

    Automatic date change

    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???
  5. smalty

    Automatic date change

    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)...
  6. smalty

    update table

    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...
  7. smalty

    update table

    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...
  8. smalty

    update table

    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...
  9. smalty

    update table

    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.
  10. smalty

    update table

    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 =...
  11. smalty

    Access 2013 Navigation Forms BrowseTo

    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...
  12. smalty

    Scroll wheel working in some reports but not others

    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...
  13. smalty

    Access 2013 Navigation Form

    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...
  14. smalty

    Method or Data Member not found

    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...
  15. smalty

    Method or Data Member not found

    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
  16. smalty

    Method or Data Member not found

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

    Method or Data Member not found

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

    Method or Data Member not found

    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...
  19. smalty

    2013 Navigation Form Password Protect a tab

    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...
  20. smalty

    Date Fields

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

Part and Inventory Search

Back
Top