Search:

Are you opening the reports in Report Preview as opposed to Print Preview? VBA code does not run in Report Preview.

Make sure that the database is in a Trusted Location.

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

What Sevice Packs (if any) do you have installed for A2K3?

This post explains.

you need to make sure that your DB is in a Trusted Location otherwise all code is disabled.

Me.Done = True should check the checkbox.

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 =...

You probably need to move the focus away from the textbox before you disable it (assuming Days is a textbox).

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...

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...

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...

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).

Is the RentPaidDate a Date/Time field?

Change the datatype from Long Integer to Single or Double.

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...

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...

... 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...

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).

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

...

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...

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...

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

Possibly the security settings are disabling your VBA code - what version of Access is this?

What does me. stand for?

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

Armstrong

Me refers to the form in which you are writing your code.

Hi Hans, would you clarify this for me.
I would have thought all he required was 3 tables, Risks, Customers and CustomerRisks, viz:

Risks (lookup table)
RiskID
RiskDescription
.
.
Customers...