access question / forms

Nick J

Hi,

I would like to have a command button on Form 1 that opens another form
(Form 2), then closes Form 1.

I tried the DoCmd.close after the open form code but it closes the form its
trying to open.

--

Kind Regards...

Customer Services Team
Blue Bell Trading

+++ WHEN REPLYING PLEASE DO NOT DELETE ANY OF THE TEXT AS WE NEED IT FOR
REFERENCE +++

Blue Bell Trading

Nov 13 '05 #1

Subscribe Post Reply

1194

Rick Brandt

Nick J wrote:

Hi,

I would like to have a command button on Form 1 that opens another
form (Form 2), then closes Form 1.

I tried the DoCmd.close after the open form code but it closes the
form its trying to open.

Either close Form1 first (the other lines of code will still execute) or
explicitly name the form you want to close in the DoCmd.Close method. By
default it closes the currently "active" object, but you can specify which
object to close.

DoCmd.Close acForm "FormName"

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #2

fredg

On Tue, 12 Apr 2005 13:50:44 GMT, Nick J wrote:

Hi,

I would like to have a command button on Form 1 that opens another form
(Form 2), then closes Form 1.

I tried the DoCmd.close after the open form code but it closes the form its
trying to open.

DoCmd.OpenForm "Form2"
DoCmd.Close acForm, Me.Name
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Nov 13 '05 #3

Nick J

Thank You.

--

Kind Regards...

Customer Services Team
Blue Bell Trading

+++ WHEN REPLYING PLEASE DO NOT DELETE ANY OF THE TEXT AS WE NEED IT FOR
REFERENCE +++

Blue Bell Trading
"fredg" <fg******@example.invalid> wrote in message
news:1p****************************@40tude.net...

On Tue, 12 Apr 2005 13:50:44 GMT, Nick J wrote:
Hi,

I would like to have a command button on Form 1 that opens another form
(Form 2), then closes Form 1.

I tried the DoCmd.close after the open form code but it closes the form
its
trying to open.

DoCmd.OpenForm "Form2"
DoCmd.Close acForm, Me.Name
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Nov 13 '05 #4

by: J | last post by:

Hi, Ive got 3 forms, (a subform within a subform within a form) and when I refresh the outermost form, Access closes and offers to send an error report. The forms worked fine a few weeks ago,...

Microsoft Access / VBA

Disadvantage of Access as front-end

by: Yannick Turgeon | last post by:

Hello, We are in the process of examining our current main application. We have to do some major changes and, in the process, are questionning/validating the use of MS Access as front-end. The...

Microsoft Access / VBA

Questions about Access from a .NET/C++ developer

by: Olav.NET | last post by:

I am a .NET/C++ developer who is supposed to do some work with Access. I do not know much about it except for the DB part. Questions: *1* I am looking for INTENSIVE books to get quickly up to...

Microsoft Access / VBA

how to get from an MS Access app to vb.net?

by: Deano | last post by:

Hi, I have a finished Microsoft Access app that we are distributing using an Access runtime. This works fine (mostly) but I'm sold on the advantages of dot.NET and upgrading to vb.NET seems...

Visual Basic .NET

VS.Net Win Forms app - cannot access SQLServer with one computer

by: dbuchanan | last post by:

I have a Windows Forms application that accesses SQL Server 2k from a small local network. The application has been used for weeks on other systmes but a new install on a new machine retruns...

Visual Basic .NET

.NET Windows Forms Application VS MS Access client Application

by: Jordan S. | last post by:

SQL Server will be used as the back-end database to a non trivial client application. In question is the choice of client application: I need to be able to speak intelligently about when one...

.NET Framework

My ritual question for each new version of Access since 2000

by: Mathieu Trentesaux | last post by:

Hello I downloaded Office 2007 for this reason : It seems, once again, that it is impossible to save any modification done in a VBA library, from the main project in Access. The save button...

Microsoft Access / VBA

Electronic Forms software that integrates well with Access

by: Bob Alston | last post by:

I am looking for electronic forms software that would integrate well with MS Access. I have a client for whom I built a client database to replace and update one they had that was obsolete and...

Microsoft Access / VBA

Plugging an alternate data source into MS-Access

by: Chad | last post by:

Hi Is it possible to substitute an alternative data source (eg MySQL or SQL Server) into an existing MS-Access application?

Microsoft Access / VBA

vstudio data access problems

by: Wesley Peace | last post by:

I hate to cross post, but I've gotten no answer yet on a problem I'm having with visual studio 2008. I've created a series of forms with controls to access a Access database tables. The...

C# / C Sharp

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Similar topics