RE: Error 2046 when using "OutputTo"
Fri, 12 Dec 2008 05:42:31 +0000 (UTC)
Hello muneca,
What version of Access are you using?
Thanks,
Bob Larson
Access MVP
> I'm having exactly the same problem and really need to know the
> solutions quickly.
>
> "RichardGarfield" wrote:
>
>> I am using 'OutputTo' to generate a report in snapshot format.
>>
>> It works perfectly whe ...
|
Window Focus
Thu, 11 Dec 2008 21:27:00 -0800
I've got an issue here that is driving me nuts. I have several databases
using a common library which has which defines many functions including
WaitSeconds, and ShowMessage. WaitSeconds was the first function written
which displays a modal form for the specified amount of seconds with a
message in a label c ...
|
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 ...
|
