?

Log in

No account? Create an account

Previous Entry | Next Entry

For most of you, this post will be gobbledygook.


Really?
      You want to read this?
            Okay...


So, I created a Form in Access, with two drop-down lists and a Submit button.

The drop-down lists are each unbound, but populated by the results of a SQL-Passthrough query to the new database on SQL Server 2000.

Pressing the Submit button drops down to VBA, where a SQL query string is generated based on your selections.

VBA then deletes and rebuilds the stored query I cleverly named "Temporary Recordset", complete with DAO connection string. This gives you a new SQL-Passthrough query in it's place based on the query string based on your selections.

It should be noted that the SQL-Passthrough itself is activating a User Defined Function on the SQL server, thus masking several layers of nested queries which are used to create the result set it returns.

Then, VBA launches a nicely formatted report whose record source is a temporary query linking "temporary recordset" to one of our pre-existing tables.

Very simple front-end. Truly frightening back-end. Perhaps the scariest part being that it actually works. This is held together with duct-tape, at best.


Anyway, that's just the template. When the company knows for sure what reports they're going to need, someone will have to modify this to create them. And it's not gonna be me. I'll just be the guy they curse under their breath as they try to make sense of my documentation.

Comments

( 3 comments — Leave a comment )
akatalin
Aug. 7th, 2003 02:51 am (UTC)
grrr
I keep on and off keep playing that damn kickie thing .... the highest I got is 23 and now I havne't been able to get pass 13 since I got that ......
just thought ot mention this to you
self
Aug. 7th, 2003 10:34 am (UTC)
aargh.
Yeah, I probably should have mentioned back here how addictive that game is.

That and Dynomite...
akatalin
Aug. 7th, 2003 11:09 pm (UTC)
::smacks head::
you are mean ..... I am already addicted to Alchemy and I keep going back to the kicking one ... grrrrrrrrrrrrrrrrr lol

( 3 comments — Leave a comment )

Profile

self portrait (escher)
self
some guy

Latest Month

October 2014
S M T W T F S
   1234
567891011
12131415161718
19202122232425
262728293031 

Page Summary

Powered by LiveJournal.com
Designed by Tiffany Chow