Open A Specified Form In Another Database In Design View

Steve

Is there a way to programatically open a form named "MyForm" in another
Access database in design view and get various properties of the form?

Thanks!

Steve

Oct 8 '08 #1

Subscribe Reply

6428

fredg

On Wed, 8 Oct 2008 18:40:00 -0400, Steve wrote:

Is there a way to programatically open a form named "MyForm" in another
Access database in design view and get various properties of the form?

Thanks!

Steve

There is no need to post your question to more than 3 newsgroups!
Indeed, it's seldom necessary to post to more than one group.
I have truncated the groups to 3 in this reply.

Public Sub OpenForeignForm ()
' Run a form in design view located in a different database
Dim appAccess As Access.Applicat ion
Dim strValue1 As String
Dim strValue2 As String
Set appAccess = CreateObject("A ccess.Applicati on")
appAccess.OpenC urrentDatabase "C:\My Household\HomeM aint.mdb"
appAccess.DoCmd .OpenForm "frmMaintai n", acDesign

strValue1 = appAccess.Forms !frmMaintain.Re cordSource
strValue2 = appAccess.Forms !frmMaintain.Fi lter

MsgBox "RecordSour ce is " & strValue1 & vbNewLine & "Form
Filter is " & strValue2
appAccess.Quit
Set appAccess = Nothing

End Sub
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Oct 8 '08 #2

Keith Wilby

"Steve" <no******@nomse nse.comwrote in message
news:ef******** *************** *******@earthli nk.com...

Is there a way to programatically open a form named "MyForm" in another
Access database in design view and get various properties of the form?

Yes.

Oct 9 '08 #3

Lord Kelvan

yeah

add the code

docmd.openform "myform"

to whatever control you want to open the form

hope this helps

Regards
Kelvan

Oct 9 '08 #4

Keith Wilby

"Lord Kelvan" <th********@hot mail.comwrote in message
news:b1******** *************** ***********@v39 g2000pro.google groups.com...

yeah

add the code

docmd.openform "myform"

to whatever control you want to open the form

hope this helps

Regards
Kelvan

Or just ask PC Datasheet, he's so great that you can go to him if no one
here can help and his fees and quite modest ;-)

Oct 10 '08 #5

fredg

On Fri, 10 Oct 2008 08:40:37 +0100, Keith Wilby wrote:

"Lord Kelvan" <th********@hot mail.comwrote in message
news:b1******** *************** ***********@v39 g2000pro.google groups.com...
>yeah

add the code

docmd.openfo rm "myform"

to whatever control you want to open the form

hope this helps

Regards
Kelvan

Or just ask PC Datasheet, he's so great that you can go to him if no one
here can help and his fees and quite modest ;-)

Keith, did I miss something here?
Is this Steve that Steve?

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Oct 10 '08 #6

Keith Wilby

"fredg" <fg******@examp le.invalidwrote in message
news:vj******** *************** *****@40tude.ne t...

On Fri, 10 Oct 2008 08:40:37 +0100, Keith Wilby wrote:
Keith, did I miss something here?
Is this Steve that Steve?

Hi Fred,

The evidence "no******@nomse nse.com" to me suggests that he is.

Oct 13 '08 #7

Similar topics

2021

Design view of a form missing

by: Peter Royle | last post by:

I am working with VB.NET. It has just started losing my design view of a form when I open a project. If the design view was open when I last closed it, the view is there, but the Solution Explorer doesn't give a tab for it, and the form in the Solution Explorer just shows as a .vb file, not as a form icon. To fix it, I have to remove the file from the project, then re-add it. And once it's gone wrong, it seems to keep going wrong. Also, it...

.NET Framework

332

form size in design view

by: Eva | last post by:

Hi, i have placed code on my form load event to maximise the form. what i want to know is when im working in design view is there a way to display the actual size of the form?? i ask this because i want to be able to clealy see where i place my controls on the form and how they will actually be displayed when the application is loaded.

.NET Framework

4532

Need to Open Database from another Database and delete table within

by: I Are Confused | last post by:

I am trying to open Database #2 while in Database #1 and delete a table that is in #2 so that I can copy a table from #1 into #2 - all through a function. My Database #2, as part of the start up, opens a form for user sign in. It is not starting up with autoexec. I do not want the function to open the window and subsequently open the form in Database #2. Is there anyway to get around this? If I put the open form in the autoexec and...

Microsoft Access / VBA

3722

how to change the form size in Design view

by: Sylvia S. | last post by:

Hello, I want to make a form based on a table with many records. I used the wizard to make a 'form in table layout'. The wizard is not able to make the form due to too many fields. I discovered that the standard form properties gives a maximum form width of 55.873cm (22 inch). How do I change this width and enlarge it to e.g. 70cm so the wizard will be able to make the form? Thanks for your help, Sylvia

Microsoft Access / VBA

2440

caption value problem in design view

by: Paul T. Rong | last post by:

Hello, Often when I open one form, and (without closing it) open the form in its design view, then all the caption value of the controls in this form remained there in form's design view that is what I don't want. I wish the caption value to be "". What can I do? what is the form event from form view to design view? Thanks in advance,

Microsoft Access / VBA

4029

Iterate through controls on form in design view...

by: Jan Nielsen | last post by:

Hi In Microsoft Access it is possible to write code like this Sub test() DoCmd.OpenForm "TestForm", acDesign Dim a As Control For Each a In Forms("TestForm").Controls Do stuff Next End Sub

Visual Basic .NET

2879

Difficulty displaying graph in Form View that I see fine in graph control on form opened in design view

by: MLH | last post by:

A97 Am having difficulty displaying graph in Form View that I see fine in graph control on form opened in design view. I know I'm doing something wrong. If I open the form in design view - I see the graph in the graph control. If I dbl-clik the graph control, microsoft graph opens and displays the graph fine there too.

Microsoft Access / VBA

5353

Link form another database table into current database

by: colleen1980 | last post by:

I copy a form from another database into my database. I need help how to i link the table which is in another database with that form. Thank you.

Microsoft Access / VBA

9839

Query Design View is Slow to Open

by: existential.philosophy | last post by:

This is a new problem for me: I have some queries that open very slowly in design view. My benchmark query takes about 20 minutes to open in design view. That same query takes about 20 minutes to open in datasheet view. As an experiment, I deleted all rows in all tables; after that, the query took only seconds to open in both design view and datasheet view. From these facts, I conclude that Access is evaluating the query when I go to...

Microsoft Access / VBA

1424

How to open a form when database is opened based on a field value?

by: Ryno Bower | last post by:

Hey guys. I'm writing a program and want to do the following. I have a form for the company details called "companydetails". So when I open the database I want the form to display first if the "companyname" fiel is empty. After filling in the form and clicked on "create" then it must take me to another form called "employeeentry" so that the first employee can be created. After all is done the databse shoul close and reopen and then display...

Microsoft Access / VBA

8600

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9155

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9018

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8890

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8858

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7711

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

4360

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4614

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3038

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp