I have a specialized program that exports data in a horrible text format,
that is some what consistent.  
I need to take the records of each line and split them out into columns.  I
am using a varString = Split(junkfield, ,6) - This is as far as I have gone

I have been building a fairly substantial Access 2K application, and just as
I am nearing the end of my coding, I have noticed a worrying new type of
behaviour.
A couple of times recently, when I have written code that doesn't work,

Anyone have a suggestion for easily formatting numbers as ordinals in an
Access report?
Muy thanks.

please have a look at the following code:
dim var_range as variant
dim var_first_field as variant
dim var_second_field as variant

I have created objects in class modules in my access project.  In another
database I want to create the object so I can use its properties.  I made
sure the database has a reference to the project.  i can search the object
browser and see the methods and objects. But when i try ...

Good morning,
I am making an Access VBA module and need assistance. I made a table to
contain a single record and I need to know if there is a way first to assisgn
this record to get its value from a text box on a form entered by a userAnd

I'm using Terry Kreft's Shell Wait code from the mvps
website to use an old MS-DOS program, PKZip, to zip some
files.  The command I am passing works in the Command
window.

Hi Masters of Access Programming,
I am trying to produce an array or a string from a query. I can do this when
producing array/string from a row, BUT i want to produce array/string using
information in one column.

I used some scripting I found from Tony's site in which he uses a database to
automatically update the client db.  Everything works but I am having trouble
with one piece of this.  
I had wanted to place the client on the user's desktop to help them as most

Dear Group,
I'm having a problem with the following scenario and could use some
help.  
I have an form (formPartInfo)with an empty record source.  On it is a

I've searched the newsgroups about this, and any posts regarding my
particular situation are from 2000 or earlier, so I'm hoping a resolution
has come up since then.
I have a Back End that is used by several users' identical Front Ends.  All

I have a database and on a button on a form I have the following code:
Private Sub btnEditRequest_Click()
On Error GoTo btnEditRequest_Click_error
  Me.Parent![Edit].Form.Requery

Hi, I've created a button in a form that calls the transfertext function to
import a file when it's clicked.  Currently the user is not informed when
there are import errors.  e.g., type conversion errors in fields - the row is
still imported, and the errors logged in a new table ...

Good afternoon,
I am trying to set up a bound text box, so that when a user types a value
into a text box on a form, that automatically adjusts that value in a
single-record table. I attempted to set control source of an unbound text box

I am trying to implement Article ID 31881 -How to use a record set to send
Outlook e-mail to multiple receipients in Microsoft Access.
I have copied the code suggested into a new module. However the compiler
does not like the first statement. (Access 2000, VB 6.0)