I need an input form to automatically add a new row in the detail section if
needed.  Can anyone help me with this?

I want to set a value for a field based on a calcualted control.  Here is my
VBA Statement.
Forms!Loads!Rates!RateAmount = Forms!Loads!Rates!LineHaulRate
LineHaulRate is the calculated one.  When I put the command in On Exit

I was wondering if there was any way to reference the name of the currently
executing procedure. Basically, I have error handler code in each procedure
in my database that looks something like:
Form_Load_Exit:

What is the equivilant of a common dialog control in Access 2003?  I am
trying to make an access 2000 database work, but the reference to the
Microsoft Common Dialog Control 6.0 is missing.
Thanks,

Hi guys, I have created a form in access and want to addin a button,
which onclicking clears the form of anyentered values.
There are 5 text fields for user input and if a user clicks this
button, then it should clear all the text fields(if any values are

Need tp create a work log form where the choice selected in the first combo
box will determine the choices available in the second combo box. For
example, if the user selects "Put on Shoes" in the first combo box, the
choices in the second box are put on socks, tie shoelaces. Or ...

I have created a table containing the fields 'quote before VAT', 'VAT' and
'quote after VAT'.  I have then created a form based on these three fields.
Basically the idea is that when the user enters the quote before VAT, my VAT
field will automatically workout 17.5 % of the value, ...

I previously posted a question to "Change Toggle Button Caption" and recieved
a good example to make a toggle button (CustomerChkBx) change the caption
from "No"- not pressed in, to "Yes"- pressed in. Code as follows:
Option Compare Database

I have a simple inventory database and it requires that the product be in the
table before it can be entered on the receiving form. I made a button to open
the product form to allow you to enter the new part but it does not show up
on my receiving form unless I close it and then ...

Can anyone tell me where to download a good FREEWARE date picker that
can be bound and that will not error out on null record feilds which
the built in microsoft version does please...TIA

I've built a form so my employees can enter in their daily sales they make.  
I have a combo box [ComboA] that lists "Sale, Opportunity, Loss."  I have
another text box for them to enter in order numbers [textA]. What I would
like to do is if [textA] is null, then they CANNOT ...

I have a combo box on a form that allows the user to select the record they
want from the list and the details of the record display in a subform.  The
strange problem I am having is that no matter which choice you pick from the
combo box list the first item on the list is always ...

One of the best uses of a list box that I have seen can be found If you go to
the menu bar of Internet Explorer and click Help / Contents and index, under
the index tab. Microsoft uses this in all of its programs, yet I can't figure
out how to make one in Access. Although it would ...

I have been reading these newsgroups over the past few months while writing
a database here, and a constant message being stated is: Always Use A Form.
Can I have a breakdown on these 3 choices of 'data editing'?
1) Direct Table Edit

I have created a massive test data base, and want others to use it.  I
created a combo box for them to pull up the record information by selecting
the test name in the combo box.  The information pulls up in the form just
fine. But, If you use the thumb wheel on the mouse the ...