Search results

I wan't access to automatically size the column widths in a list box. Is this possible or would I have to set each width in the 'Column Widths' property?

If me.Control IS Between Value and Value Just a quick one. I need to check if control's value is between 10 and 20. How do I do this? If me.Control IS Between Value and Value

Yeah, conditional formatting works fine but I need to do this in VBA.

Report: Changing the colour of a control depending on its value. Hi, I have a report based on a query. I want to change the colour of the controls background depending on its value. Here is a sample of the query: Venue - Rejected London - 1.00 Glasgow - 1.50 Bristol - 2.10 Anything above...

Hi guys. Just wondering if it's possible to hide certain fields in a report with VB. Here's a screen grab of the report: The date fields and the 'AppsTaken' fields are duplicated. For Christine Davies, '28/02/2004' and '12apps' is listed 3 times whereas it only needs to be listed once. Is...

Perfect, thanks dcx. :cool:

Thanks mate, I think I've sorted it. :)

Hi guys, I have 4 text boxes that are used to input a bank account number. I have set the text boxes with an input mask of 0000 which stops the user from entering more than four numbers in each box. I want to automatically set focus to the next box when the user has typed in 4 characters. I'm...

Thanks dcx, that's a much better way of doing it!

Hi, I've been looking though the search and can't seem to find anything. I have fields on my form that must be filled before the user can add a record. If the user tries to add a record, and the required fields are not filled, they will get a popup message box for each missed field. What would...

GOT IT!! Managed to find it Thanks for the help.

I'm clicking on the tab in design view and only brings up the page property. How do I get the tab control property? For the page property (in format) I have: Caption Picture Picture type Page index Visible Left Top Width Height None of which have an option 'none' :confused:

What? In the propery sheet of the form? Where exactly is it? Cheers

Hi, I was just wondering if there was a way to stop a user from clicking the tabs in my form to switch pages. I want them to use a 'Next' and 'Back' button instead. This is because each page needs to be validated before the user can continue to the next one.

Bump

Thanks Dcx, I managed to get this to work. can I get this new UNION query to return an extra field which will show the table each record is comming from. Example: qryUnion_AllTalbles ID - SalesExec - Venue - Age1 - Age2 - AppDate - Table ===================================== 1 - John Doe -...

Hi folks, happy Friday 13th. :( :) I'm hoping you can help me build a query that will return data from several identical tables. I have six tables each containing the following fields: I use the following query to pull data from one of the tables: This query returns the following results...

Great, thanks guys. Got this sorted with your help. :)

Hello, I want to create a search tool in Access that will build dyanmic querys for a SQL backend. I am currenly reading the MSKB 210242 - Query By Form, however, the article is specific to MDB databases and not ADP Access Projects. Any other thoughts or resources would be much appreciated. Thanks

Morning all, happy Chinese New Year, Here's my table: tblMain A - B 1 - 0 1 - 1 0 - 1 0 - 0 If there is a 1 in either field I want a query to return 1 in field C. If a 0 in both fields then it should return 0. Is this simple enough? qryMain A - B - C 1 - 0 - 1 1 - 1 - 1 0 - 1 - 1 0 - 0 - 0