Recent content by mattbland

couple of questions: ive got a db with two forms both linked to the same table - edits allowed, and no-edits. 1) if the edits form is updated, will the update be shown in the no-edits form? 2) is it possible to insert a refresh that automatically refreshes every 5 or 10 mins (hopefully...

and say, if someone was to untick all the options in the startup menu, how would this peson get the options back?? This is, of course, hypothetical!! Doesnt matter i got it back!

is there a way to stop users from accessing design view of a form? maybe with a password so it can be accessed??

Hey, still no luck. Filters are allowed, tried setting data entry to both yes and no, but still just opens new record. spelling things right or wrong still does the same!! Its wierd cos searching for product code is working fine (numeric). Heres my updated code - Private Sub...

is it possible to stop any edits in certain fields in a specific form without disabling them or making them invisible? i say this because i have a search facility on the same form and want to use it but dont want the information produced amending by people without the proper clearance. I have...

just add docmd.close acform, "FORMNAMEHERE", (then you have a choice to save, just close or have a prompt.) HTH

cant u use the line in the .bat file to open the database, then use the startup function to open a form, and use the forms on open to run the macro? then close the form, automatically? you could resize the form so its really small and near un-noticeable.

nope, its just changed back to goin to a blank record. what does the '!' do anyway?? plus, with the filter, it wont find partial matches. does anybody know how to find partial matches??

hey fizzio, tried it and im getting an error msg sayin i cant assign a value to that object. thanks anyway - any other ideas?

hey, thanks for the help, but still just opens a new record. Any other ideas?? Matt

ive got a combo box and a textbox both unbound for finding a particular field. what i want to happen is select either 'product code' or ingredient name' from the combo box, and then search either of these fields as the filter i am using only searches either a numeric field (product code) or...

hey, If the textbox is bound, go to the corresponding table and look for the input mask bit. click on help and it'll give you all the characters to create what you need. if unbound - click on properties and its on there too. Matt

the combo box property was set to change, so i modified it to afterupdate and still works normally. Ive added your code but it sez that it is an invalid use of property. dont matter i put a dot instead of an understroke! cheers rich

yeh, those 4 records i have put in are just to test the db. there are about 350 extra to put in yet. cheers anyway! ive put a FilterOn = False line in the LostFocus event of the Txtsearch box n that works fine. Thanks!!!:D no, no it doesnt. crap.:(

ive got a selection of images which appear/disappear using the .visible command, which is run from the values in a combo box. When i move from record to record, the values change but the picture doesnt. How can i solve this? ive already had to cut and paste the original code for it into the form...