![]() |
CreateQueries2.mdb (intermediate) |
Post Reply ![]() |
Author | |
Roger Carlson ![]() Microsoft MVP ![]() Joined: 20 Feb 2008 Status: Offline Points: 261 |
![]() ![]() ![]() ![]() ![]() Posted: 01 Aug 2008 at 6:32am |
Please consider donating $1 per sample downloaded, find out why here.
CreateQueries2.mdb This database illustrates several examples of programmatically creating queries.
Form 2: Creates a simple Select query called "qryMyQuery" based on the table GLTable. It uses two criteria and allows you to choose the logical operators "AND" or "OR". Form2a: Does the same as Form2, but has three criteria. Form3: Allows you to choose the comparison operators (=, >, Like, etc), the values from combo boxes, and the Logical operator between two criteria. Form 4: A more flexible version of Form3 with three criteria. Criterias 2 and 3 only become active if a logical operator is chosen. A more complete version of this is in the file CreateQueries4.mdb. Form 5: Changes the criteria for a report. Form 6: Uses a multi-select list box |
|
|
|
![]() |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
![]() |
Post Reply ![]() |
|
Tweet
|
Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |