There is a form where it ask the two dates and then run a query then
report.
Private Sub Command36_Click()
DoCmd.OpenQuery "qryResultsReport"

I  have a database project where there are exiting Brokers,
FundPurchases and Investors in three tables.
A Broker sells to many investors who can have many transactions.   Each
Investor usually has his/her own broker.

Hello Newbie Here
Biting off more than I can chew, but anyway. Trying to create database for
purchase requisitions at work. Through trial and error I have been able to
fix most issues that have come up. Problem I seem to be having is on purchase

I have 3 text boxes on one line in my report.  I would like to eliminate any
spaces between the boxes due to variable length text
The first box is a product name: sPCN_nam
The second box is text based on an IIf statement:

I have a subform with combo box. User's are having difficulty selecting
values from the combo box directly because so many of the values are similar
(many beginning with the word "university"). Also, the hard copy entry form
often has only an approximation of the correct name and ...

When I pass a value from MyTextBox to MyComboBox using:
Me.MyTextBox = Me.MyComboBox
It does Not trigger the AfterUpdate Event of the ComboBox
I need it to! Any Suggestions??

Macro and button all works fine. It goes to other database and open the
form from their. Now only problem is that there are two forms link to
each other. When i click on the button it works fine and open that form
which i need but there is also a link on that form which open another

I need code to clear the clipboard after I dupe a record so that it does not
fill up or give me the msgbx pertaining to whether or not I want to save the
info on the clipboard EVERY time I close the form!
I saw it somewhere before, I don't know if it was here or another site.

Is it possible to query the RecordSet of a form (ie, the data currently
displayed on it)?
I have a form based on 3 queries (the AfterUpdate event of a combobox
switches the recordsource of the form). The form displays the "one" side of a

I wonder if anyone can help me with a problem with an ActiveX control.
I have inserted an ActiveX date picker control into a form and linked
it to a date field in the underlying table. However, when I navigate
the records in the form I am getting error messages as below:

A 'test' is a list of questions. Each question has a grade (a number). I can
display a 'test' form with questions subform and display the average grade
of the test, updated whenever a grade is modified. So far so good.
I have a 'person' form with a subform that lists 'tests' with ...

I am new to access and am teaching myself as i go along. This is what I want
to do:
I have a table of Entertainers. I have another table listing show dates and
entertainers booked. What i want is to have a form to choose the show date,

I am trying to create an event on the basis of a sum field., however, it
seems that when using ON Open the form is opened before the field is actually
summed always giving me a zero answer in the field. It doesn't matter which
event procedure I use the answer is always zero even ...

I have developed a spread sheet that gathers individual customer data. After
I gather the data, I want to compare it to every other user. I am hoping to
copy the spread sheet into an online form allowing customers to see an
indivualized comparison.

I have this expression in a query.  If any of the three are "0" I receive an
error.  How can I compute this formula so that I do not receive an error?
expression: [CleanOrdersWithin]/([TotalShippedOrders]-[OrdersReqIntervention])