Hi All

I have finally finished my masterpiece, a costomer and call record database
with 10 linked tables, forms and reports galore.

I have a nifty little Switchboard and it all looks lovely, data is added
using a form which has sub-forms opening from it (by buttons) so when you are
finished, all the relevant forms are complete and beautifully related.

So I'm sitting back calmly telling the boss I have just saved the company
from a life of post-it notes when he drops a bombshell...

"But we need our remote users to access, input and retrieve all this, can
you make it work over the web???"

Ah ha in therory yes.... but thats where my very limited experience grinds
to a juddering halt...

I have played repeatedly with the DAP wizard, and can create a single DAP
that works but cannot link them together?

The database has a contact table and form, but i also have seperate forms
for addresses, specialities, secretaries, calls, all interlinked. So for
example in the contacts form if the secretary isn't already listed click the
add secretary button, new form pops up and i put in the details, if her
address isn't listed click new address button new form pops up etc etc.

In the normal forms this works a treat but, I cannot for the life of me work
out how to get the same effect from DAPs

Please please help me I've dug a hole for myself by offering to do this
database, (not my job what-so-ever I'm a sales rep!!) but now I gotta finish
it before I either
a) Go Mad
b) Get Sacked
c) Consider Ending it all
D) all of the above

I want to have a working example on my laptop for the time being, so I'm not
worried about uploading it all just yet, (the tech guys can do that onto the
secure server once it all works when it's in the same place)

Thanks in advance everyone

Benn

--
Access is like walking under a flock of pigeons, you never know which bit
will **** on you next!

On Mar 21, 2:57 pm, Benn <B...@discussions.microsoft.com> wrote:
> Hi All
>
> I have finally finished my masterpiece, a costomer and call record database
> with 10 linked tables, forms and reports galore.
>
> I have a nifty little Switchboard and it all looks lovely, data is added
> using a form which has sub-forms opening from it (by buttons) so when you are
> finished, all the relevant forms are complete and beautifully related.
>
> So I'm sitting back calmly telling the boss I have just saved the company
> from a life of post-it notes when he drops a bombshell...
>
> "But we need our remote users to access, input and retrieve all this, can
> you make it work over the web???"
>
> Ah ha in therory yes.... but thats where my very limited experience grinds
> to a juddering halt...
>
> I have played repeatedly with the DAP wizard, and can create a single DAP
> that works but cannot link them together?
>
> The database has a contact table and form, but i also have seperate forms
> for addresses, specialities, secretaries, calls, all interlinked. So for
> example in the contacts form if the secretary isn't already listed click the
> add secretary button, new form pops up and i put in the details, if her
> address isn't listed click new address button new form pops up etc etc.
>
> In the normal forms this works a treat but, I cannot for the life of me work
> out how to get the same effect from DAPs
>
> Please please help me I've dug a hole for myself by offering to do this
> database, (not my job what-so-ever I'm a sales rep!!) but now I gotta finish
> it before I either
> a) Go Mad
> b) Get Sacked
> c) Consider Ending it all
> D) all of the above
>
> I want to have a working example on my laptop for the time being, so I'm not
> worried about uploading it all just yet, (the tech guys can do that onto the
> secure server once it all works when it's in the same place)
>
> Thanks in advance everyone
>
> Benn
>
> --
> Access is like walking under a flock of pigeons, you never know which bit
> will **** on you next!

the problem you may run into is that VBA is more flexible in some ways
than HTML. I suppose if you knew how to write ASP.NET code, you'd be
okay, but it's not as simple as MS would have you believe. Do you
have any other options? (You can use Citrix or Terminal Services to
host the application...) Front Page will do some of this for you, but
I haven't used it very much and not in a long time... So take what I
say with a grain of salt...

DAP are actually extremely powerful

if I were you; I would look for an Office XP components demonstration
from MIcrosoft; you should be able to download it

I wish I remembered more about the name of it.. but i'm pretty damn
sure you want to look for 'Office Web Components' and XP not 2000 or
2003

hope that helps; I _LOVE_ OWC bro

(DAP = HTML + OWC)


On Mar 21, 12:57 pm, Benn <B...@discussions.microsoft.com> wrote:
> Hi All
>
> I have finally finished my masterpiece, a costomer and call record database
> with 10 linked tables, forms and reports galore.
>
> I have a nifty little Switchboard and it all looks lovely, data is added
> using a form which has sub-forms opening from it (by buttons) so when you are
> finished, all the relevant forms are complete and beautifully related.
>
> So I'm sitting back calmly telling the boss I have just saved the company
> from a life of post-it notes when he drops a bombshell...
>
> "But we need our remote users to access, input and retrieve all this, can
> you make it work over the web???"
>
> Ah ha in therory yes.... but thats where my very limited experience grinds
> to a juddering halt...
>
> I have played repeatedly with the DAP wizard, and can create a single DAP
> that works but cannot link them together?
>
> The database has a contact table and form, but i also have seperate forms
> for addresses, specialities, secretaries, calls, all interlinked. So for
> example in the contacts form if the secretary isn't already listed click the
> add secretary button, new form pops up and i put in the details, if her
> address isn't listed click new address button new form pops up etc etc.
>
> In the normal forms this works a treat but, I cannot for the life of me work
> out how to get the same effect from DAPs
>
> Please please help me I've dug a hole for myself by offering to do this
> database, (not my job what-so-ever I'm a sales rep!!) but now I gotta finish
> it before I either
> a) Go Mad
> b) Get Sacked
> c) Consider Ending it all
> D) all of the above
>
> I want to have a working example on my laptop for the time being, so I'm not
> worried about uploading it all just yet, (the tech guys can do that onto the
> secure server once it all works when it's in the same place)
>
> Thanks in advance everyone
>
> Benn
>
> --
> Access is like walking under a flock of pigeons, you never know which bit
> will **** on you next!

and you know that you can put multiple DAPs on one page right?

that's the route I would go

or.. this

a) use ASP to display data
b) use DAP to enter it

Dreamweaver is the best tool for writing ASP; MS doesn't have a clue
when it comes to web dev




On Mar 21, 12:57 pm, Benn <B...@discussions.microsoft.com> wrote:
> Hi All
>
> I have finally finished my masterpiece, a costomer and call record database
> with 10 linked tables, forms and reports galore.
>
> I have a nifty little Switchboard and it all looks lovely, data is added
> using a form which has sub-forms opening from it (by buttons) so when you are
> finished, all the relevant forms are complete and beautifully related.
>
> So I'm sitting back calmly telling the boss I have just saved the company
> from a life of post-it notes when he drops a bombshell...
>
> "But we need our remote users to access, input and retrieve all this, can
> you make it work over the web???"
>
> Ah ha in therory yes.... but thats where my very limited experience grinds
> to a juddering halt...
>
> I have played repeatedly with the DAP wizard, and can create a single DAP
> that works but cannot link them together?
>
> The database has a contact table and form, but i also have seperate forms
> for addresses, specialities, secretaries, calls, all interlinked. So for
> example in the contacts form if the secretary isn't already listed click the
> add secretary button, new form pops up and i put in the details, if her
> address isn't listed click new address button new form pops up etc etc.
>
> In the normal forms this works a treat but, I cannot for the life of me work
> out how to get the same effect from DAPs
>
> Please please help me I've dug a hole for myself by offering to do this
> database, (not my job what-so-ever I'm a sales rep!!) but now I gotta finish
> it before I either
> a) Go Mad
> b) Get Sacked
> c) Consider Ending it all
> D) all of the above
>
> I want to have a working example on my laptop for the time being, so I'm not
> worried about uploading it all just yet, (the tech guys can do that onto the
> secure server once it all works when it's in the same place)
>
> Thanks in advance everyone
>
> Benn
>
> --
> Access is like walking under a flock of pigeons, you never know which bit
> will **** on you next!

"Todos Menos [MSFT]" <(E-Mail Removed)> wrote:

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Note Tony is not a credible source, he is a MDB _WUSS_


On Mar 21, 6:55 pm, "Tony Toews [MVP]" <tto...@telusplanet.net> wrote:
> "Todos Menos [MSFT]" <todos_menos_m...@hotmail.com> wrote:
>
> Note that this person is really A a r o n K e m p f and that he is not an employee
> of Microsoft.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm