Search results

Help please, im using this code Private Sub Target_Combo_AfterUpdate() Select Case Target_Combo Case "Emergency" Me.TARGET_COMPLETION_DATE = Me.ISSUE_DATE Case "3 Days" Me.TARGET_COMPLETION_DATE = DateAdd("d", 3, Me.ISSUE_DATE) Case "3 Weeks"...

Anyone know of way to add a wild card entry to this so that it will display records when only a part of the date is entered i.e. looking for Access World Forums but only typed access

Help Please Hi, Im having a little problem with the following code in one of my queries Expr1: IIf(IsNull([Forms]![editLookForm]![Company_Name]),True,[Company Name]=[Forms]![editLookForm]![Company_Name]) What this does is, it take an typed entry from the form (editlookform) and seaches for...

Hi, im new to access go easy please, Ive got a works orders database that requires some tweeks, This database records faults & locations and the target completion time for the job Just now the operator fills in the fault and location and the issue date appears automatically as todays date...

Hi, im new to access go easy please, Ive got a works orders database that requires some tweeks, This database records faults & locations and the target completion time for the job Just now the operator fills in the fault and location and the issue date appears automatically as todays date...

I have an update query that looks for a name eg "first" then it is suppost to update a field with 1 I have a command button that runs the query This then says "you are about to update 1 row(s) so i press yes, but the field doesn't update But if i flick through the database and then come back...

Thanks That works great, on a form This is to go into a orders database so that on each order i can select one day two days one week and so on and then print of the order with the issued date and a target completion date, as far as i can see the way it works just now is only for show in...

Thanks But?? Ive tried your suggestions with no luck so i have attached a stripped down version of what im trying to do, So in the form when i select one day the days box i want the snd_date to populate with tommorows date Thanks again Andrew

undefined :mad: Hi im new here Ive got a db that im having problems with (Access 97) i got a date field (date1) - which is automatically todays date ive got a combo box (option) as below - it displays the name - :- name days one 1 two 2 three 3 and another...