Hello All,
I have created a tabbed form with four subforms. In the first subform there
is a field named
[Corrective _Action_Req_Date]. I set the default value to =Date() in the data

Every time i open a document office enterprise star doing de configuration...
how can i stop that?

I have an Access 2003 form that displays four computer labs and what
is scheduled in each room for a given day. At the top of the form is
todays date and below that are 4 data sheets (one for each lab)
showing the events taking place in the lab for that day. What would

When accessing my form I receive the Run Time Error #35601:
Element Not Found: Possible Causes: You selected a table/query for a child
level which does not correspond to a value from its parent level.
Can someone explain to me what I may do to fix this?

Ok here it is
I have 5 data bases which build a large list of names.  Main issue is all 5
build unique names which are used to store data to smaller subgroup items. I
need to build a data base that I can added these smaller subgroups to (to

When I try to open one of my forms I am asked to "enter parameter value".  If
I created this prompt, it was by accident.  Right now it is asking for a
value that is of little concern to me.  I would like to change it to ask for
the phone number.  Because I don't know how I got ...

I am using Access 2003. I am trying to create a query that returns
only records for todays date. I've tried now() and date()
unsuccessfully. Can someone give me hint on what to try? Thank you.

Hello, Im using a module that I use to give me the total days from a start
date from my table named tblPlantInfo. I have a text box on my form to
display the number of days using a test box on a form and its Default Value
is ShowLastLTI(). This is a date that will not change ...

Lets say we have a table containing names and their heights. In the table
there are 10 John's and 10 Mary's all of varying heights, how would one query
this table in order to return only the one John and the one Mary whose height
is the smallest?

I am creating a table at the moment with the field name "what is the weather
like today?" I am creating a list box with the options: Warm, cold, wet, dry,
windy, icy, snowing..... How can I allow the user to select more than one
option, or restrict them to selecting only one ...

what can i use instead of a combobox when it can't contain all of the
rows required by the user/client.  my client needs a way to enter a
count for inventory items when they are found in an undocumented
location.  so they need to ensure the item numbers are real and the

Suddenly I cannt compact/repair any of my dbs
I get the following error:
MS Access can't delete <path>\mydb.mdb after compacting it. The compacted
database has been name <path>\mydb.mdb

Hi,  I have been using Access for about a week and have hit a brick wall..
I have created my tables & from these a form. I'm very happy with what I
have done so far and it serves about 80% of it's original purpose.
I would now like to amend my form by adding 2 new fields:

This is a question so fundamental I'm embarrassed to ask it and believe it or
not I have searched in books and tried deconstructing Northwind but I am
missing something vital in my quest to learn Access. I imagine it is so
obvious to everyone else.

I have a query of drilling data with fields BoreholeID, From, To and
Rocktype. Bear in mind each borehole can have any amount of records and the
same rocktype can appear more than once. Lets say 50% of the holes have their
first Rocktype as SAND and these have STONE as their ...