Synchronise - Microsoft Access / VBA

Background about me. I am a total beginner with access and have no knowledge of programing.

The problem I am having in access is to be able to Synchronise a main form and a subform.
The program is a model database. when i select a specific model and open a subform (there are a few) that sub form must be able to Synchronise with the information on the mainform. I do not want to scroll back and forth trying to match information.

Sep 7 '07 #1

Subscribe Post Reply

1777

BradHodge

166

Expert 100+

Bushmannz,

Open your main form in design mode and then open the toolbox. Make sure that the Control Wizard button is pressed. Use the subform tool to create a new subform. It will prompt you for the form, table or query to use and will ask you what field in the subform and which field in the mainform need to be linked. Once you get done with the wizard, you should have a subform that links nicely with your main form.

Try it out. If you have any questions, feel free to ask.

Welcome to theScripts!

Brad.

Sep 7 '07 #2

Bushmannz

Thanks Brad

This is now where my problem lies.
The forms synchronise perfectly, but I do not want the subform visible on the main form. I want to activate it (command button) and it will then open up as a seperate form but synchronised to the relevant page.

I am building a database for models and want their basic info on a main page.
If i need to find any other info such as photo,s etc. I then want to be able to open the relevant form and automatically be on their data page.

Sep 13 '07 #3

BradHodge

166

Expert 100+

Hey Bushmannz,

This also is possible. If you just want them to be able to get to the subform for this record, here's what you do...

Go ahead and delete the subform from your main form. It should still be present in the database window (i.e. don't delete the form itself). Then from the button on the main form that is suppose to open your subform, put something like this...

Expand|Select|Wrap|Line Numbers

 Dim strDocName as string

Dim strLinkCriteria as string

strDocName= "MySubForm"

strLinkCriteria= "[MyLinkingField]= Forms![MyMainForm]![MyLinkingField]"
 
DoCmd.OpenForm strDocName,,,strLinkCriteria

This will get your subform open to the record that you currently have open in your main form.

See if that gets you heading in the right direction.

Brad.

Sep 13 '07 #4

Bushmannz

Thanks Brad

Will try and figure it out this weekend and hopefully get it to work

Sep 13 '07 #5

Bushmannz

Thanks Brad

Works perfectly.

Sep 13 '07 #6

BradHodge

166

Expert 100+

No problem. Hope you enjoy learning Access and VBA. Hollar again if we can help you in anything.

Brad.

Sep 14 '07 #7

Similar topics

synchronise between many slaves

by: Peter King | last post by:

I am trying to setup a situation like this: Web server with contacts database (lots of tables relating to each other) Lots of clients connect to the web server to update local database then use...

MySQL Database

Synchronise problems with merge publication under SQL Server 2000

by: Kaan ?cg?n | last post by:

Hello NG, we have created a database for our schedules on the SQL server 2000. As we have many satellite stations, we created a merge publication. The aim of this merge publication is to provide...

Microsoft SQL Server

Synchronise XML data with database.

by: Simon | last post by:

Hello, Since a few days, it is possible to download from www.sysalys.com/com a new shareware for free (beta version V0.1) : This shareware is called SysDB ; it allows to synchronize XML data...

.NET Framework

to synchronise a c++ stream from a queue to write to disk

by: kavi81 | last post by:

Hi, I have written a c++ code which is a message queue. I have an Enqueue and a Dequeue. Here is the code for enqueue: ########################################################## Enqueue...

C / C++

How to synchronise file system with access tables?

by: Koen | last post by:

Hi all, I have built different databases for managing data I keep for my digital collections of mp3's, e-book's, divx movies and digital photographs. Until now, all these solutions lack one...

Microsoft Access / VBA

Synchronise tables

by: Michael Thomas | last post by:

Hi everyone Is there any way to compare tables and automatically update values. I import a list of products with associated cost prices and selling prices from an external database into a table...

Microsoft Access / VBA

synchronise outlook contacts with sqltable

by: Stefan | last post by:

Hello, at the moment i'm exporting outlook contacts to .csv files and then import the file into a sql contact table. i do this only once, so the inputter has to add new contacts twice. Now i...

Visual Basic .NET

please how to synchronise mssql database from db2/400 ?

by: Nicolas | last post by:

please how to synchronise mssql database from db2/400 ? I whish I have my db2/400 database as master and replicate it in an mssql server 2005 for reading thanks Nicolas

DB2 Database

Synchronise sub forms via buttons from main form

by: PhilBowen | last post by:

I am using Access 2003. I want to synchronise sub forms via buttons shown on the main form. The main form provides information for each application that is received. The sub forms accessed via...

Microsoft Access / VBA

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

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

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

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

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

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

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...

Online Marketing

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...

Windows Server

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,...

Career Advice