Search:

Type: Posts; User: chinaboy; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    4
    Views
    718

    Re: Preview access report without printing

    Thanks for your response. I wasn't sure what the 340 meant. I found the code on a forum. I was hoping to open the report in a viewer and then the user can print if they wanted to. This method...
  2. Replies
    4
    Views
    718

    Preview access report without printing

    Hi, I have set the report to only open in preview but it always opens the print dialog box instead. What am I doing wrong?


    Private Sub CommandButton2_Click()
    Dim objAcc As Object
    ...
  3. Replies
    7
    Views
    268

    Re: Prevent delete based on date condition

    Hi... I am so sorry, I thought this was working but it appears to still be doing the wrong thing.

    When I delete try to delete a class that has expired, I still get MsgBox "Do you really want to...
  4. Replies
    7
    Views
    1,083

    Re: Update Checkbox status

    Thank you guys for advice and suggestions. I was able to get the status in the checkbox to show correctly by placing the code below in the change() event of the combobox.


    Me.chkClasses.Value =...
  5. Replies
    7
    Views
    1,083

    Re: Update Checkbox status

    Ok.. Thank you very much. I haven't been able to populate the box at all, and thats my main reason for requesting help. But once I am able to do so, then I will be sure to include a refresh command.
  6. Replies
    7
    Views
    1,083

    Re: Update Checkbox status

    Hi...so seems like I should bound. How would I go about doing so?
  7. Replies
    7
    Views
    1,083

    Re: Update Checkbox status

    Thank you for assisting. I am by no means an expert and just learning as I go. I some how omit the With for the recordset in my post, but do have it in my code. Using the f8, I did, but because of my...
  8. Replies
    7
    Views
    1,083

    Update Checkbox status

    Hi all, I know some of what I am doing is not the best possible solution but work with me. I have combobox that is populated from an access table. That works great. Now I have a checkbox that I use...
  9. Replies
    7
    Views
    268

    Re: Prevent delete based on date condition

    Sorry Tom, This actually did the trick.

    Thanks for your help.
  10. Replies
    7
    Views
    268

    Re: Prevent delete based on date condition

    Tom, this did do the trick. I was putting code in wrong place.

    Thanks so much for your help.
  11. Replies
    7
    Views
    268

    Re: Prevent delete based on date condition

    When I use the updated code and try to delete, it went to msgbox "you have entered a wrong value."

    It should be using the selected record from the listbox "lstClasses" based on column 3 then if...
  12. Replies
    7
    Views
    268

    Re: Prevent delete based on date condition

    I do think you do understand... Where exactly should I replace or insert. I got a run-time error 3021... Saying the record may have been deleted.....Request operation requires a current record. But I...
  13. Replies
    7
    Views
    268

    Prevent delete based on date condition

    <code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;">Hello, I have a delete routine below that works great for my purpose. I am trying to stop users...
  14. Replies
    1
    Views
    480

    Registration form - Ideas

    Hi.. I am looking for suggestion / guidance on the best approach.

    I have a user form that users can register for classes. They select they name and class they want. They can also go in and delete...
  15. Replies
    1
    Views
    167

    Re: Lock cell or prevent changes

    No suggestions?
  16. Replies
    1
    Views
    167

    Lock cell or prevent changes

    Guys, I have a shared workbook which I have the code below to prevent users from deleting data unless they have the password. That works great. But I noticed users instead are just over-writing the...
  17. Replies
    4
    Views
    141

    Re: Require password to delete entries

    Thank you... That did the trick.
  18. Replies
    4
    Views
    141

    Re: Require password to delete entries

    The code is currently in the ThisWorkbook in the Worksheet_Change.

    Nothing happens when I try to delete existing data.
  19. Replies
    4
    Views
    141

    Require password to delete entries

    Good morning... I have a piece of code that should require a password prompt when a user attempts to delete data after entering it. But it doesn't seem to work. Ver new to this vba stuff. There is a...
  20. Replies
    11
    Views
    902

    Re: Calculations based on checkbox selection

    Thanks for the information. I will give it a try.
  21. Replies
    11
    Views
    902

    Re: Calculations based on checkbox selection

    Hi, I have one more problem. Let me know if I need to post a topic for this one. My increase amount and new salary both needs to divisable by 24. The increase amount should also rounded. My current...
  22. Replies
    11
    Views
    902

    Re: Calculations based on checkbox selection

    Disregard last post, I figured it out. Thanks:biggrin:
  23. Replies
    11
    Views
    902

    Re: Calculations based on checkbox selection

    Bertie, you are the man. I have re-done the spreadsheet using what you have done as a guide. Works great. In the Increae column, I need to round up or down. I have used the Round function before, but...
  24. Replies
    11
    Views
    902

    Re: Calculations based on checkbox selection

    Bertie,

    I like what you have done. I will give it a shot. I think that can work. Will PM you as I think what you have will give me a good start.

    Thanks so much.:)
  25. Replies
    11
    Views
    902

    Re: Calculations based on checkbox selection

    Ok, hope this works

    I will have anywhere between 20 - 30 employees on the spreadsheet. Col. D will have current salary.....Col E will have the increase amount, which is calculate when the user...
Results 1 to 25 of 27
Page 1 of 2 1 2