Subform unable to present Query Output ?
Fri, 12 Dec 2008 03:34:26 GMT
Hi Karen,
Saw your posts, I face some situation.
1. I Had A form with More Than 10 subforms, I put this into 2 tab (Avg 1 tab
holds 5~8 Subform).
2. Which subforms to displays depends on Main Form ComboBox> Generate Form2>
Subform Display Base on Choice.
3. This is preset in the form>
* * * * * * ...
|
juokaa viinaa ja juopukaa
Thu, 11 Dec 2008 18:21:33 -0600
Minulta on monelta suunnalta tiedusteltu, että ketkä on ne asiattomuuksia
tänne nettiin kirjoittavat kaverit, joista on tullut valtavasti valituksia
heidän ökyillessään asiattomia ydinaiheisia materiaalejaan tänne?
No koska olen asian aina tienyt, niin voin kysyjille valaista pikkasen. Eli
kyse on tosiaan TVO: ...
|
Show Companies with no MainContacts
Thu, 11 Dec 2008 15:27:11 -0800 (PST)
CoName Table has a CompanyName field.
Contacts Table has the name of a Contact, and a MainContact field (yes/
no).
So the SQL statement would include CompanyName, Contact and
MainContact.
I want to display (list) those CompanyNames which do not have a
MainContact.
How do I make this calculation? ...
|
Count records in another table
Thu, 11 Dec 2008 14:48:01 -0800
I have a "Project Action" form with a button that opens another form, the
"Risk Form", using a DoCmd.OpenForm command. The records displayed in the
new form have an associated Project Action number that is the same as the
Project Action number in the calling form. The users would like the Project
Action fo ...
|
getting data from a main form to records in a subform
Thu, 11 Dec 2008 14:28:01 -0800
TIA:
I have an form with two tabs. One tab is a main form and the other tab is a
related subform. Data is entered into the main form. Some of this data
needs to be copied to one or two records in the related subform.
I would like to have a command button on the main form that would switch to
the subform ...
|
Go To Record with filter
Thu, 11 Dec 2008 13:29:00 -0800
tblBillets
Billet (PK) - Text with format XX-99,
frmBilletEdit
cboBillet with qry accessing tblBillets.
I want to find billets with only govt- in the primary key, but the message I
get is
The Microsoft Jet Database Engine does not recognize govt as a valid field
name or expression.
Any help ...
|
conditional format tab control pages
Thu, 11 Dec 2008 12:30:00 -0800
I have a form with a tab control which contains several subforms. I would
like to highlight the pages which contain data. I think I'll have to hide
any pages on which the subforms are blank. I know I need to test the
subforms, ie.
For each subform on mainform
If IsNull subform1 then
page0.visible = F ...
|
|
|
Updating all records
Thu, 11 Dec 2008 11:51:01 -0800
If I have a price calculation based on a complicated query with aggregate and
subqueries which uses the part ID on the input form as the filter for the
subqueries, the part price calculates fine, but if the material costs change
and I wish to do a "batch" update of the part prices I need to loop through
all ...
|
complie error:next without for
Thu, 11 Dec 2008 10:04:23 -0800
The following code gives me the next without for error. What is wrong?
Dim c As Control
If Not Me.NewRecord Then
For Each c In Me.Controls
If c.Tag = "Vehicle" Or c.Tag = "Outsourced" Then
If IsNull(c) Then
c.Visible = False
...
|
requery
Thu, 11 Dec 2008 09:05:01 -0800
I have subforms that add records. My problem is when I close the subform the
new record does not show until I move to another client and come back to the
original client. I know I have to do a requery of some kind, but I am at a
loss as to where to start. Thanks for any help. ...
|
