I have a Listbox that I need to fill based on two tables.
Table1
PaymentID    Number
PaymentName    Text

i'm just the beginner of MS Access.
could anyone teach me how to concatenate some value from the particular
column of some records(in the table) into one string?
so far, i know only select some records from the table

I have a question about the .isLoaded flag and subForms.
In A2K I have a Form, let's call it frm_MainForm which contains a child
form, which we'll call frm_ChildForm.
If I open frm_MainForm then the child form also opens. Of course it does, I

Hi Group,
Could someone advise me if the following is possible.
I have designed a mini reporting system to record queries/sql that I
run on a database.  I have done this as I am asked to run numerous

I am inputing the following code and it doesn't seem to be working, it
shows up #Error?
Private Sub txttotal_BeforeUpdate(Cancel As Integer)
If cboyeargroup = "Under 18" Then

I am getting the following message up
You tried to runa Visual Basic Proceedure to set a property or method
for an object, however, the component doesn't make the property or
method available for automation operations.

Hello! First and foremost, I have searched and read extensively. ;-)
I have also been playing with this for about four hours.
I have four (near) identical forms. I have four (near) identical
queries.

I have a database based upon the "Issues" template from the Microsft website
and want to create a report that will display statistical information such as
"How many opened issues", "How many Closed Issues", "How many issue each
calendar month" etc.

I have a form that displays the Companies that I deal with. I use a combo
box and an unbound text box as my search tools to filter the data related to
the Companies.  My problem is that when I enter the search criteria for Labor
Type (there are three choices = Union, Non-Union, ...

Next ctlHi,
I need to write a control array that will loop through the textbox controls
on my form that have an index from 0 to 23 and set the value to "" or null.
The reason I need to refer to their tab index is that I cannot clear all of

I have two listboxes.
One listbox populates the 2nd listbox.
What I am trying to do is to populate the values in the 2nd listbox to
append the values in the listbox, and also another value in a text box as a

Hello!  I'm trying to update the records displayed in the main form by 1
field in each of 2 subforms.  I have used Allen Brownes inner join technique
(thanks Allen!)successfully for each subform separately, but I can't figure
out the code to integrate the 2 searches.  e.g.  The ...

I need to modify the below syntax to work with SubForms:
I need the same as below - except for .Parent it would be?? I cannot find in
help what i'd expect. I am thinking it would be .child or subform or
something like that...

I have two fields the first one holds the number of the month.
Such as 01,02 etc.... This is TxtMonth
The second one holds the date
Such as 2001,2002 etc...This is TxtYear

I'm trying to copy a FoxPro table to a new location (overwriting an existing
copy) and then using the copy to produce reports. I have placed the following
script on the form that opens automatically in the OnOpen Event for the form.
Dim FileFrom As String