Search results for query: *

Fantastic - thank you so much!! Really don't know why I didn't think of that before.

Sorry - please ignore that. Realised I'd input my DateDiff wrong. Just going to try it again.

Thanks for replying. I tried DateDiff earlier on and got the same error message about it not being a recognised built-in function etc. :(

Hi I'm hoping this is the right forum as I couldn't find anything else that I should perhaps post under. I'm using MS Query, to query an external database and return data into Excel. I know Access and Excel, but not much SQL and and very new to MS Query. I need to convert the Date/Time...

Having done a copy and adding heaps of records each time entering something different, I get the same error on any number of different fields, therefore, I'm not sure if it's worth trying the default option. It's very confusing!!! %-) On one particular field, I kept getting "You cannot add or...

Thank you and sorry for delay - the site was temporarily blocked at work. Yes - it does mean that the error doesn't occur in this mode. There doesn't seem to be any pattern to the error - only that it happens on this field, (the DocNurse grade combo) or when you try to close, or when you...

I've tried debugging with the STOP command and it doesn't flag up anything. It steps through the code and then stops at End Sub and bleeps.

Thank you both for replying. PHV: No there's no event for the combo, just Me.Refresh. I've just realized that it's not just this field. It's something on the form perhaps. I was entering some test data for something else, and entered Follow-up in the ReferralSourceID field. This means that...

Thank you. ReferralID is the field before the doctor/nurse grade combo that is causing the error. Private Sub ReferralID_AfterUpdate() Select Case ReferralID Case 1 PAROnRef.Enabled = False PAROnRef.Value = -1 DocNurseGrdID.Enabled = False...

Thanks. I looked at the FAQ you mentioned and am sorry if I've come across in any way that's not correct! There's no debug option, so no line of code highlighted. Unfortunately, the only option is OK, not even Help! I've tried debugging but that didn't come up with anything. There's only...

Hi - thank you for replying. The combo box is configured to display the Doctor/Nurse Grade, with the ID hidden (column width zero). SELECT tblDocNurseGrdMF.DocNurseGrdID, tblDocNurseGrdMF.DocNurseGrd FROM tblDocNurseGrdMF; DocNurseGrdID DocNurseGrd tblDocNurseGrdMF is DocNurseGrdID =...

Sorry - forgot to say, that once you click OK on the error message, it lets you move on.

Hi. I've got a combo box which when you choose from the list, gives the message above. I've made the default value Null, tried deleting the combo box and re-entering it, saving the record and have checked the relationships which appear to be fine. Does anyone have any ideas please!?

That's excellent, works fine. Thank you very much for your patience and time.

Sorry I haven't made this very clear. MachineStatusID is the Control Source of the option group where the value of 2 = On Loan. Because I didn't want the user to have even the option of changing that value on this form (as it's done when the machine is allocated to a patient in the...

It's a continuous form, therefore all records are on one page, displaying the status of machines, ie: ID Type ... ... Status (Option Group) 123 ... ... ... . Free / Gone for Repair / Retired Out on loan is not an option, but I have another text box next to the option group, which...

I have an option group on a continuous form, where if the value = 2 already (on loan), I want it to either give a message saying that the machine is out on loan and cannot be edited via this form, OR to completely disable the option group for that machine. The way I've done it so far is...

I have changed the defaults of the lookup fields to Null rather than 0 and this has sorted the problem. Thank you for your comments. Ally

There are relationships between all the relevant tables. What happens is, if I come out of the field that I'm trying to enter, make an entry in the Electrode field and go back to the original field I was trying to enter, then the same error message comes up but with reference to another table...

Up until now I've only used Referential Integrity with tables that store such things as patient / staff information fed from subforms. After a course and reading stuff on the forum I've added it to every table, but this is causing me problems and think perhaps I don't need it here, but when I...