Programatically (VB) copy forms from one db to another

Desperado

unread,

Apr 13, 2007, 1:24:02 PM4/13/07

to

It is possible to programatically copy a form from one database to another
using Visual Basic?

I would like to update the forms in a front end user database on a network
each time the user logs in.
--
Desperado

Susie DBA [MSFT]

unread,

Apr 13, 2007, 2:20:19 PM4/13/07

to

uh use my automagic auto-fe updater

it's called 'Access Data Projects' and you don't have to worry about
bloated frontends; you can run them across the network (keep them all
in one place)

it works like a charm

MDB is a crutch

On Apr 13, 10:24 am, Desperado <Desper...@discussions.microsoft.com>
wrote:

Vladimír Cvajniga

unread,

Apr 13, 2007, 3:32:29 PM4/13/07

to

1) IMO, u could use CopyObject method in VBA, see Access help.
2) Instead of copying objects why don't you simply copy full FE MDB to
client's machine?

Vlado

"Desperado" <Desp...@discussions.microsoft.com> píše v diskusním příspěvku
news:E4785842-9466-4E8C...@microsoft.com...

Douglas J. Steele

unread,

Apr 13, 2007, 3:48:57 PM4/13/07

to

As Vladimir states, it's usually far better simply to replace the user's
front-end, rather than futzing around trying to ensure it has the most
recent version of each object.

Take a look at the free Auto FE Updater Tony Toews has at
http://www.granite.ab.ca/access/autofe.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"Desperado" <Desp...@discussions.microsoft.com> wrote in message
news:E4785842-9466-4E8C...@microsoft.com...

Tony Toews [MVP]

unread,

Apr 13, 2007, 8:54:53 PM4/13/07

to

Text that A a r o n K e m p f wrote snipped.

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

Jerry Petron

unread,

Apr 16, 2007, 7:54:01 AM4/16/07

to

I am puzzled why I have been identified as Aaron Kempf. But, I am new to this
kind of thing (actively participating in on-line discussion).

Anyway, I assure you, my inquery is genuine.

Is there some way to copy forms from one database to another using Visual
Basic?
--
Jerry

Douglas J. Steele

unread,

Apr 16, 2007, 8:31:19 AM4/16/07

to

Aaron's posts are not shown through Microsoft's web interface to these
newsgroups. Tony's simply replying to let people know that the reply from
"Susie DBA" is, in fact, a reply from Aaron.

If you're really curious, check
http://groups.google.com/group/microsoft.public.access/browse_thread/thread/3fe87ac96c2b5ca7/d94983e2b218eb9b?lnk=st&q=&rnum=1#d94983e2b218eb9b
to see all of the responses your post has received.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"Jerry Petron" <Jerry...@discussions.microsoft.com> wrote in message
news:1C5D510B-D882-484E...@microsoft.com...

Jerry Petron

unread,

Apr 16, 2007, 11:56:01 AM4/16/07

to

Tony Toews [MVP]

unread,

Apr 16, 2007, 1:07:35 PM4/16/07

to

Jerry Petron <Jerry...@discussions.microsoft.com> wrote:

>I am puzzled why I have been identified as Aaron Kempf. But, I am new to this
>kind of thing (actively participating in on-line discussion).

I apologize. From your perspective that was quite misleading. I'll have to figure
out a better appraoch.