beforeDelConfirm and afterDelConfirm events not firing

[dbahooker]

binding forms to sprocs in ADP is about 100 times easier than using MDB

if your sproc is looking for parameter named.. just for example
'@txtPLU' you have a text field named txtPLU and it 'automagically'
binds.

no code.
no updating sql passthroughs.

no horsing around.

 

[dbahooker]

much wider skillset

SHIT

i seriously don't get your argument there..

you're seriously claiming that KNOWING TWO DIALECTS OF SQL IS EASIER
THAN ONE?

and you're bitching when I say 'focus on sql and **** MDB in the mouth'

I mean.. do you know HOW TO COUNT?

ONE is LESS than TWO last time I checked

 

[Mark]

You do make me laugh...

The documents are created in code. We don't create documents that pull data,
we create applications that push documents.

As for Excel... Agreed (at last ;o) I would not use it where formatting was
a major issue, we use it where further anallysis etc. might need to be
carried out by the user... Generally we use whatever is most appropriate for
the job...

 

[Mark]

Like I said before, you must have a simple environment. My lot expect a
report to be a live model they can chop and change depending on the
requirements of the day. Access reports are static (not taking into account
pivots etc. which originated in Excel). Our users are able to do what they
want without having to constantly request new report templates etc. etc.
etc.

 

[aaron.kempf]

specs?

what you write specs in WORD or something.. right?

THATS THE ROOT OF THE PROBLEM RIGHT THERE.
keep your SPECS in a database not in documents.

KEEP DATA IN A DATABASE AND YOU CAN AUTOMATE THINGS QUITE EASILY

I've worked on hundreds of databases over the years
Im not scared by your 'super duper complex specs'

I do use .NET in some places; mainly console apps.. nothign too
exciting.

I dont do much development though; im a DB developer not a frontend
developer and Im pretty good at what I do.

I just know that Access Data Projects is a faster simpler development
environment than anything else on the market. When it's appropriate; I
use ASP or .NET; but I dont think that it's practical to develop most
apps in .NET.

You're the one that cant even figure out how to bind a single
parameter?

ROFL

oh so you just use ADO connections; yeah I think that using unbound
stuff in Access is pretty much pointless...

let me guess.. you use SQL authentication also; since that dastardly NT
authentication; you can't get it to hop??

ROFL

 

[aaron.kempf]

yeah I use the most appropriate tool also.

you can get your model T in any color you want; as long as it's black

 

[Mark]

Wow mate... Why would they be trying to edit a report in Word or Excel? I
think you got the wrong end of the stick (or mayber the wrong stick even).

Actually, by the way, the office web components do have a row limit (I can't
remember what it is but I hit it a year or so ago on a charting project
which pulled data from OPC servers, the work-araound was to generate an
Excel document. Also, the latest Excel format offers more than a million
rows. Not bad, but not infinte either...

 

[Mark]

Oh bless you ) Are your hormones playing you up or something?

The only difference between an ADP/ADE and MDB/MDE is the connectivity. The
VBA's the same, so's the forms designer etc.

Can you create a bound form in an ADP without granting permissions on tables
or using views? Granted, there may well be more work using a disconnected
mde frontend with ADO etc. but sometimes you have to go a little further to
get the quality necessary for the job and environment.

 

[Mark]

Actually we use Winddows authentication only. I'm really not sure why you
think so much of this is difficult.

As for the specs, we operate in a heavilly regulated environment. The format
and processes for producing specs (URS's, FDS's, UAT protocols etc.) is
dictated by a regulatory framework so it's simply a matter of doing whats
asked for, like it or lump it...

 

[Mark]

Don't you use any VBA then?

As for using two dialects of SQL, I don't find switching a problem myself.
BUT, I just re-read my earlier post (wider skill-set etc.), it does seem I
was talking rubbish there. Must have been late...

 

[Mark]

But don't you find the bound forms a little sluggish?

 

[jaydeflix]

I dont think that you should talk shit about me or DbaHooker.. we both
could step on you like a bug

'we both'?

You're the same person!!!!

Tell you what, I'll talk all the shit about you I want and if you
'both' would like to meet me, let me know where and when.

 

[aaron.kempf]

anytime MDB pansie

'we both'?

You're the same person!!!!

Tell you what, I'll talk all the shit about you I want and if you
'both' would like to meet me, let me know where and when.