Search results

Hi, I sussed it in the end...basically, I was using a DLookUp in one of the fields in the form...table didn't like it for some reason or other...well, I've hit the deadline and the front end is going out to the users now...thanks for all of your help on this!

Paul, thanks for your input on this...I'm just about there now. I solved the problem with the form that didn't allow me to input data...I think this was because it had a query for a control source...anyway, the problem went away when I changed the query to a make table query and used this as a...

Well, I've managed to split the database...I've created a new form and table in the front end which the user inputs there budget code in to pull out their numbers, etc...it all seems to be working OK, except... It won't let me input data into a form, I'm not sure if this is related to the...

...am I correct in assuming then that there is no way to edit what appears in the Enter Parameter Value box then?

Thanks Paul, saved me the cost of a book...deadlines a bit tight but I can give it go! Cheers

Thanks for your quick resonse! I'm afraid to say that this is the first time that I've heard that this is possible! Is it easy to explain how to do this...otherwise, I'm off to buy a book...

Does anyone know if it's possible to edit the contents of the "Enter Parameter Value" Box...for starters, I'd like to delete the phrase "Please Enter Parameter Value" as it means nothing to most users of Access; also, I'd like to format the text that I've entered in the query itself, i.e. make...

I've since discovered that altough the report now opens at 100% from the switchboard if the report spans 2 pages it does not allow you to view the 2nd page...if you click on "the page turner" at the bottom of the page it just zooms in on the 1st page...urghh..back to the drawing board!!!

Thanks Neil, this seems to partly do the trick; the only down side is it asks for the checkbox to be ticked prior to the record being opened but it does mean that the user does have to tick the box to say they are about to review the record which is ultimately what I was trying to do.

The intention is that only the users will review the records, so anyone scrolling through will in effect be reviewing the records and will need to tick the review completed checkbox. In theory, once the checkbox has been ticked it should not be able to be unticked but I'm not sure if this is...

Hi Neil, thanks for your quick response. I want some people to review some data in a table. If they're happy with it, I want them to tick a checkbox to confirm that they have reviewed it. This means that some users will not amend any fields in the table except for the checkbox. However, the...

I still can't get this right...the checkbox is bound and the MsgBox does prompt the user to tick the review completed box; however, the problem is, The prompt only appears if an amendment has been made to the form and the user then attempts to move onto the next record or Exit. The prompt does...

The control source is linked to a field in a table though; is that not sufficient to bind it? Also, I redid my checkbox per help which stated that you should drag your field onto the form (not click) after clicking on the checkbox button on the toolbar.

Thanks, this is great I've even manage to tweak it a bit to dumb it down even further for my IT illiterate users...I'm learning!! If Me.Review_Completed <> True Then If MsgBox("Please tick the Review Completed Box before proceeding to your next asset", vbOKOnly) Then Cancel = True...

Apologies as I've already asked this question in the forms section of the forum but the responses were a bit on the light side...I'm now getting desperate having spent much of the day trying other sources such as google (even the advanced searches as advised in a different thread)...somebody...

I agree with your sentiments, I've got some users who aren't that IT literate and was attempting to make it 100% foolproof...hopefully, they should be able to work out to click the close button.

Sorry Col, I'm a beginner...can you tell me how to do this? I can see a defaultvalue in properties of the checkbox, do I have to plug something in here? Thanks

I'm sure this has already been covered somewhere on this form...how do you make a user tick a checkbox before proceeding to the next record on the form. Thanks

For some reason, it already returns to switchboard on close...not sure why now, as I haven't added anything to the Report poperties...might this not happen then in certain circumstances!?! One thing I did do though was in the properties of the switchboard added a Restore Macro which ensures...

Thanks that's done the trick. By the way, do you know if it's possible to put a command button on your report so users can return back to the switchboard.