Search results

thanks.. didnt think it would be something that minor!

is it possible to change the cursor depending on a users actions? i want the cursor to change when a user hovers over a label - as it would do if it was a hyperlink? any help appreciated

give this a whirl, just add on to the end of your current code for cmdsave Set rs = db.OpenRecordset("TBLEleSesTrk", dbOpenTable) With rs .AddNew .Fields("UserID") = vbasuid .Fields("PackRef") = vbpackref .Update End With rs.Close Set rs = Nothing

ive had a look in help and it says that dlookup returns a value to the form.. i just want it to check the value in my textbox (ShipNo) against the value in the query (BDPE_LOV_Data) and the field (ROUTE_ID) i tried putting this into the control of the text box ...

is it possible to check a value entered in a text box to see if it exists in a specific table? all help appreciated..

is there a way to pre load all the records even before you start playing with the combo box? my users are quite impatient people! :) i dont want the user to be waiting for all the records to load in the combo box but for the combobox to be ready to be selected.

thats perfect mate. thanks alot

anyone know how to do a count of the records in a combo box. need the count in a field on the form. not in a query.

i need to populate a combobox on form load as it holds a lot of records. the problem is that when the user clicks the combobox to select a record it takes too long to populate the combo with values. any help appreciated..

Is there a command button that can be created to filter by form? i had a look in the wizard but its not there.. or even the vba code would be useful thanks

is it possible to some lock fields in a table. this is going to be a simple datasheet which users can enter values in some fields but some are already populated and need to be locked... any help is appreciated..

This might be a stupid question.. but how do i do that?

structure: Form and sub form - need to include firlds from both the form and subform in the save. Have a tabe which includes all the fields i want to save and are coded to save. .Fields("Country") = Me.txtCountry .Fields("Shipment #") = Me.cboShip .Fields("PBL") =...

I need to have it masked for validation... i have created an input mask on a field which is formatted as general date. on form load the date and time is shown ( Now() ) The mask i have used is 99/99/00\ 09:00:00 it works in that it lets me enter a date and time but it always gives an error...

dont explode when

i have created an input mask on a field which is formatted as general date. on form load the date and time is shown ( Now() ) The mask i have used is 99/99/00\ 09:00:00 it works in that it lets me enter a date and time but it always gives an error. even if the value is a valid date and time...

does anyone know the correct code for an input mask for the general date. i.e. 10/08/04 11:54:45 (dd/mm/yy HH:MM:SS)

thanks to both of you! much appreciated guys

(making link active again)

i have a query linked to a selection box on a form, which selects specific records and shows them ona subform. is there anyway to show all the records first and then let the user narrow this down thorugh the combo boX?