How do I limit the contents of one combo box based on the selection in another? i know how to do this in access, but now i'm working with a *.adp file and sql server an the old syntax is not working anymore.
before it was something like this: "where productID= forms!myform!mycontrol"...
How do I limit the contents of one combo box based on the selection in another? i know how to do this in access, but now i'm working with a *.adp file and sql server an the old syntax is not working anymore.
before it was something like this: "where productID= forms!myform!mycontrol"...
is it possible to do so, with only a temporarely query?
so only as a object in the memory and not in the actual query list in access? I don't want to make a mess with a lot of queries I never use again.
thanks!
thanks a lot for the initiative! The Table names are mosly in Dutch, so I don't think it makes sence for you;-). However, you Can look at the structure and possible solutions.
SQL:
******************************8
SELECT TblOffertes.OfferteID, TblBedrijven.Bedrijfnaam...
last time unfortunely no response. hopefully now better.
thanks a lot!
Hello everybody.
I'm am using VBA now for a little while and I'm trying to automate some tasks in word using data from a access database.
I have the following problem:
I use VBA to open a ODBC connection to the database...
Hello everybody.
I'm am using VBA now for a little while and I'm trying to automate some tasks in word using data from a access database.
I have the following problem:
I use VBA to open a ODBC connection to the database. Later on I will use this connection to get the data I need for a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.