Search results

the database i am producing will be constantly updated - but a 2nd terminal in a warehouse needs the info in the database for their work - they wont be allowed to modify the data just read what is says - how can this data be updated with two copies opened at the same time??

sorry to be an arse jim, but i took your advice and got rid of the docmd.findrecord statement and tried your filter, but the error window comes up saying that i have cancelled the previous operation, and hilites this in the code window. Me.Filter = "[product_code] = """ & Me.txtsearch & """"...

hey, got the gotocontrol bit down, and it moves to the control 'product code', but its not displaying the record i want it to (specified in the search box). Any more suggestions??

thanks

In the database i am developing, i need a combo box to bring up a specific image file, depending on which value is selected in the combo box. Is this possible??? :confused: Im stumped!:confused:

u r a very understanding patient star of a man. i thank u!!:D

got the query bit down, but where does the iif statement go?:confused:

thanks again col but it doesnt matter if the results change in the table, coz the report is goin to display those items which are out of stock at a partiular time (whenever updated)

well, i thought it did anyway, sorry! couldnt find OnCurrent so i used Current (same i thought) but the table only updates when you move to the next page, and i need it to update straightaway. Also, with using the labels im not getting an entry into the original table, which i need so i can...

hey again, im tryin to create a search facility which will bring up a particular field in my database (very simple, i know) but i can only get it to go to a record if i specify the record no in the code. I cant get the expression to add to findrecord command. This is the command line...

ta much, works a treat!

sorry, i am an idiot, OnCurent? is this an event property coz its not on the list. ta for the help tho!

Hey, This probably sounds really stupid but im tryin to get a line of text into a text box once a condition has been met, but so far to no avail! this is the code im using: Private Sub Status_GotFocus() If Val(Min_stock > Act_stock) Then Status.Text = "Urgent - Below Minimum Stock"...