Search results

Hi, I'm trying to filter the contents of a listbox dynamically so that as I type, the listbox is filtered with the contents of the textbox. So far, I have a query (Query1): PARAMETERS dbb Text ( 255 ); SELECT Customers.Customer, Customers.ID FROM Customers WHERE (((Customers.Customer) Like...

Hi, Is is possible to scale a sub-report on a form? I know how you can add a sub-report on a form but as soon as is it scaled to fit with the sizing grips, the scroll bars appear and you have to use them to see the report. What I want is a scaled view of the entire sub-report so that you can...

Hello, When you use AllowEdits = False on a form, is there any way of disabling the cursor? It's slightly pedantic, but it is slightly annoying and gives the wrong indication in that it implies the control can still be changed as the cursor is accepted but it's not until you type that you...

Hi, I have a set the Row Source of a combo box to a query which returns three columns - [part], [desc] and [id]. The combo box Control Source is bound to a table column. I only want to see the [part] and [desc] fields so I've set colums to 2 and set the widths to 3cm and 6cm. I've bound to...

I have the following MS Access query: SELECT * FROM (SELECT [cnPart],[desc] as DATA,"desc" as CAT from PartData UNION SELECT [cnPart], [qty], "qty" FROM PartData UNION SELECT [cnPart], [matl],"matl" FROM PartData UNION SELECT [cnPart], [spec],"spec" FROM PartData) AS A WHERE (((A.[cnPart]) In...