I have a couple of combo boxes on a continous form.  The user is free to
select anything.
However if they select the same thing twice from combo1 and then combo2,
they've effectively created a duplicate record.  What's a good way of

I have Access XP. I know Visual Basic quite well. One thing I know Access
can do--and I can't quite figure out how--is to rename the files in a
directory.
If the file is named "aug01_003.jpg" I want to rename it 2004_08_003.jpg.  I

I am having some problems getting combo boxes to work right.  I'm
trying to get a combo box to select all the distinct "invoice numbers"
in a table by using the following SQL statement:
"SELECT DISTINCT TblStock.[Invoice Number] FROM TblStock;"

I've got a report, Report1 that i want to print to network Printers A,
B, C all with one key stroke.  How do i do this?

Can any one help,
I want to send more than one snapshot on and email
My code is
DoCmd.SendObject acSendReport, "rptCashBook", "rptCashBookDetail",

This is for an Access project!
Does anyone know of a way to graph a WAV file or to numerically represent a WAV
file?  I'm looking for a way to compare different WAV files.
Harold

Yesterday night I was not so happy 'cause, after working for a month
to convert my application from  client.mde/server.mdb standard to
client.mde/server.mdb + replica, I realized an application too slow.
On LAN, the client (FrontEnd) is very slow to link to a server

I've got a table with several adresses in it and now i want to have a
button to export the records to a textfile!
So I need a Visual-Basic command to open a SaveAs-Dialog Whenever a
user presses the Export-Button I have on the formular. I have found an

Hello all -
Hopefully there's a quick answer to this one, but I haven't found any
good info in my reference books...
I have a list of customers and a list of prospective customers. All I

I have two fields on a form. Once called School, the second called
SchoolZip
I want the users to be able to go to the ComboBox field called School,
select the school they want, and have it auto populate the SchoolZip

Hi, I have an report in Microsoft Access and it displays everything in
the table. One column called "DECISION" in the table has either 1,2,
or 3 in it. On my report it displays 1, 2, or 3. I want to appear in
the report is Yes, No, or Maybe. What do I need to do to change what

i am perfoming a mail merge with the following code.
Public Function MergeIt()
  Dim objWord As Object
  Set objWord = GetObject("C:\MyMerge.doc", "Word.Document")

Using Transfer Text macro to create comma-delimited file of the
results of union query. Underlying queries use \(999") "999\-9999! to
format area code/phone number and work fine, but once the queries are
combined in the union query, the formatting is stripped out.  Any way

I  am trying to create a function that will test certian criteria of a field
and return the corisponding code that i have set for example:
Function NIXIECode(str As String) As String
Dim num As Integer

I inherited a database that somehow uses a bound combo box as a record
selector. Let me give you some background. The form is based on data
from 2 tables. The first table, Person, records info about a person.
The second table, Case, records information about a person's case,