Here we go:
Imagine three tables, called A, B and C respectively.
Each table has the same fields: ID [autonumber], Field1, Field2 and Field3.
If I wanted to move information out of one table and into another, then again into another, then possibly back to any one of the three, I would like to...
I'm playing with Access (relatively new to it so bear with me) and I have a form with a "New record" button on it.
What I'd like is to include a command button to save the newly input information typed into the form fields and close the form, all at the same time.
I can set up the...
I can do this in Visual Basic but on an Access form it has me flumoxed. (Why is VBA so completely different to VB in so many regards ?)
What I have is a common dialog that allows me to select a file and copy its filepath to a textbox on a subform. That part works just fine.
After the above...
I’d like some help with an SQL query from an Access database to an Excel named range.
The scenario is this:
On an Access form that displays the usual suspects of customer information from a table called Clients;
ClientID
Name
Surname
Company Name
Client type – selected from 3 possibilities in...
I’d like some help with an SQL query from an Access database to an Excel named range.
The scenario is this:
On an Access form that displays customer information from a table called Clients;
ClientID
Name
Surname
Company Name
Client type – selected from 3 possibilities in a drop down menu...
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.