Dear Ones,
Is there any available crosswalk or translation guide or index that would
enable a person to find what SQL functions are available in ACCESS for
manipulating text strings?  In particular, it would be helpful to have a list

We are backfeeding data from a fedex application to a access table and we are
having a problem where the value '0123456' will be sent as '123456' I have
worked with fedex to try and accomplish fixing this problem on their end, but
with zero success.  I need to write a query that ...

Using Access 2000, I have a report based on a query/table with a date field.  
I would like my report to group on the last Friday of each month.  Any ideas
on what kind of formula I could use for that?  Thanks.

I have a client that is using Access 97, they want to be able to archive some
records, however, I need to make sure that the records that they are
archiving are not from the previous year and I need to code it so that it
will be automatic for each year...

I have code that loops through some statements, previewing the same report
each time through. After the first report previews and I close it, the loop
seems to end and will not prewiew the remaining pages. It seems as if I need
to be trapping some event or somewhere within the ...

I have the following expression in a query:
CDate:dhSubtractWorkDaysA([LTW1],[MatDueDateCalc],[HolidayArray])
I've posted the module below that contains functions that subtract # of days
in [LTW1] from the date in [MatDueDateCalc], without counting Saturdays,

does anyone know why this code wont' work?
Dim zipped As Long
zipped = Shell(CurrentProject.Path & "\7z\7z.exe a -tzip " & "doubts.zip" &
CurrentProject.Path & "\doubts.doc")

I want to create form look like explorer to receive attachment file. I am
using access 2003

I am using a multi-select listbox to show the results from a query in my
application. This is done like:
listbox.RowSource = strSQL
listbox.Requery

I need office for a 98 windows

I’m quit new at this, so I could really need some help, to make some VBA code
for my problem.
I have a text file with all of the text in one single line, but I need it to
be in lines of 80 charters, and maybe save it to a new text file.

I want to be able to copy commandbars from one MDB to another using code. Is
there a way to do this? I can't find any commands or methods that copy or
transfer commandbars to another database.
If possible, I'd like it to work in Access97, 2000, XP, and 2003.

Anybody read this book by Denise Gosnell.  I like the direction but I'm
running into problems populating a combo box and then setting a selection by
value and not by numbered list - 0, 1, 2, 3, etc.  This is all unbound,
hand-coded stuff.  Basically I need to select an item in ...

Two tables that are related by the Boat Model make up a query.  The tblModel
has anywhere from 9 - 12 boats and the tblParts has from 12 - 12,000 parts
per boat.
What I need to do is write an Array and/or Loop to cycle through the

In my applications I have followed the practice of setting database and
recordset variables to nothing when exiting a function or subroutine,
for example:
Sub MySub()