I don't know if it is possible but here is what I would like to do if
possible. I have a table with two fields: Week (number) and Word(text). The
week field can contain numbers from 1 to 10. An example might be:
1 current

I am using 5 different projects. all contain the same modules such as for
stringIO or fileIO.
as ms has not implemented dynamically linked modules jet (it would be to
usefull to implement ?), everery time I change someting in a module I need to

I am in the process of converting an Access back-end to SQLServer. At
the same time I am altering the database schema which is now...
tblTransferHeaders (one-side)
   transferHeaderID

Is there a difference between a form's class module and just a class module?
I am using this code found under the www.mvps.com to choose a folder.  I
placed the code under a new class module and when I went to compile it, it
gives me an error stating "Method or data member not ...

I am very green at this stuff so if the answer should be obvious then
please be understanding ;-)
I am try to run the following bit of code in a Word macro.  I am
getting an error on the line"

Appearantly I have a lot of questions today!
I need to have an event that will 1 goto a specific frm record and then goto
a specific subfrm record.  I have a functional code for the 1st part (goto
specific frm record) but am encountering problems with the latter.  Below is

when i try to run this piece of vba, i get the said error which is helpfully
said to occur because "The macro of runction set to the Before Updae or
Validation Rule property for this field is preventing <name of form went
here> from saving the data in the form".

Good afternoon,
I have used the open event od a form to populate a 2 column listbox from a
table based on selected criteria.  My issue is that the data comes back in a
very messy order which makes it difficult to review.  How can I sort the data

I regularly need to import data containing crlf characters and sometimes
formatting and colors.
MS Access truncates these.
I have tried to circumvent the issue by using repacement characters for the

I know Access doesn't have a barcode generator like Word.  Is there a good
application I can use to add the barcodes in so I can print addresses
directly out of Access?  I don't want to do a mailmerge with Word.
Thanks,

Good afternoon,
How can execute the onclick_event of another form's command button?  Nothing
I tried as of yet has worked.  Basically I want to simulate a user clicking
the button without re-writing the entire code.

I have been using Access for some time with medium to advanced competency,
but I have not yet been able to find a good way yto accomplish this.
I would like to be able to open a form, filtered on one record via a unique
id, but have the form only display that record, i.e. not ...

On rs.Close I receive an error 'Object doesn't support this property or method'
I have 2 Functions in the module, On the first function rs1.Close works,
however on the second function rs2.Close gives an error. I am not sure as to
why. I am using rs2 to find out the first business ...

I am very new to VBA.  I would like to do a few of things.  I think it is
pretty complicated to do what I am wanting to do, I certainly don't know how
to do it.  I have a list of dates and an action code for each date that get
generated automatically in a system that I didn't write ...

I would like to append records to my Jobs table based on the name of folders
in the K:\000Projects\GMJobsFile
Each folder is of the format XXXX - Name where XXXX is the JobNumber and
Name is the JobName