Search results

Thanks, that woorks a treat :D

I have a form that is opened filtered based on the selection of a ComboBox based on the following code. Now I want to futher restrict the data that is shown when the form opens by showing; a) only those records where [DelDate] is null, and b) only those records where [Deldate] is null or...

Got it sorted don't worry. :o

I have a combo box which looks up vessel names, it stores the Vessel ID in a field [Vessel ID]. This all works fine, no problem, easy. However as part of the vessel details I also need to know the service the vessel is providing “transhipment” or “direct”. If it is a “transhipment” service I...

Thanks guys that's got it working :)

No single form view.

I'm sure this question must have been asked before but I can't find it here, so my apologies. I have a form for collecting addresses, it has two combo boxes, the first contains a list of states, and then the second contains a list of postcodes found within that state based up a query with the...

Thanks Sarge. Just figured it out and was going to post a "Yippee, worked it out all by my self message" but you beat me to it :o A good question and one I don't have a good answer for ;)

What is the code to make the "Back colour" of a text box transparent? ie. 16777215 = white

Just what I was looking for, thanks for the pointer :)

Is it possible to use a logical test to show different text in a text box on a report? If so what is the correct syntax? for example; if ETA > date then "Vessel not arrived" else "Vessel arrived"

Too easy; thanks heaps :)

I'm trying to construct a query that will show all fields where the date is greater than today’s date less eight days, and also pick up fields which contain no data. The first part I have achieved with the criteria >Now()-8 But I've been unable to find the correct syntax for picking up fields...

I was trying to avoid doing that. Hence my question ;)

I'm looking for the correct syntax for the condition to open a form for any records where a particular filed is empty.

Thanks just what I was looking for :o

I want to compare a date in the form DD/MM/YYYY with the NOW() statement to see if they are the same however the NOW() statement returns DD/MM/YYYY HH:MM:SS How do I restrict the NOW() statement to return just the date, as I'm not interested in the time.