Recent content by monika_V

Wow, great ideas :) Many thanks, I've got something I can work with and use for the future.

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

Thanks guys, plenty of options to explore :):):)

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

many thanks for your help guys :) I think I have something usable now

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

What I'm trying to do is extremely simple. All I need, is to remove rows where are duplicates in the DATA column. So in the results I get, I need to remove the marked rows as these are the ones which contain duplicate data S1 and a4b7c3d4 |---------------------------| |cnPart |DATA...

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