Recent content by avenger619

  1. A

    Treeview for client folders

    Any help is appreciated. thx
  2. A

    Treeview for client folders

    Hi guys, was not sure if this was the right place for this thread, but here it goes. Am looking to do a treeview type of search to hyperlink to client file/folders on my network. This way I can hide the main file source location in the network and files can just be accessible via Access program...
  3. A

    Hidding Fields Based on number

    Hi guys, I search around online and did come across much info on code to how to hide fields. but, the problem is I cant seem to find a way to hide a certain amount of fields based on a number amount. example: Lets say I have a 12 text fields to show 12 months of monthly payments, and lets say...
  4. A

    File Search by keyword

    Can anyone help with this? I would appreciate very much. Thanks
  5. A

    File Search by keyword

    So I found something actually even better, check out this post by John Big Booty ( http://www.access-programmers.co.uk/forums/showthread.php?t=188663) db sample. This is almost perfect if only the search results could be displayed for folder paths on my network were I keep client files and be...
  6. A

    File Search by keyword

    Hello everyone, I have search the web and came across something pretty similar to what am looking for (http://access.mvps.org/access/modules/mdl0051.htm), unfortunately this database sample does not work with my Access 03, so I cant really play with it. What I want to do is have 3-4 Paths...
  7. A

    Auto Populate based on term

    Any suggestions welcome. I have hit a wall:banghead:. Thank you
  8. A

    Auto Populate based on term

    I cannot find a way to do this, can anyone help? Much appreciated thanks.
  9. A

    Auto Populate based on term

    So I found a db sample that is some what useful. I have played with it and customized it to kind of what am after. If you click view schedule it brings up a form very close to what am shooting for, all that is missing is a functional check box next to each payment row so I can mark true when...
  10. A

    Auto Populate based on term

    Hi Guys, I was wondering how can I auto populate fields based on a payment term & amount? example: client has 9 monthly payment of $150 term due every 15th of the month. (I would like it to be able to max out at 30 months) So what I want to do is populate 9 monthly fields with dates and $150...
  11. A

    Default Value Help

    Hi Guys, I have a sub form and one of my text box am in need of a default value. the text is for Authorize account holder so I wanted the default to be the "applicant" so this is what I listed in the default section =[Applicant]. Applicant does appear, but as I scroll to other record it does...
  12. A

    In need of Else Code statemet

    Solo, So I tried this option which does not work quite right. As I scroll through the Applicant records its disable for all:banghead:. Private Sub Sold_Click() If InputBox("Enter Password", "Approved") = "dfl545" Then Me!Sold = True Me!Sold.Visible = True Me!Sold.Locked = True Else Me!Sold...
  13. A

    In need of Else Code statemet

    lagbolt, this is interesting. cause I have about 10-20 fields that are password protected, so you can imagine the hassle. lol How do I go about establishing something like that?
  14. A

    In need of Else Code statemet

    ypma, I originally tried that code, but the downside is that if no password is accepted then it changes true to false right off the bat. Example: Let say I go ahead as manager click & add correct password, it changes it to true. But if an employee goes back and click on it adds incorrect...
  15. A

    In need of Else Code statemet

    Hi Guys, Currently I have this bottom code on a check mark, but I want my Else code to reflect no change. So if password is not accepted then no change, can anyone help with proper code? Very much appreciated. Thank you Private Sub Sold_Click() If InputBox("Enter Password", "Approved") =...
Back
Top Bottom