I have created a form that has a list box and a command button.
I want to select a data entry from the list box and then press the command
button and open an other form2(a new form that has data).
That form2 i want to show all the data that contain the selection i made in

Why do I keep getting message that the Macros are disable and it needs a
signature.
Also indicates that my security is set to high as a reason. But they are set
at med.

I have built a database for use by some less then Access Savy folks.  Some of
the process I have built in delete and rebuild data from an outside SAS table.
This results in the database growing, I would like to build a button that
will run the Repair and Compact functions so that ...

I use a query, designed by someone else, that pulls the hire date for
employees from the database, and then performs a calculation on it to get the
number of years worked. It uses DateDiff to get the number of days between
now and the hire date, and then divides that value by 365 ...

I am trying to set up my database so that it will automatically update its
tables and reports with new information on a daily or weekly basis. I am not
really sure how to make this work automatically, like without having to press
any buttons.

I'm using Access XP.  I have a database with several tables, my Main table
has names, company names, addresses, etc.  One of my child tables tracks
whether or not this person or company would receive a holiday card.  In my
Holiday Card table, I also have address fields because ...

I have copied the comments below from an earlier post that I thought solved
my problem.  Although it worked to show/hide the form, when I click the
"ExhB?" box it sets all subforms for all records the same.  I only want the
current record to be impacted by the "ExhB?" box.  ...

I am using Access 2000 and I want to hide/show a subform [PropandContractsbf]
based on a yes/no box "ExhB?".  "ExhB?" is located on the main form
[PropandContract].  
I have an event "AfterUpdate" set on the "ExhB" control to refer to the

Hi -
I'm working in Access XP.  My combo box will not allow me to type something
other than what is on the list.  I've tried changing the properties, but
still can't get it to work.  Any ideas?  thanks

I have a field called ClassID on a form.  When this field is filled, I would
like to automatically create an invoice for the registration/tuition.  I
thought I should create a macro in the properties of the field which opened
an invoice table.  Here I could use SetValue ...

I have a table with two fields one a number and the other a description.  In
my form I would like to enter the number and have the description
automatically pull into the description on the form.  How can I do this?

I am brand new to Access and armed only with a For Dummies book. I'd really
appreciate some help.
I have a list of employees and their Layoff Date, the date they Returned to
Work and the date they move to the Bottom of the List (22 days after they

I need help! In more ways than one, but especially with a formula/filter. I
have a form (Age Selection Form) with a listbox that has several different
age ranges to select from (ie; 0-5, 6-12, 13-17, 18+). When you double click
on one of the selection I need it to run a report ...

I have the following macro I wrote in Microsoft Excel VB to seperate out the
2 parts of a postcode. I want to be able to do this in an access database.
Can anyone tell me what I need to do? I have only just started using Excel VB
and have never used it in access so baby steps ...

I'm building a Macro that opens a report and in the OpenReport I'm trying to
get an expression working in the "Where Condition" field.  
The report I'm opening has a subreport in it and each of the two reports has
a date field in it.  I want to be able to punch in one date range ...