Programatically (VB) copy forms from one db to another

[Guest]

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.

 

[Susie DBA [MSFT]]

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

 

[Guest]

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

 

[Douglas J. Steele]

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

 

[Tony Toews [MVP]]

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

 

[Guest]

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?

 

[Douglas J. Steele]

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/micr...3e2b218eb9b?lnk=st&q=&rnum=1#d94983e2b218eb9b
to see all of the responses your post has received.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

 

[Guest]

Thanks, Douglas.
It looks like there is a solution very worth looking into.
Auto FE Updater.
http://www.granite.ab.ca/access/autofe.htm
Website copyright © 1995-2007 Granite Consulting

 

[Tony Toews [MVP]]

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.

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