Search results

I have an update query that creates a reference. part of the update is the following code (Left([clientname],Len([clientname])-(Len([clientname])-3))) Which works fine. What I'm wondering is if there is a way to ignore any spaces that might be in the first three characters. So in other words...

What to do with a mountain pass and a few spare inline skate wheels :eek: More info here

Is there a way of tabbing out of a SubForm once you have finished entering data into it?

I use Firefox as my default browser, yet when I click on a hyper link in a form the link will open in IE rather than Firefox :mad: Is it possible to change this behavior, so that links will open in (a new tab in) the default browser?

I have combined the list box sort function discussed here with the Search tool discussed here. No problems thus far :) I'm using the following piece of code that activates on the OnChange Event of the text box that is feeding the search query. The code ensures that the first row in the list...

I have a form based on a query, I would like to add additional criteria to the query dependant on the status of a check box. Is this possible if so what would the code look like?

I have a form that is opened filtered from a selection in a combo box. The problem is that the selection in the combo box can not be linked directly to the data on the form to be opened. So is it possible to use a query to select the linking information and insert that result into the...

Has anyone had any experience with watermarking images? If so what software are you using? Any tips?

What is the syntax to check if a combo box populated by a query contains data?

I have a form/subform ([FRM_Item] and it's subform [FRM_ItemPrice]) set that are set as no addition no edits as the default view. what additions do I need to make to the following code to get the Subform [FRM_ItemPrice] to open in acFormEdit Mode

I have a select querey which contains the expresion It should just pick up the value contained within [Text8] which is a number, and it was doing that earlier this evening. I've since changed something and instead of a number it is now showing a small square :confused: For the life of me I...

I'm currently setting up a data base in which I want to store price with a Japanese Yen Currency indicator. Is this possible? The Format allows for either Dollars or Euro. I like to use preferably ¥ or JPY as the currency indicator.

I have a continuous form, that displays in the body the results of a number of selections from a previous form. In the header I have a message that I want to either shown or hide depending on the result of the following code in the "On Current” event; The default form Label32 is for it to be...

I have an "On Double Click" code in the second Combo box of a cascading combo box set. The code below works fine on a normal Combo Box, but for some reason the Requery statement doesn’t seem to have any effect in this instance. The data that has been entered into "FRM_DelPoint" does not appear...

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...

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...

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...

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

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"

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...