Prev: Subdatasheet records not updating totals
Next: Crystal Reports 2008
From: JMD.Park on 24 Mar 2010 10:59

SELECT *
FROM [TRIP TICKETS ISSUED TO];

"John W. Vinson" wrote:

> On Fri, 19 Mar 2010 13:57:02 -0700, JMD.Park
> <JMDPark(a)discussions.microsoft.com> wrote:
>
> >Where do I find the record source and sql?
>
> Open the form in design view.
> View its Properties (rightclick the little square at the upper left
> intersection of the rulers and choose Properties, or use the View menu
> option).
> The Recordsource is the first row on the Data tab.
> Click the ... icon by it; if Access asks if you want to open a query, do so.
> Select View... SQL from the menu, or choose SQL from the leftmost dropdown in
> the toolbar.
> Copy and paste the SQL to a message here.
>
> Did you try my suggestion? (you certainly didn't answer my questions).
> --
>
> John W. Vinson [MVP]
> .
>
From: John W. Vinson on 24 Mar 2010 11:40
On Fri, 12 Mar 2010 08:51:02 -0800, JMD.Park
<JMDPark(a)discussions.microsoft.com> wrote:

>I would like to create a look up for a field in a form. I would like to put
>in a customer number that will bring up their name and address info. How can
>I do this? Thanks in advance for your assistance.

A "Look Up" *IS* usually a combo box. (It doesn't have to be but that's most
convenient).

Use the Toolbox Wizard to put a combo box on your form. Choose the option "Use
this combo to find a record."

--

John W. Vinson [MVP]
From: JMD.Park on 30 Mar 2010 08:39
This is beyond my knowledge of access. Thanks to everyone for their
suggestions. I have located someone from a local college to assist me. So
again, thanks to everyone who tried to help.

"John W. Vinson" wrote:

> On Fri, 19 Mar 2010 13:57:02 -0700, JMD.Park
> <JMDPark(a)discussions.microsoft.com> wrote:
>
> >Where do I find the record source and sql?
>
> Open the form in design view.
> View its Properties (rightclick the little square at the upper left
> intersection of the rulers and choose Properties, or use the View menu
> option).
> The Recordsource is the first row on the Data tab.
> Click the ... icon by it; if Access asks if you want to open a query, do so.
> Select View... SQL from the menu, or choose SQL from the leftmost dropdown in
> the toolbar.
> Copy and paste the SQL to a message here.
>
> Did you try my suggestion? (you certainly didn't answer my questions).
> --
>
> John W. Vinson [MVP]
> .
>
First  |  Prev  | 
Pages: 1 2 3 4
Prev: Subdatasheet records not updating totals
Next: Crystal Reports 2008