Post #62,879
11/14/02 2:35:53 PM
|
Nah...its trivial in Access too.
The Form Wizard can link to an existing table in a database.
So. Create your database....import your xl file into it...(file/get external data/import...name the table...etc...
Then in the database window click under Forms in the objects column...select "create form by using wizard"...and the first thing it does is give you a drop box to select the object you want to create the form from...in your case it would be the table you just created above.
Ez Pz.
You were born...and so you're free...so Happy Birthday! Laurie Anderson
[link|mailto:bepatient@aol.com|BePatient]
|
Post #63,079
11/15/02 2:40:32 PM
|
God, Beep! Bound Forms! Bleech!
Although for crap you don't care about maintaining, they're okay ;0)
|
Post #63,098
11/15/02 4:11:00 PM
|
It sounded like what he needed.
He didn't ask for pretty or maintainable.
You were born...and so you're free...so Happy Birthday! Laurie Anderson
[link|mailto:bepatient@aol.com|BePatient]
|
Post #63,099
11/15/02 4:12:47 PM
|
Understood.
It's just...well,... seeing Access bound forms actually recommended caused me to become faint... ;0)
|
Post #63,118
11/15/02 4:48:48 PM
|
Not knowing Access all that well...
...since I haven't used it for anything beyond toy projects (and even those done in VB3 rather than Access proper, IIRC) -- nor anything beyond version 2 or 3 or so -- I must ask: What's so especially horrible about "Access bound forms"?
At the risk of sounding like -- ahem -- Bryce, wouldn't you actually *want* your "small or mid-size business custom applications" to be "forms" (i.e, custom input/editing windows) that are more or less "bound" (in the sense of having a corresponding input/editing widget for [i.e, at least ultimately somehow related to] each particular field in some particular table) to a database/table?
In other words: Is this just another expression of your general aversion for "bound controls", Mike -- or, is it that Access does some excessively weird mangling of even that basic concept?
Just wondering
Christian R. Conrad Microsoft is a true reflection of Bill Gates' personality - the sleaziest, most unethical, ugliest little rat's ass the world has seen unto this time. -- [link|http://z.iwethey.org/forums/render/content/show?contentid=42971|Andrew Grygus]
|
Post #63,193
11/16/02 5:52:49 AM
|
The problem with Access.
... is thinking it's a full blown development environment. It's not quite. Plus good database design is fundamentally Hard and I've not seen Access make that any easier. (I rather doubt it possibly could.) These two can lead to some truly byzantine "applications".
Wade.
"Ah. One of the difficult questions."
|
Post #63,259
11/16/02 4:20:28 PM
|
nutshell: Access expects denormalization.
Anything "more complicated" (which, to the experienced developer, is actually less complicated), doesn't fit built-with-a-wizard-cut-n-paste forms.
Many fears are born of stupidity and ignorance - Which you should be feeding with rumour and generalisation. BOfH, 2002 "Episode" 10
|
Post #63,266
11/16/02 5:07:07 PM
11/16/02 5:11:06 PM
|
Access has some "special features"
I'm not talking about what you and I have discussed at length. ;-)
Access has some odd behavior if you use its "bound forms" for anything non-trivial. In Access, the form itself is bound to a table (or an "updatable query) and Access itself decides when the row is inserted, if it's inserted and on every third full moon (as best I can tell) if it is inserted properly. With bound forms you have VERY limited ability to control when the rows are written or when to bail on an insert (indeed in many cases you CANNOT stop a write even if you try to). And it is VERY cheesy. The built-in Access menus to mangle data can be turned off, but in many cases aren't. And then novices can do stuff like "docmd.MenuItem.Delete" in the wrong places - worse if done through wizards which produce code that would make you whince even harder than you already do looking at VB code.
I could go on from now until I die, but I'll give you better specifics only if you're interested. I don't like to think about this very much ;-)
In sum, Access makes it appear easy to do a database front end, but if you don't know how it really works, you can get your self in jail very easily.
Edited by mmoffitt
Nov. 16, 2002, 05:11:06 PM EST
|
Post #63,280
11/16/02 6:22:21 PM
|
Thanks, that's quite enough. On that other thing, though...
...I'll hafta get back at ya, 'coz I don't think we *quite* finished that.
Later, though. :-)
Christian R. Conrad Microsoft is a true reflection of Bill Gates' personality - the sleaziest, most unethical, ugliest little rat's ass the world has seen unto this time. -- [link|http://z.iwethey.org/forums/render/content/show?contentid=42971|Andrew Grygus]
|