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

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

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

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