Using list box field for later use
- From: ahearn <ahearn@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 27 Jun 2005 08:56:05 -0700
I am new to Access and hopefully the answer to my question could be very
simple. Bascially, our clinic has a software program that creates aging files
in .dbf format. For example, Jun0.dbf, Jun30.dbf, Jun60.dbf, Jun90.dbf and
Jun120.dbf, that I import into Access, create one table using a union query
and then do further reports and queries using other tables. What I want to do
is create a form that prompts for the abbreviated month to use, I thought a
list box would work. Once the month is selected, I then want to concantanate
the abbreviation of the month with the aging periods, Month0,Month30, etc and
then run a macro to import the month selected. My question is how do I use
the field selected and concantanate it with the numbers for the aging periods?
.
- Follow-Ups:
- RE: Using list box field for later use
- From: KARL DEWEY
- RE: Using list box field for later use
- Prev by Date: Duplicate values
- Next by Date: Re: Combo box based on union query always selects first item
- Previous by thread: Duplicate values
- Next by thread: RE: Using list box field for later use
- Index(es):
Relevant Pages
|
