Recent content by Soton

GetRows can be used to extract a recordset to an Array for processing quickly using code. Is there an equivalent to put the values from an array back into a table using a single one-line statement rather than working through each record and field individually. This can be a pain if there are 20...

Hi. A question regarding the use of Global Variables in a Form. Once the variable has been defined and has a value attached, is there a way to display it in a textbox on the Form other than via code. Each time I put the variable name (eg '=strField') in the Control Source properties of the text...

Thanks vbaInet. Just tried it on a mock-up and it works a treat. Now just need to incorporate process into main database.:)

Sorry if I'm being thick but, in "SELECT * WHERE [ID] Not In (1, 2, 3)", are '1', '2' and '3' the names of the Combo boxes. Would the SQL string be something like "SELECT * FROM tblSourceData WHERE [ID] Not In (1, 2, 3)" with [ID] being the 'list' field.

If the result is sent to a text box on a Form, you can always use the formatting options on the text box. Other destinations also have their own formatting options. It depends what you want to do with the result.

I had looked at that link and it suggests it is for tables with more than one field where each 'selection' works on the next field. I'm not sure I am looking for Cascading ComboBoxes but multiple boxes looking at a list based on a single field. If combo boxes are not the answer, do you have any...

I am trying to create a form with a number of Combo Boxes which look at the same 'single-field' list. The list might contain up to say 20 items and there could be 5 combo boxes. The selection criteria are: If an item is chosen in cbox1 (say Item3), it should not then appear in the list shown...

The folderpicker sounds just what I want - I just need to collect the foldername. Do you know of any links

Have managed to get it working with my database - only had to add a reference. On a similar topic, is there a way to open a dialogue box and save the path to a folder rather than an individual file. For example, you might have different folders for different sets of images or music files and...

Many Thanks. Have had a quick look and it does what I was looking for. Only need to incorporate it into my database now:)

In Excel, I can use code like 'tempstring = Application.GetOpenFilename("(xls),*.xls", , "Open File")' to browse for a filename in any folder and return it to Excel in variable 'tempstring'. I would like to do something similar in Access but cannot find the commands to access the Open-file...

In the Forms 'Pages' control is it possible to have more than one row of text for the tab name. I want to keep the overall width of the form down to suit low resolution screens. I can show more than one row of tabs but I would prefer to word-wrap the tab name so I can keep to one row of tabs...

The report is based on a query with labels/textboxes on the Report positioned (with left and top coordinates) to suit all the entries in the query. If I use the query to select only those with values in the textbox, won't I get an error message when the report opens as some of the fields will be...

I have a form which includes a block of data with a number of label/textbox combinations where the label is the item and the text box is the quantity. When I produce a report based on the Form, I want to hide the label/textbox combination where the textbox is empty (which I can do) but I don't...

I thought of using the Dirty 'trigger' with code to then check each box I am interested in has an entry and possible colour the background of the ones which were still empty. It doesn't seem very elegant but hopefully it should work. Am I using the correct events trigger. The 'on lost focus'...