Recent content by Roo Murray

Hi I used to have a macro that would delete a query (if it existed) and recreate the query with a new set of parameters Does anyone know of a way of doing this in 2007? It seems to error all the time in this version: 'For i = 0 To MyDB.MyQuery.Count - 1 'If MyDB.MyQuery(i).Name Like...

Hi guys, I'm trying to figure out a way of auto populating a table from a few text boxes on a form. The entry form will show: Lot number "12345" Overall qty: "150" Number of Lots "10" What I would like to do is on the press of a button 10 rows to be created with: Lotnumber Qty 12345-1...

Thanks - That works a treat. & yes it is 2007. I would still be interested if there is a way of using the multiple check box in order though? :o

Hi, Within a form I have created I have a combo box that allows for multiple picks/choices. The choices made are then transferred to a text box. All is fine so far :) What I want to happen is the order of the text box is to be based on the order that the choices that have been checked...

I'm looking further into this issue (as I didn't build this one myself) - What they have done with the expessions is call macros rather than code the updating directly. Would this cause the problems?

I think it is a mixture of both - Typing in the combi box then scrolling down to the specific record. I've put event procedures in both _onchange and _Afterupdate but still no luck

I still seem to have to click out of the combo box for the form fields to update though. What I was really after is the fields to update on change of the highlighted record of the combo box.

Hi Is there an event procedure that will update fields within a form without having to tab out (or click out) of the combo box? Thanks Roo (New Joiner!!)