Re: Using Variable in Where Clause
- From: "Mike Painter" <mddotpainter@xxxxxxxxxxxxx>
- Date: Tue, 05 Apr 2005 01:49:28 GMT
GeorgieGirl wrote:
> Mke,
> Thanks for the answer even though it was not the one I was hoping for
> (but kind of expected). The reason I am using different forms is
> that my application has three distinct parts, but all have a common
> dependency on the "FacilityTable". My forms, therefore. all have
> parts of the "Facility Table" with subforms that are totally
> independent of one another.
>
> I guess it is time to learn VBA. I have coded in my past life, but
> not in any type of basic. Can you suggest a good book or online
> class to learn VBA? I would sure appreciate it.
>
Most Access books will have a lot of code in them. The Developers handbook
by Getz and Litwin is a must have in my estimation.
Make sure you understand the event model and that most of the time you will
be writing very few lines of code in any one function.
Northwind has many examples of forms subform combinations.
I would still look at a tabbed form with the subforms on each page but the
code for opening and passing arguments is basically a one liner.
.
- References:
- Using Variable in Where Clause
- From: GeorgieGirl
- Re: Using Variable in Where Clause
- From: Mike Painter
- Re: Using Variable in Where Clause
- From: GeorgieGirl
- Using Variable in Where Clause
- Prev by Date: Re: form data based on criteria entered in another form
- Next by Date: a lazy Insert Object command
- Previous by thread: Re: Using Variable in Where Clause
- Next by thread: save data unbound text box
- Index(es):
Relevant Pages
|
