Search results

  1. DanG

    Protect Confidential Data w/ Web Based Interface?

    I read that "Learn Access in 24hours" and I'm golden now :D Sorry I couldn't resist, too funny :eek:
  2. DanG

    VBA Check Boxes

    Maybe that is why there were not so many solutions out and about :eek:
  3. DanG

    VBA Check Boxes

    Thank you for the feedback, I was getting an error on a piece of your vba (it would help if I knew what I was doing), so I found something and modified it to work for what I need (kind of a hack job, but it works). Sub CheckBoxMe() Dim ToRow As Long Dim LastRow As Long Dim MyLeft...
  4. DanG

    VBA Check Boxes

    Hello, I would like to have check boxes (with no label) insterted to the left of any row that contains data in it. I will get a list and then I want to automatically insert check boxes so the user can check/uncheck the items on the list. Here is what I haev starting with. Though in this code...
    • DanG
    • Thread
    • Replies: 4
    • Forum: Excel
  5. DanG

    Prevent Now() in Formula from Updating

    Thanks again!
  6. DanG

    Prevent Now() in Formula from Updating

    I don't know how many times I've needed to do that and just gave up! But taking a moment to think about it, couldn't you also (through VBA) enter the date in the cell using Now() and then Copy/Paste as values (using VBA)? Thanks for the post!
  7. DanG

    html template

    Oops! I got so carried away with the HTML tags, I just kept it going :o
  8. DanG

    html template

    Hello, Yes you can insert php into any html page. example.. <body> <h1>Hello this is my webpage...</h1> <p> Here is my content...</p> <?PHP> INSERT PHP SCRIPT TO RUN BETWEEN THE "php" tags</PHP> <p>And that is how you do it!</p> </body> Of course you need to have a server that supports PHP...
  9. DanG

    Duplicate Records Problems...

    I am not sure about the code but controling duplicates should be done at the table level. You are better posting your question in the Access thread.
  10. DanG

    PHP doesnt add quantity to shopping cart - always adds 1 item

    I would start with the HTML myself. Your select structure is unlike anything I've seen before. Structure should be: <select> <option value ="volvo">Volvo</option> <option value ="saab">Saab</option> <option value ="opel">Opel</option> <option value ="audi">Audi</option> </select> If...
  11. DanG

    Programming against design, who is the best?

    I think I've used some of his applications before, did he help build Windows Vista?
  12. DanG

    VBA to get the value of the cell above

    I always love the explanations! Thanks again.
  13. DanG

    VBA to get the value of the cell above

    Thanks Brian... Code is good, data has issues (imported from other system, need to clean). Thanks for the last tip as well.
  14. DanG

    VBA to get the value of the cell above

    I had the same error (with original code) on two machines between today and yesterday. Let me make sure the problem isn't with my data (datatype...corrupt sheet...?). Thank you for your help!
  15. DanG

    VBA to get the value of the cell above

    I get and error message: "Application-difined or Object-defined error" Which is the same error I got with my original code. It doesn't seem to like the... Cell.Value = Cell.Offset(-1).Value
  16. DanG

    VBA to get the value of the cell above

    I am finding I can tweak VBA and understand it, but not much good at writing it myself. I would like to loop through a column and if there is no value in the current cell I want that cell to equal the value of the cell above it. Here is what I have... Sub NewSSN() Dim myrange As Range Dim...
    • DanG
    • Thread
    • Replies: 8
    • Forum: Excel
  17. DanG

    Form Filed Validation

    Thanks guys! You learn something new every day and it only hurts a little.
  18. DanG

    Form Filed Validation

    Hi RG, That seemed to do it...thank you very much. I am using the OnCurrent event. If I may ask.. Len(Me.OBusHOName & "") What is the "" part do? I assume it conts the len if there is nothing in the field but I just don't quite get it. :confused:
  19. DanG

    Form Filed Validation

    I suck at VBA, but I'm still trying to work my way through it. I can not get this code to work... If IsNull(Me.OBusDMAprvlDate) = False And IsNull(Me.OBusHOName) = True Then MsgBox ("Fill in your name dummy") Else MsgBox ("Hello") End If If "OBusDMAprVlDate" has a date in it I want...
  20. DanG

    Paste Word Doc into Access Report

    The only reason I prefer to do it this way is it is a self contained solution (using Access only) and I need this because I am sending the database to a print vendor to print the letters. I m have not done any Word Automation, but if it is anything like working with image files there is a path...
Back
Top Bottom