I have a form which i used to collect data used by an update query. When I
click a button on the form I trigger a macro that opens the query. The form
passes parameters to the query. When the button is pressed I want to validate
that an entry has been made in a specific text box. ...

I have a form which contains a subform. I want users to be able to 'Tab'
through the textboxes on the subform and then have the cursor move on to the
texboxes on the form as 'Tab' continues to be pressed. I have used the
following code in the last textbox on the subform's ...

I have created a database, and i also created a form that i use cauculated
fields inside the form.  I have serveral cauculated fields but only some are
showing up in the table while others do not show anything but a 0.00 in the
table.  when i query the information its not correct ...

Does anyone know where I can get a complete list of Access trappable errors?
More specifically, is the error a user gets when they try to open a form to
which they have not been given permissions, a trappable error?  
The error message is "you do not have permission to open ...

i have  a form with  a textbox named NOTAFISCAL and a a subform, with
details of the sales , is posible apply a filter in the subform , i want
only view only the rows related with the value NOTAFSICAL, how i can do
this, i have try with the filter propierty but any results, i have ...

I need to convert date field to Month / Year to allow me to query by month.
For example converting 01/01/2005 to Jan 05.  Is there a simple way of doing
this in the query?

I posted a two questions yesterday concerning the colours of buttons on a
control tab and command buttons and had various useful suggestions as to
what I might do. However I think my problem is more fundamental. I have
designed a number of forms for my database which will be used ...

Can anyone help me figure out the code to do the following.
I have a form frmNewStock that is bound to tblStock.  The form has a
checkbox bound to tblStock.chk01
There is another table tblAd that is has this same field chk01.  When a user

My users need to input the details of a quotation into a table in my
database, i have designed a form for them to do this. They then need to email
the details out in Excel. However i want it to look identical to the form i
created.

this is maybe quite a Noob question... but i cant figure it out.
i have to optimize a access database, and cant figure out whitch tables/
query's are hangin below this particular form!
can annyone help me?

I had a problem with a form (Data Entry was set to Yes; should have been No)
that would have been much easier for me to isolate if I could have compared
the property sheets of two forms.  I don't think Access will put two
property sheets on the screen at the same time, and I ...

I'm not sure if anyone can help me, but I basically have a main form
that has a combo box with a list of "shows".  I also have a bunch of
other forms that I want to make available (as subforms) to the user on
the main form depending on which "show" they choose.

Hi all expert here,
I am creating a form in which it contains two LIST BOXES.
The first list boxes will ask the inputter to choose the CLASS.  Then after
the inputter choose the CLASS, the second list box will populate another list

My combo box looks up a row from a table.  The fields are "Output Type" and
"Adjustment".  The problem is the adjustment values are the same for more
than one output type so that if the output type I am trying to select
contains a value that occurs earlier in the list, it returns ...

I have code that maximises a main form when the current report is closed. I
have to do this because if a user clicks on the restore part of the control
box of a report (for whatever reason, god only knows why sometimes), when
the report changes size, the underlying form is also ...