G
Guest
I have established a “Query†file in Microsoft ACCESS with the following SQL
syntax:
Select sum(pricepack)
From orders
Where Lastn = ‘smith’
The aforesaid “Query†file is linked to “FORM†view file.
If I wanted the “user†to use a “pop-up†menu in the FORM VIEW file to place
a “new†last name in the aforesaid SQL syntax “linked†“QUERY†file, what
would be the “keystroke-to-keystroke†and “cursor-to-cursor†syntax for an
“event procedure†in the “FORM†view for a “pop-up†menu so a user could
place a new last name in the aforesaid SQL syntax? (NOTE: If you right click
the properties in FORM VIEW, and then access the “event†menu, it appears you
should be able to select an event procedure for a “pop-up†menu.) What would
be the associated code for the expression for the aforesaid event procedure?
Please provide a keystroke-to-keystroke syntax procedure for the aforesaid
event procedure code.
syntax:
Select sum(pricepack)
From orders
Where Lastn = ‘smith’
The aforesaid “Query†file is linked to “FORM†view file.
If I wanted the “user†to use a “pop-up†menu in the FORM VIEW file to place
a “new†last name in the aforesaid SQL syntax “linked†“QUERY†file, what
would be the “keystroke-to-keystroke†and “cursor-to-cursor†syntax for an
“event procedure†in the “FORM†view for a “pop-up†menu so a user could
place a new last name in the aforesaid SQL syntax? (NOTE: If you right click
the properties in FORM VIEW, and then access the “event†menu, it appears you
should be able to select an event procedure for a “pop-up†menu.) What would
be the associated code for the expression for the aforesaid event procedure?
Please provide a keystroke-to-keystroke syntax procedure for the aforesaid
event procedure code.