Hi, all...
Having problem setting a reference to an object module so that I can
search/replace using VB Code.  Here's a snippet:
Option Explicit

I'm familiar with using listboxes in VB6 but I'm currently using VBA in
access 2000.
Can someone please show me how to take the selected text from a row in a
listbox and simply display the text in a textbox field ? Sounds simple enough

I use the code that follows (borrowed from a prior post) to import an
indeterminate number of text files (course evaluations) into a table for
further processing.
Unfortunately, the files' records contain no field that identifies the

What is the best approach to automatic letter generation?
While I'm looking at a record, I would like to generate a form letter based
on the record and relating data, ideally with one click. I've tried both
reports and forms and find limitations in both.

Hi,
I have a table that I need to calculate the enddate field. I inherited this
database, and it is only now that the users need to calculate the enddate.
And of course, they need the endate to be retroactive.

If someone can help me that would be awesome!
I have a downloaded MDB from microsoft that has been tweeked, well VERY
modified (contact management database) I have added a combo box named "sales
associates" and created a table, also created a relationship for that table

Can you patent a database that u created in access?

I have a small problem.  The folowing code works perfectly exect in one erea.
When BASS_FTP generates an error the function jumps to "BASSREFTP_ERROR"?
as you can see, the message "That file is missing!" will be displayed.  I
don't wont that message to display if the function ...

I want to get records from query and populate them to a table. I just used
that code below but in the 6th line "Set rs2 =
db.OpenRecordset("CoursesQuery2")" program gives that error. Can somebody
explain how can I fix this problem?

Is it any buitl in function to convert any caracter to his equivalent in bits
(ceros & ones): ??
Example:
A = 01000001

I have two db's. I need the first one to check and see if the second one has
a certain form loaded and, if not, to load it. I have the second db as a
reference in the first db but can't figure the syntax to query the second db
to see if the form is loaded... then, if it's not, ...

I'm still trying to figure out how check to see if another db has a form open
and if not then have THAT db open a form within itself. I've tried the
reference routine but when I executed the function in the other db to open
the form it opened the form in the current db and then ...

I want to send a string directly to a printer out of a VBA module. The
printer is a Zebra labelprinter and i have to sent several codes to build up
a barcode to print.
I already created a vaiable which contains all codes and information to

I've been stumbling around the forums and trying a variety of things, but
can't solve this problem.  Here's what I'm trying to do:
I have a form control which queries the open quantity for a job.  The query
criteria use three other controls on that form to filter the results to a

Is there a function that will allow me to only pull the numeric data from a
field? Currently I have a field with letters and numbers, but I want to
isolate the numbers.
Current field                How I want it