Search results

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

OK Guus2005. I thought giving a full explanation would help set the scene. Put simply, I have say three text boxes. Data is entered into these boxes and the values are concatenated and the resulting string is displayed in another text box. How do I force the user to enter data in all three...

I have a main form, which is bound to table MainTable, and a sub form, bound to table SubTable, with a one-to-many relationship. The records in MainTable can be one of two types and there is field ‘Type’ to hold the type. Each type has its own sequential number held in fields ‘One’ and Two’ –...