Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    8
    Views
    1,998

    Thank you for confirming that I am not losing my...

    Thank you for confirming that I am not losing my marbles (yet). I had the same situation in the classroom the other day with File - Save As for an amended query (demonstrating different ways of...
  2. Are you opening the reports in Report Preview as...

    Are you opening the reports in Report Preview as opposed to Print Preview? VBA code does not run in Report Preview.
  3. Replies
    5
    Views
    3,397

    Make sure that the database is in a Trusted...

    Make sure that the database is in a Trusted Location.
  4. Replies
    14
    Views
    828

    Do the offending sub-forms have any calculations...

    Do the offending sub-forms have any calculations or conditional formatting in them?

    What Sevice Packs (if any) do you have installed for A2K3?
  5. Replies
    4
    Views
    949

    This post...

    This post explains.
  6. Replies
    4
    Views
    949

    you need to make sure that your DB is in a...

    you need to make sure that your DB is in a Trusted Location otherwise all code is disabled.
  7. Me.Done = True should check the checkbox.

    Me.Done = True should check the checkbox.
  8. Thread: Locking Fields

    by SteveH
    Replies
    11
    Views
    877

    The Error number is 2164 - You can't disable a...

    The Error number is 2164 - You can't disable a control while it has the focus.

    Your code should look something like:

    Private Sub Days_AfterUpdate()
    Dim response As Integer
    response =...
  9. Thread: Locking Fields

    by SteveH
    Replies
    11
    Views
    877

    You probably need to move the focus away from the...

    You probably need to move the focus away from the textbox before you disable it (assuming Days is a textbox).
  10. If those add on days are always going to be the...

    If those add on days are always going to be the same you should not be storing the values in fields. You should calculate them as and when you need them in queries.

    You are violating the rules of...
  11. Replies
    6
    Views
    775

    I found similar behaviour after I had used an...

    I found similar behaviour after I had used an add-in (IIRC it was Helen Feddema's rename add-in).

    Closing and re-opening Access cured it so I guess it was a DoCmd SetWarnings False not followed by...
  12. Replies
    21
    Views
    1,042

    Do NOT feel this way! Access2007 is a royal...

    Do NOT feel this way! Access2007 is a royal "pane". Stuff you used to be able to do in 2 clicks is now buried. For the most part, it seems Microsoft decided to make changes merely so they could say...
  13. Replies
    4
    Views
    465

    Have you checked Grouping and Sorting and...

    Have you checked Grouping and Sorting and conditional formatting? These odd parameter prompts can hide away there sometimes (though I cannot see why the Access version should make a difference).
  14. Thread: Formula

    by SteveH
    Replies
    7
    Views
    602

    Is the RentPaidDate a Date/Time field?

    Is the RentPaidDate a Date/Time field?
  15. Replies
    4
    Views
    446

    Change the datatype from Long Integer to Single...

    Change the datatype from Long Integer to Single or Double.
  16. Replies
    3
    Views
    352

    I would guess that there is a combo box somewhere...

    I would guess that there is a combo box somewhere in your db which is bound to the name field but is actually using the ID as its value.

    I've seen this on several occasions in my student's...
  17. Replies
    10
    Views
    485

    Problem solved. I remembered that I have had this...

    Problem solved. I remembered that I have had this kind of flaky behaviour before and it sometimes arises when the computer has been on for a long time and I have been doing lots of programming, both...
  18. Replies
    31
    Views
    1,823

    ... reinstalled IE7 with the result that I was...

    ... reinstalled IE7 with the result that I was immediately able to pin the icon to the Start menu & log on to the net using it, so problem solved. Thanks for the replies anyway. All I need to do now...
  19. Replies
    31
    Views
    1,823

    I use Firefox 3.0.11 (the latest one) and the...

    I use Firefox 3.0.11 (the latest one) and the Video DownloadHelper add-in. It works like a charm for me.

    (The screenprint about 4 posts back shows it second from the top).
  20. Replies
    4
    Views
    1,501

    Me.FirstName = StrConv(Me.txtFirstName,...

    Me.FirstName = StrConv(Me.txtFirstName, vbUpperCase)
  21. Replies
    20
    Views
    909

    ... I will now try to implement the same thing...

    ...

    I will now try to implement the same thing on frmGroups -- so it shows the names of people in the group that is shown on the current form. This one has a new wrinkle: the names are in...
  22. Replies
    3
    Views
    450

    If you use . when typing code you will get the...

    If you use . when typing code you will get the Intellisense - this will save you from mispelling a control name. It also means that if you rename a control on the form, the code will not compile...
  23. Replies
    8
    Views
    575

    Oh, and two very useful posts by SteveH: ...

    Oh, and two very useful posts by SteveH:

    Tips'n'Tricks
    Normalization

    Hans, I am honoured - thank you for the plug http://windowssecrets.com/forums/images/smilies/biggrin.gif
  24. Replies
    26
    Views
    1,261

    Possibly the security settings are disabling your...

    Possibly the security settings are disabling your VBA code - what version of Access is this?
  25. Replies
    18
    Views
    1,025

    What does me. stand for? Me.OrderBy =...

    What does me. stand for?

    Me.OrderBy = "LastName"
    Me.OrderByOn = True

    Armstrong

    Me refers to the form in which you are writing your code.
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4