I want to provide the user with the ability to Compact the database and also
to Back it up, via a button on a form - in my database all standard Access
menus and tool bars are diactivated.
Any suggestions?

Hello again all,
I am stuggling with the syntax of VBA in Access versus VBA in Excel, so any
assistance you can provide is greatly appreciated.
My goal is to clear contents rows 2 to end in OPEN tab, goto tab OPEN1, rows

I have a table that has a field that has each day of the week and then TBD
(To be decided).
TBD is the default for this field.  
I created a query with a command for the "day field" as stated above.  This

The code I use for a cascading combo is: me.[field].requery.
In this case [field] is in a subform and the list is based on a combo in the
main form.
thanks.

I have this code and for some reason I can't get the value of the field.
What am I doing wrong?
[Forms]![frmListReleaseTrack]![ListRelease Track tbl sbfrm]![TrackNoValid]
Thanks in advance!

Does anyone know how to save a record in a form through code.  I don't think
the DoCmd.DoMenuItem is an option in v2003.

I just started playing around with recordsets and trying to move around the
datasheet to perform certain calculations. What I'm first trying to do is
just pull data from a field and enter it into a new field in the record
below, if I can figure out how to do this, I can do my ...

I'm no programmer, but am trying to add what seems to me to be a fairly
simple feature to a very simple database I have put together. On the click on
a button on a form, it calls a couple of reports to print an exam built up of
questions and the corresponding marking guide ...

On the suggestion of another thread I placed the word LOCK on each of my
controls TAG.
On the Form event Current I placed the following code. I get run-time error
438 Object doesn't support this property.

I am getting this error message at the FindFirst call in the following code.
Run-time error '3251':
Operation is not supported for this type of object.
Sub FillOneLCdetails(lcID As Long)

How do I populate a field in one table with an average of other fields in a
query based on the first table?
Breakdown(ideally):
1) In Table1, in the first record, the values from field1 and field 2 are

I found a possible solution to a previous post about retrieving  image
extended properties.  I downloaded ImageProperties.cls from
http:'www.mvps.org/emorcillo
website.

I have a simple Access system, using unbound forms, which links to ODBC Sun
System SQL files via a Select Query - for reference material.
e.g customer names, product description - but updates only its own tables -
and by unbound forms and an eventual code update  - not a form save ...

i want my access2003 database to be able to read outlook items in the outlook
calendar. For example, when i open a form, a label will display all items
within the current week.
If this is possible as i suspect it is because i know you can read

Hello.  I am trying to copy objects from one DB to another and I know I can
create a macro to copy individual objects...but can you copy over multiple
objects at once instead of creating a copyobject for every item?
Thanks in advance