Re: Template form for CreateForm

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Marie (anonymous_at_discussions.microsoft.com)
Date: 11/29/04 

Date: Mon, 29 Nov 2004 14:49:02 -0800

John,

That actually works. Good idea.

Two more questions:
1. How do I delete a form in MyDB from code in DB1?
2. How do I "send to back" on a control from VBA? - It is
normally done with the edit menu.

Marie

>-----Original Message-----
>Hi Marie,
>
>Why not just use DoCmd.TransferDatabase (in DB1) to copy
the "template"
>form from DB1 to MyDB?
>
>On Mon, 29 Nov 2004 08:02:43 -0800, "Marie"
><anonymous@discussions.microsoft.com> wrote:
>
>>I have a database DB1 that creates a form in another
>>database MyDB (like a wizard).
>>
>>I use the following code
>>
>> Dim AppAcc As New Access.Application
>> AppAcc.OpenCurrentDatabase "C:\MyDB.mdb"
>> AppAcc.CreateForm , "FMmaster"
>>
>>FMmaster is a form in DB1 with size and other properties
>>set to match the use.
>>
>>But it doesn't work. I can create a form in MyDB - but
it
>>is not based om FMmaster.
>>
>>What is wrong?
>>
>>I have also tried to have the master in MyDB - but that
>>didn't work either.
>
>--
>John Nurick [Microsoft Access MVP]
>
>Please respond in the newgroup and not by email.
>.
>

Relevant Pages

  • Re: Template form for CreateForm
    ... I never try to do this sort of thing so am guessing, but presume that it ... How do I delete a form in MyDB from code in DB1? ... >>Please respond in the newgroup and not by email. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Template form for CreateForm
    ... form from DB1 to MyDB? ... >database MyDB. ... > Dim AppAcc As New Access.Application ... >is not based om FMmaster. ...
    (microsoft.public.access.modulesdaovba)
  • Template form for CreateForm
    ... I have a database DB1 that creates a form in another ... database MyDB (like a wizard). ... FMmaster is a form in DB1 with size and other properties ... I can create a form in MyDB - but it ...
    (microsoft.public.access.modulesdaovba)
  • Re: Cannot save a file - button is shaded
    ... I have just tried in A2000 to do just what you did; I do a File - New, it makes a database db1 in the default location, and brings me to the database window. ... The same happens when I go to table design - I create a sample table, save it at the prompt when exiting the table design, and the Save Button is dimmed. ... It's only active when there are unsaved changes. ...
    (microsoft.public.access.setupconfig)
  • Re: sql server 2008 db ownership question
    ... Add User1 to be member of sysadmin role and then ... In my SQL Server 2008, there is a database DB1 which is a database restore ...
    (microsoft.public.sqlserver.server)