Using list box field for later use

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Concatenate the date from the ListBox like --
[Forms]![YourFormName]![YourListBoxID] & ".dbf"
 
Thanks Karl, but I guess a more basic question is where do I put this
instruction?

KARL DEWEY said:
Concatenate the date from the ListBox like --
[Forms]![YourFormName]![YourListBoxID] & ".dbf"

ahearn said:
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?
Click to expand...
Click to expand...
 
You said you were using a macro to import. Put it in your command line for
importing.

ahearn said:
Thanks Karl, but I guess a more basic question is where do I put this
instruction?

KARL DEWEY said:
Concatenate the date from the ListBox like --
[Forms]![YourFormName]![YourListBoxID] & ".dbf"

ahearn said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top