Good Day all,
I am trying to write code behind a questionair.  As you will be able to tell,
I am very unexperienced at writing code so please bare with me (and laugh at
my code :>) ) but not to my expectation I cant get it to run.  Here is my

I'm a novice in using VBA in Access. Now I'm facing the problem that I want
Access to update/create data in an Excel-file, but in my code I encounter
error messages.
You find hereafter the code and also the error messages I'm encounter.

Both of the functions that follow calculate specific fields in a query.
The first function works as expected and returns zero if the TypeS is not
equal to "MF"
The second function also works as expected but instead of leaving a zero if

Does anyone know of an auction turnkey program that uses the access database
and frontpage?  Thanks.

On a timer event i let a pop-up form appear on my screen.
However,  the pop-up appears behind the current program that i use on that
moment.   If i click on the access-button in the blue bar below the screen
the pop-up becomes visible.

I want to include a logo in the header of my 'Access' report. I also want to
use 'OutputTo' to print the report in MS Word. OutputTo does not,
apparently, include images and I don't want to use blank sheets with a
pre-printed header in Word so is there a workaround? It works fine in ...

I need advice on a good way to set up a dsn-less connection. I have an
Access 2003 database that needs to connect to a SQL server. I want to:
--Automatically open the linked table in a way that the user will never
see a SQL server log-in message

I am trying to create a but so that on the third consecutive time it is
touched that it will send out an email.  i was wondering if anyone has any
ideas, any help would be appreciated.
Thank You,

I want to check whether the user enters a unique ID (such as CustomerID) each
time he enters new data.
I want to create a public function that accepts the Id to check and returns
true or false, I attempted one but it is not working. Here it is.

Please help !
I want to compact the database each time the application is opened for 10
times 'cos I create and delete objects such as tables and reports on the fly.
I'm logging the open count and want to ask the user if he wants to compact

I wanted to split two Access MDB's. One MDB will run locally as the
client. The other MDB will be on the network. My question is how does
the client connect to the server data. Here is my code.
Dim rsClient as ADODB.recordset

Note the following Query Field names associated with functions:
IDX_:IDX([ID])
Function IDX(ID As String)
IDX = ID

My database contains information about different organizations in several
relational tables.  I have created a utility that allows the user to select
one or more organization(s).  The code then copies the entire back end
database, deletes all records from all tables that do not ...

I have a form which displays our customers details and one of them is there
credit card number.  I would like to change what is displayed for tyhe card
number from 1234-5678-9012-3456 to ####-####-####-3456.  I beleive it is
something to do with the format control on the form but ...

In 2000 I am trying to write code to loop through data in a table, each time
it is created, and assign an Order By number to each record.  I know I could
sort by the Index, but I would like the Order By Number to always start at 1
and continue to the end of the record set.  I ...