Search results

Sorry, my bad. What I was actually looking to do was to create the OnClick event whislt creating the controls. I've been at it all afternoon and have the CreateEventProc. This should do what I need. Thanks anyway. Red It's simple when you know how!

I am creating about 80 controls on a form using the CreateControl method. Is there a way that I can also create some code for the 'OnClick' event at the same time? Thanks Red

Thanks IgorB, thats not a bad idea. Cheers Red

Hi, I am trying to set the criteria in a query, referencing a control on a form. The control is a combo box and I am trying to use the second column to filter data in the query. EG. Forms!FromName!ComboBox.Column(1) However the query doesn't accept it. I get an error saying: Undefined...

Cheers Neil, That is another way that would work fine. I am going to stick to the way I have done it as it is similar with other forms within the application. I'd still like to know how to change the name of a control though! Cheers anyway Red

Hi Ken, Yeah, you're probably right! I've started to change the names manually. I was just curious on how to do it, in case I ever needed to do it again then I'd have the code. As for why... Without going into to much detail, the reason for the option boxes is for the user to be able to...

Just wanted a little help please. I have about 100 option boxes on a form and I want to be able to change the names of the option box and its label. I want to name them from 1 to 100 sequentially. (i.e. option1, option2 ...). When I create the controls it automatically names them option0...

Hi, In outlook, when you create a new message, you can click on the 'To' button or 'Cc' button which brings up the 'Select Names' dialog box. This obviously gives you the facility to choose multiple email addresses which then populate the relevant fields in the message. Is there a way I can...

Hi, I am just about to set up user level security for my database. Before I do, how do I disable the holding the shift key thing when opening a database to get into the database window? I want to make it so the users can't see the database window or access the backend data. As I will need to...

I think I see what you mean. Create a query to pull out a unique ID from CustID, itemcode & date then link it back to the original table. Thanks neileg. (just wish Access had an easier way!

Hi, I have a table with various customer items, a current price and the date the price changed. EXAMPLE DATA CustID/ItemCode/DateChanged/Value AAA 21 01/01/2004 £3.00 AAA 21 01/06/2005 £5.00 AAA 21 01/03/2005 £4.00 AAA 22 01/01/2005 £6.00 AAA 22 01/06/2005 £7.00 BBB 25 01/01/2005 £8.00...

Thanks for tip Jon. I've also been messing around with generating queries by forms, using SQL. It looks like it will take a bit to get my head around it but it should do all tha I need. Thanks again. Red

I am trying to create a query to be used by a report where the criteria are based on certain controls in a form. EG ‘forms![FormName]![Control]’ As the fields are date fields, I am using 2 controls in the form and the ‘Between’ operator to choose a ‘From’ and ‘To’ date to search. EG...

I would be very grateful if someone could help me out. I am trying to write a procedure in Access 2000 that will open a MSWord doc (which I've already figured out.), search for a string, then once the string has been found, print the current page. (Also, I'd like to do the same for a pdf doc...