Hi, everyone...
I've just started using Access, and now have a field that I need to
round up to days. The field is in hours, the smallest figure being
0.01 and the largest 2400. What I need to do is round this up to days

I am developing a document management system in MS Access (adp on top
of SQL Server). One thing I would like to do in my listview is show the
default icon associated in Windows with that specific file extension
(e.g. show the excel icon when my file has an xls-extension as Windows

I'm trying to clean up a database of mine, and I need to convert some
old DAO code over to ADO. When I was using DAO, I had no problem
running this script and deleting the record using rs.Delete.  But when
I rework the code in ADO, it tells me I can't delete it because there

With Oracle 9.2 drivers, this worked connection string worked in a DSN-less
connection
ODBC;DRIVER={Microsoft ODBC For
Oracle};Server=MyServerName;UID=MyName;PWD=MyPwd;

For simplicity sake, here are the basics of the query I am stumped
on...
Type: Select query
Name: ColorCells

I have two date fields, actual and target.
i would like to return all data from the table only if the actual date
is within 30 days after the targeted date.

I hope someone can help - I am new to Access so please be patient.
I have a list of about 100 equity tickers in a column in Excel
formatted as Text.   I am trying to copy and paste into a field in a
table in Access with Text data type.  For some reason Access only

I have an address label report based on a query of names and addresses. I
want to supress printing labels for those people with emails held in Fieild
MemEMail
so in the Filter property I put     Len(Nz(MemEMail)) = 0        no

I have field in a form that calculates a value (field is defined in a
query).
How can I overtype the result of formula?! I have to save data in a table or
...

I have a dilemma where I am creating a dynamic two dimensional array
and filling it with information from a .csv file.  Unfortunately,
later when I try to call that information back from the array I get an
error or I don't get anything back at all. I'm not sure how to make a

Does anyone know if it is possible to integrate SQL Server Reporting
Services Reports in an ADP? Is there a plugin or anything that can do
this? I have a hunch that the Web Viewer Active-X componant wont be up
to the job. I've googled it but it seems to be slim pickings!

If you openrecordset to execute a query which does a join on say 2 or
3 tables is it possible to add a record to the recordset and thereby
add record to each of the tables in the query?

   Is there a function to log out people on a secured DB in access. Let's
say after 2 hours of inoperation .
Tks...

i created an qrUnmatch query to find the unmatch ModelNumber data between
tblMSM and tblLinkedData
tblMSM has fields ModelNumber, Desc, SpringID, FoamID, ConfigID, SizeID....
etc...this essentially builds a bed.

I am new in the field and might be asking a dumb question, but please
I still need help.
I am running the Business Object 5.1.8, and using Freehand SQL with
Oracle 8.1 connecting.