I've created a database that reformats client files into a universal import
format.  Basically, the user selects a file and based on the client I run a
few queries to parse names and then run the file through a program to formats
the data.  At the end, I do a file copy to archive ...

I am trying to update a field, Class_Type.  The update will be based on a
previous record different field, fund.  Here is an example shown below.  If
you notice the Class_type will be different if the fund value is smaller or
equal to the previous record's fund value.  I have a ...

I'm being a pain today, but trying to address all the issues with my
database.  
I use the following to allow my customer to select and load multiple files.  
My issue is that if they click yes and then get to the selection window and

I am having an issue with programming a VBA code to use input boxes, pull
the beginning and ending dates of a month, in order to import a Database
Table.  Coding looks right to me, but gives an error stating:
"You cancelled the previous operation" Error 2001 and highlights begwk

I have a form with multiple subforms that I need to daisy-chain in terms of
the linking...for lack of a better description. Figuratively it will look
like this...
Parent form >> child form >> grandchild form

I'm trying to write a function that creates a directory & Subdirectories. I
can create a String say "C:/DirL1/DirL2/DirL3/" say but I dont know if DirL1
or DirL1/DirL2 exist. what I need is a recursive string function that will
test for the total directory String, if not test for ...

I created a telephone log in MS Access and would like to know if there is a
way I can copy my notes from a form in Access and past it to my email message
automatically?  Also, is there a way to have an entry added in my notes to
indicate that an email was sent?

How do I write global variable values to a table. I have the following module
which captures the network user id and computername when they log into my
database.
Option Compare Database

I want to run a SQL code to present the outcome into a subform:
There's 2 criteria values for user input!
SQLString = "SELECT NrSubscritor, Initiated, Concluded, Year, Month FROM
Processos" & _

I have a list of work orders in a database that I would like to assign a
priority number. This will be the order in which the work orders will be
worked. As new work orders are created the priority for the work orders may
be reassigned. If I have a list of work orders and they ...

I have a query with two columns
VendorID and FileName
Look like this
9287 C:\myfilename.txt

Isn't there some loop that allows non-sequential numbers? I thought I had
come across or actually used something like:
For n = 0 to 4, 6 to 10
Next n

I've added a Windows Brower to a tab in my db and need to open a web site.  
It work great with any site that is http, but I need to connect to a https
site.  I have to correct string with the parameters for the user id and
password.  My problem is that I get an error and seems to ...

I have developed at different levels with Access for many years.  I think it
is a great product.  But I am now getting interrupted on the most mundane of
changes, like adding a text box, with the error, sorry Access must close
down, suggest you upgrade.

I am trying to use FileDialog in combination with TransferSpreadsheet to save
a file named by the user in a directory of the user's choice.  I am able to
bring up the SaveAs dialog box with no problem but the user has to select a
file in order to save the current file as that ...