Many thanks for the qick reply.
I can see how this works now. I need to improve my sql especially when it comes to nesting select.
Guy Moseley
Last Activity: Feb 14 '08, 03:19 PM
Joined: Jun 8 '07
Location:
-
Remove a value from a Combo box once the value has been selected
Hi
I am trying to remove a value from a Combo box once the value has been selected
I have a form with a combo box that uses the following sql for the row source
Once the user selects the employee in the combo box they click a button and the EmpNo is added to the TransTable along with other Fields on...Code:SELECT EmpTable.EmpNo, EmpTable.Surname, EmpTable.Forename FROM EmpTable ORDER BY EmpTable.Surname;
-
Hi
Have a look at the following:
http://www.fontstuff.c om/access/acctut17.htm
Alternatively this is the short version
First create a query, Access doesn't let you create an "empty" query so you'll have to make something up (anything will do).
Now create a dialogue Form to collect the variable in this case the value of "n".
You can add to this form command button which will...Leave a comment:
-
Sorry for the delay getting back to you but my PC died!!!
Many thanks for the super quick reply.
I tried it but couldn’t get it to work however it did point me in the right direction and I used CurrentDB and that worked
Many thanks againLeave a comment:
-
Table dose not exist
Hi all,
Could someone please point me in the right direction!
I am in the process of creating an Ms Access db and as part of this use VBA in a form to create a table based on the input to the form.
The VBA is run as a result of clicking a button, creates the table and then opens a new form with a sub form based on the new table.
However this bit dose not work and you get the message "Table...
No activity results to display
Leave a comment: