I have a table with 1000 items containing information like item name, cost,
supplier.  I would like to be able to edit these items through a form.  How
do I allow the user to perform a search on the 1000 items and then select the
one that the user wants to edit?  That is my ...

I have a database merged from access 2000 in 2007.
Many forms use different active-x controls.
When I open the form, I dont get any message, but the control doesnt work.
If I click on it in Form View, it gives me that message:

I am trying to create a calculated control on a form as below
=amount * 2
all this gives is #name? error
the field exists and is either number or currency data type.

I have a listbox that displays Date and Quantity above the listbox is
a textbox that holds the year . On the After Update event of this
textbox I have the following expression
=Text14.Requery

I am relatively new to Access but wonder if someone can point me in the
right direction with a problem.
I am trying to create a control that has the value of a table field followed
by the word "account".

I am trying to get a Date Value in the format YYYY-MM from a MySQL database
using a pass through query.  When I run the query I get this result - 〲㘰〭.  
If I run this query in MySQL i get the correct result - Why does Access not
understand it?

I would like to create a search form which is identical to a form I have set
up already and gives the user the opportunity to search any of the fields
within that form. Essentially I want to be able to use the 'filter by form'
format but I am aware that code is unable to run in ...

Hi There,
I would really appreciate some assistance, I am designing a database (low
key) but I am trying to get my face known in an org (nothing to do with
database thank goodness!) but I volunteered to do this database and have hit

i have an command button over an openup form to open an another form,
i want the form to enable and disable under conditions
 (1) whenver specified textboxes not filled /wrong data used
 (2) whenever typed data deleted

anyone can help... I want to write a good testimonial to a sales person that
have help alot during the project

Is there any function which can return the screen resolution ?
I hope the function can run in any version of Windows.
Thanks.
Chlaris

how can I create A msg box should show how many records the run sql
cmd just updated I have the set warnings off
thanks

I am building a maintenance database for heavy equipment.  What I have
is a form which shows the information about a particular piece of
equipment - for example a dump truck.  I have broken the form into
three tabs: "General Information", "Technical Information", and

I noticed that the margin on the right is very wide.
What can be done to make it smaller?
Thank you,
Samuel

Hi All,
I have hit a snag with my subform idea for a database. I have created a
database to capture volunteer information. So here is my problem....if any of
you could assist me you would be life savers.....