Need Help with Forms

[Guest]

Hello,
I'm having issue with a form list box to retrieve query or reports. I need
help in the correct program or macro that will do that?

Below is what I recieve after attempting the process.

"Procedure declaration does not match description of event or procedure have
event same name!"

Action Fail
Macro Name:
Royalty Result Reporting Ist.Minisoft: On Dbl Click

Condition:
True

Action Name:
Open Query

Argument:
=[Form]![Switch Board Royalty]![Vendor]

Help!!!

Johnson II Johnson ESG Inc.
543 Nor Raymond Ave
626-578-1595 or
626-399-1889

 

[Guest]

well - not sure based on your description....

I see a macro - but with an unusually long name

I see "dblclick" but not sure what is being clicked...

I see open query....but not sure which query...and the query is seeking a
parameter value from the form (ie. argument)

did this ever work? if so - what has changed. if not then should review
better the fundamental need.....

 

[Guest]

No, Never Work at all, give me a better overview how it would work.

Jeffrey Johnson ESG

--
Johnson II Johnson ESG Inc.

well - not sure based on your description....

I see a macro - but with an unusually long name

I see "dblclick" but not sure what is being clicked...

I see open query....but not sure which query...and the query is seeking a
parameter value from the form (ie. argument)

did this ever work? if so - what has changed. if not then should review
better the fundamental need.....
--
NTC

Hello,
I'm having issue with a form list box to retrieve query or reports. I need
help in the correct program or macro that will do that?

Below is what I recieve after attempting the process.

"Procedure declaration does not match description of event or procedure have
event same name!"

Action Fail
Macro Name:
Royalty Result Reporting Ist.Minisoft: On Dbl Click

Condition:
True

Action Name:
Open Query

Argument:
=[Form]![Switch Board Royalty]![Vendor]

Help!!!

Johnson II Johnson ESG Inc.
543 Nor Raymond Ave
626-578-1595 or
626-399-1889

 

[Guest]

it would seem like the chain of events is to be:

1. selection of list box
2. 'After Update' property of listbox triggers Macro
3. Macro triggers opening of query
4. In the criteria field of the query is reference to the value of the
listbox selected

I would suggest to test 4 separately using a test temporary text
box....making sure that you can enter/type in a known good value.....and
while the form is still open (this is important) - then manually open the
query and see if the criteria from the form is working right...

Once you get that correct - would then do it via the list box rather than a
test text box....

After that all you need to do is set up the macro and link it to the
AfterUpdate event...
--
NTC

No, Never Work at all, give me a better overview how it would work.

Jeffrey Johnson ESG

--
Johnson II Johnson ESG Inc.

well - not sure based on your description....

I see a macro - but with an unusually long name

I see "dblclick" but not sure what is being clicked...

I see open query....but not sure which query...and the query is seeking a
parameter value from the form (ie. argument)

did this ever work? if so - what has changed. if not then should review
better the fundamental need.....
--
NTC

Hello,
I'm having issue with a form list box to retrieve query or reports. I need
help in the correct program or macro that will do that?

Below is what I recieve after attempting the process.

"Procedure declaration does not match description of event or procedure have
event same name!"

Action Fail
Macro Name:
Royalty Result Reporting Ist.Minisoft: On Dbl Click

Condition:
True

Action Name:
Open Query

Argument:
=[Form]![Switch Board Royalty]![Vendor]

Help!!!

Johnson II Johnson ESG Inc.
543 Nor Raymond Ave
626-578-1595 or
626-399-1889