I have a database at work that keeps an inventory of cameras by
location. Every week I get a repair estimate sheet that lists cameras
by serial number that need to be repaired. This list is sent to me in
excel. I am trying to make it where I can just copy the column of

I have an interesting Challenge - It is effectively an inventory system
but with a twist.
For each client, I need to track, let's call them containers. each of
these containers logically contain, let's call them widgets. (widgets

I have a database that keeps track of cameras by location using their
serial numbers. I have a report that in the report footer I have the
following:
=Count([Camera Serial #])

I have a database at work that keeps an inventory of cameras by
location. Every week I get a repair estimate sheet that lists cameras
by serial number that need to be repaired. This list is sent to me in
excel. I am trying to make it where I can just copy the column of

By first time I apply to this NG.
I would like to blink cells in Reports as by Excel.
Is it possible ? Which way ?
Thanks

I have a query running against Oracle which returns approx. 140,000 records.
I need to store all this data locally in my BE database. Conventionally I
would set up a table to contain this data and then run an Insert Into (append)
query. Perhaps I might also experiment by toggling ...

Not sure if this is possible but I am working on a database, that
requires the following function.  Be able to book a job in for a given
week of the year, and this then becomes unavailable for anyone else to
book the same week.

I am trying to enable the Person Name Smart Tag, but after I open up my
table in Design view and select the field (in this case CustomerName
field), click in the Smart Tag text box, click the Build button to
launch the Smart Tags window, and select Person Name at the top of the

Just wondering if there is a function in VBA that is able to open up
the data in a RecordSet
to a normal table look in MS Access?
Thanks.

I would like to be able to using VBA from an Excel macro - go through
each line in my spreadsheet and add to a database.
I know that this can be done via the import external data tool in
access but the final solution i am working towards will allow the user

I've seen several very nice routines on various web sites to fix table
links when a file is moved.  So far all the ones I've found have used
DAO.  Anyone know of a sample of such a routine that uses ADO?
Thanks,

I have an unbound combo box on a bound form (bound to a Sites table)
that i want to fill with a list of data from an attachments table that
contains the paths of the attachments for each site. Each site has a
unique Site Ref which is also stored in the attachments table.

I have a bit of a newbie question (basically stated in the subject of
the posting).  If need to get some data out of a SQL Server Database.
Can I use a control from a form to supply a parameter.  I've created a
stored procedure with the parameter I need, I just dont know how to

I checked all my references prior to compiling. The mdb or mde works
perfectly with full version of A2003.
When running on a computer with RunTime i receive an error that a
reference is broken to msoutl.olb version 9.2.

This one has bugged me for years.  I have a combo box after-update event
that sets a one column list box to a string value.  (The lsit box is a list
of tables).   I check the value of the list box right before the "exit sub"
line of the combo box after-event and the list box still ...