V
vennardk
Hello,
I am trying to update a database from access 97 to 07. For a novice,
it is quite a challenge. I am using the Northwind 2007 example to
help me fit all my pieces together. However, I have come to a stand
still...
I do not fully understand what a Control Source is. I have found that
it is typically the exact same as the Name of the combo box or what
not. This does not make a lot of sense to me.
Also, I am having problems with my record source for a specific Form.
Mine currently looks like:
SELECT Orders.*, [Orders Status].[Status Name], [Customers Extended].
[E-mail Address] FROM [Customers Extended] INNER JOIN ([Orders Status]
INNER JOIN Orders ON [Orders Status].[Status ID]=Orders.[Status ID])
ON [Customers Extended].ID=Orders.[Customer ID];
However it asks me to enter a parameter for [Customers Extended].[E-
mail Address] and then again for [Customers Extended].ID. If I just
click OK through both of those, it gives me a "Run-Time Error '2105':
You cant go tot he specified record"
Why is it asking me to enter a parameter?
Any info you can give a learning student of Access would be great! My
biggest problem is I am not sure what a Control Source or Record
Source is. Can soemone help spell it out? Thank you so much!
I am trying to update a database from access 97 to 07. For a novice,
it is quite a challenge. I am using the Northwind 2007 example to
help me fit all my pieces together. However, I have come to a stand
still...
I do not fully understand what a Control Source is. I have found that
it is typically the exact same as the Name of the combo box or what
not. This does not make a lot of sense to me.
Also, I am having problems with my record source for a specific Form.
Mine currently looks like:
SELECT Orders.*, [Orders Status].[Status Name], [Customers Extended].
[E-mail Address] FROM [Customers Extended] INNER JOIN ([Orders Status]
INNER JOIN Orders ON [Orders Status].[Status ID]=Orders.[Status ID])
ON [Customers Extended].ID=Orders.[Customer ID];
However it asks me to enter a parameter for [Customers Extended].[E-
mail Address] and then again for [Customers Extended].ID. If I just
click OK through both of those, it gives me a "Run-Time Error '2105':
You cant go tot he specified record"
Why is it asking me to enter a parameter?
Any info you can give a learning student of Access would be great! My
biggest problem is I am not sure what a Control Source or Record
Source is. Can soemone help spell it out? Thank you so much!