Hi
I have a database that uses information from a vehicle tracking softawre
package.  This records that dates and times of movements.  My database
produces exception reports based on times etc.  but with BST I need to add 1

I'm trying to calculate an average using VBA from a recorded macro
in Excel, so basically I'm using the AVERAGE built-in function from excel.
First i'm counting the nr of records in my recordset and then that result
should be stored as a variable in the range for my average.

i have two sql server 2000 and access for front end. with one server which
is for developement purpose working fine .... i can send data to update and
it is diong that with out problem. but when i change the connection string to
live server. it gave me connection time expired. ...

I have a booking database which records bookings for each room in a series of
half hour slots.  If a room is booked for an hour there would be two records
- one for each half hour. The current report would show each of these.  I
have tried building a query like the one below  ...

I am using Access 2003 and XP. I started getting this error when I tried to
use DAO object in my code. After creating qry string, when I execute the qry,
I receive this message. However, I have no codes that deal with transation
actions. Do you have any idea why this happens?

I need a way to create and dump a list of all query names in an Access
database into a variable for the purpose of displaying the list to a user in
a MsgBox or something.
Should be easy, but I'm not sure how to go about it.

Hi Interesting one this.
I have an external piece of equipment that I need to access through the comm
port. This can be done through Hyperterminal etc. What I need is to find out
if I can get access to the comms port via VBA, is there a third party control

I have code that will send an email upon completion of the task, it looks at
the userid and returns the email address. Atleast on the local machine.  
Note: current userid is the alias field in Outlook.
When I tried the code on another it could not find the email address for

Hiya
I have been given 2 conflicting sets of advice about inserting data into a
table.
I have a table (tbl dummymatrixdata) which needs to be emptied (delete

I am working on a database for my wife who is an independent hair dresser.  I
am currently having some difficulties creating a way for her to track the
dyes and the amounts of dyes that she uses.  I basically have one form for
appointments there is one subform on top which has ...

If I want a column to be only 5 numbers long, some with a letter, with the
first being 0's, what do I do?
I.E.- I enter 101 and I want it to read 00101.  Some of these will have a
letter at the end so it will have to be text.  

I had this look up working great and now it's not working. Not sure what
changed in my code.
It seems to be failing at the stLink = "[RGAID]=" & SID
The RGAID is a number feild. So I am wondering if I have to change the AS

Experts, I need help with this.  when you enter a string on a form, i want to
display all the company names that have part of the string in a list box.
Thank  you in advance

How can I stop the general users from getting full access to my code when an
error occures. While at the same time being notified of errors so that I can
resolve the issues. Many of my users will not report an error message if they
are able to complete there task.

I have a Bound Object Frame called OLEBound34 sourcing an onject from
ReportImage in table FAQ. Each record witn a ReportImage OLE also has two
sizing fields, ReportImageWidth and ReportImageHeight. I would like to size
the Bound Object Frame based on the values in ...