Search results for query: *

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

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!?

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

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

A database that was fine last week now has been throwing up all sorts of problems. One of them in when going to enter into the form (it doesn't matter what field it is) an error message comes up: Field can't be updated When you click Help it says: The field can't be updated because another...

I have various command buttons in order to mail various reports which until a couple of days ago were working perfectly. (Using Acc '97) Now I get varying errors. One of them says: ”This recordset is not updateable.” Another two say: ”Training Database can’t find the name “Enter Month Range...

This should be so simple, but it’s completely baffled me. Hope this doesn't confuse you - it's a bit detailed. On my report I have a list of Staff, Courses etc and whether they Attended, Cancelled or DNAd (Did Not Attend) –fieldname = “AttendanceID”. At the end of each section, (broken down...

I have a report that when opened by a command button code works fine, but when I try using a macro to run it the following error message appears: Run-time error ‘3061’. Too few parameters. Expected 1. The reason I wish to use a macro is I wanted to display a message box that said “No Records...

I have a problem with a database I wrote that sits on the network and can be accessed by more than one user. I’ve set “Edited Record” record locking and it’s in Acc ’97. When I try running a macro, I get the error message: “The Microsoft Jet database engine stopped the process because you...