Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Re: Erase Contents of Field in Error (Access 2000 SR1)

    Douglas:

    Thanks for the reply.

    Me.repaint did not work. The contents of the field stayed at the invalid value. I believe that I had tried this solution before I posted my question (I had tried...
  2. Re: Erase Contents of Field in Error (Access 2000 SR1)

    I am using the Before Update event of the control. Here is the code. I have bolded the relevant part. Thanks.

    PS - I apologize, in advance, for the novice approach but I'm a VBA novice!...
  3. Re: Erase Contents of Field in Error (Access 2000 SR1)

    Thanks for the replies. Yes, that is correct, I only want to clear the control that is in error.

    Here are the results of testing using the suggestions:

    When I used the Me.ControlName.SetFocus...
  4. Erase Contents of Field in Error (Access 2000 SR1)

    <P ID="del"><FONT SIZE=-1>Post deleted by CarolW</FONT>
  5. Key Down/Key Press Situation (Access 2000 SR1)

    I have a situation where I need to parse a string and execute various pieces of logic when the user enters a * or a +. When I use the numeric keypad (num lock light on), it works perfectly. When I...
  6. Replies
    4
    Views
    345

    Re: Jumping Back a Screen? (Access 2000/SR1)

    Jack and Charlotte:

    Thanks to you both for your suggestions. We may go Jack's way unless we end up with too many open forms. In that case, we'll use Charlotte's idea.
  7. Replies
    4
    Views
    345

    Jumping Back a Screen? (Access 2000/SR1)

    Here is another of my novice questions <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>:

    We are emulating an old DOS system in which the escape key was
    programmed to take...
  8. Re: Assigning Seq. Number to Query Results (2000-SR1)

    Rupert:

    Thanks for the link. That's a great site. I'll definitely be making a lot of use of it <img src=/S/exclamation.gif border=0 alt=exclamation width=15 height=15>
  9. Assigning Seq. Number to Query Results (2000-SR1)

    I would like to assign a sequential number, beginning with 1, to the resulting rows of a query. I have a form bound to this query on which I need to show this sequential number. Is there a function...
  10. Re: Programmatically Updating Control? (Access 2000/VBA)

    Thanks for the reply.

    We are VBA novices and had initally changed this option to "Don't Move" not realizing that keeping it at "Next field" was exactly what we wanted! The code we've developed to...
  11. Re: Programmatically Updating Control? (Access 2000/VBA)

    Charlotte:

    Thanks for the reply. I realize that I did not go into a lot of detail in my original post.

    I've actually solved the immediate problem that prompted my post but I have a more...
  12. Programmatically Updating Control? (Access 2000/VBA)

    I have a text box control that may or may not be entered from the keyboard. In other words, the user may not enter any data. I wish to programmatically simulate an update to the control and therefore...
  13. Replies
    9
    Views
    551

    Re: Access Limitations? (2000-SR1)

    I t hink I discovered the answer to my question about the lounge software. It is only replies to the original post for which email notifications are sent.

    Duh!
  14. Replies
    9
    Views
    551

    Re: Access Limitations? (2000-SR1)

    Mark and Charlotte:

    Thanks for the info.

    I'm not looking at any more than 200 (maximum) forms and fewer than 50 reports. It sounds like this should not be a problem, from what you guys have...
  15. Replies
    9
    Views
    551

    Re: Access Limitations? (2000-SR1)

    Mark:

    Thanks for the quick reply.

    Re: #2 - Our understanding is that specific reports will always go to a hard coded printer. Can this be done in Access 2000?
  16. Replies
    9
    Views
    551

    Access Limitations? (2000-SR1)

    We are preparing a proposal for a client who requires that a custom written DOS restaurant system be rewritten in a more up to date environment. We are considering developing the app in Access 2000...
  17. Replies
    2
    Views
    328

    Re: Simple SQL Question (O2K - Access - VBA)

    Charlotte:

    Thank you so very much for the prompt, accurate response.

    One of the variables (tempmon) was a string variable and so I had to add a few double quote marks. I did manage to figure...
  18. Replies
    2
    Views
    328

    Simple SQL Question (O2K - Access - VBA)

    I know this is a simple SQL question but I'm relatively new to SQL and it's driving me nuts! Here goes:

    I have coded a SQL statement in a VBA function as follows:...
  19. Replies
    3
    Views
    388

    Re: WPD Conversion Crash

    Phil:

    Thanks for the reply.

    The converter is installed but we have not yet run repair. Also, the hyperlink points to http://winword/ and therefore is inaccessible. Could you please repost the...
  20. Replies
    3
    Views
    388

    WPD Conversion Crash

    In attempting to open a Word Perfect document (xxxx.wpd), we received the following error:

    "Winword has caused an error in WPFT632.cnv. Winword will now close".

    We are using Word 2000 SR1...
  21. Thread: VBA Events

    by CarolW
    Replies
    5
    Views
    508

    Re: VBA Events

    Thanks again for the reply.

    I tried the suggested code but it does not seem to trap a runtime error 3022. Perhaps I inserted it in the wrong event. Do you have any further suggestions on how I can...
  22. Thread: VBA Events

    by CarolW
    Replies
    5
    Views
    508

    Re: VBA Events

    Charlotte:

    Thanks for the reply.

    I had initially done that but couldn't figure out how to handle the resulting error programatically. I would like to display my own message box. Because I...
  23. Thread: Events ??

    by CarolW
    Replies
    1
    Views
    348

    Events ??

    Please pardon the double post. This question has also been posted in the Access Forum.
    ____________________________________________________________

    I am a real VBA newbie! I am writing a small...
  24. Thread: VBA Events

    by CarolW
    Replies
    5
    Views
    508

    VBA Events

    I am a real VBA newbie! I am writing a small application containing several tables and forms. For one form in particular, I want to prevent the creation of duplicate records. I have coded a dlookup...
  25. Thread: Winmail.dat

    by CarolW
    Replies
    6
    Views
    636

    [SOLVED] Re: Winmail.dat

    We've got you beat in the teaching department by 17 years. We routinely help my husband's 87 year old aunt (who wants to do email and surf the web, of course) from 2500 miles away. She is in NY and...
Results 1 to 25 of 45
Page 1 of 2 1 2