Replies

I don’t know, something is wrong. I did a File | Save As, and the new object didn’t show until I closed/re-opened (or compact/repaired). And like I said, this just started happening.

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

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.

You are right I have it backwards. How would the code change by changing focus? I am still learning how to code in Access.

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 = MsgBox(“Is this value correct?”, vbYesNo)
If response = vbYes Then
Me.SomeOtherControl.SetFocus
Me.Days.Enabled = False
Else
Me.Days.Enabled = True
End If
End Sub

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 normalisation by doing what you propose.

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 a reset to True.

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 they changed it. Never mind that it didn’t particularly add functionality or that it alienates existing users and developers.

OK, done with my rant.

Glad it isn’t just me then! I really think that MS lost the plot with the Access 2007 interface and some of the new features
Think multi-valued fields for one! )

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.