Linking a large database - Microsoft Access / VBA

wendywhuang

Hello Access Experts,

I'm trying to split some data (between Rural and Urban readings) into
seperate tabs (Orig all in Urban Tab). The requirements between Urban
and Rural is filtered differently, so I have to create diff Tables and
Forms for rural. I'm trying to copy the format of the Urban tab and
just eliminate and append approperiate data for the Rural tab. For the
Urban Tab, I have a filter where it sorts the data from Business Unit
--District --Plant # --CP Area. I'm trying to do the same for
the Rural Tab, except to link Business Unit --District --Plant # --

Location Type --Legal Description. How do I go about doing this?

Also, I have no experience with VB. Thanks in advance for any help.

Jul 16 '07 #1

Subscribe Post Reply

1158

DavidB

What is a tab?
On Jul 16, 4:36 pm, wendywhu...@gmail.com wrote:

Hello Access Experts,

I'm trying to split some data (between Rural and Urban readings) into
seperate tabs (Orig all in Urban Tab). The requirements between Urban
and Rural is filtered differently, so I have to create diff Tables and
Forms for rural. I'm trying to copy the format of the Urban tab and
just eliminate and append approperiate data for the Rural tab. For the
Urban Tab, I have a filter where it sorts the data from Business Unit
--District --Plant # --CP Area. I'm trying to do the same for
the Rural Tab, except to link Business Unit --District --Plant # --Location Type --Legal Description. How do I go about doing this?

Also, I have no experience with VB. Thanks in advance for any help.

Jul 16 '07 #2

wendywhuang

On Jul 16, 2:58 pm, DavidB <je...@yahoo.comwrote:

What is a tab?

On Jul 16, 4:36 pm, wendywhu...@gmail.com wrote:

Hello Access Experts,

I'm trying to split some data (between Rural and Urban readings) into
seperate tabs (Orig all in Urban Tab). The requirements between Urban
and Rural is filtered differently, so I have to create diff Tables and
Forms for rural. I'm trying to copy the format of the Urban tab and
just eliminate and append approperiate data for the Rural tab. For the
Urban Tab, I have a filter where it sorts the data from Business Unit
--District --Plant # --CP Area. I'm trying to do the same for
the Rural Tab, except to link Business Unit --District --Plant # --Location Type --Legal Description. How do I go about doing this?

Also, I have no experience with VB. Thanks in advance for any help.- Hide quoted text -

- Show quoted text -

like the pages (looks like tabs)

Jul 16 '07 #3

Similar topics

Linking to SQL Server 2000

by: John South | last post by:

I have an Access 2000 front end that I wish to work with a SQL Server 2000 database by means of Linked tables. Do I have to use an ODBC connection to SQL Server? It seems to be the only option...

Microsoft Access / VBA

Linking an Mdb to SQL Server

by: diskoduro | last post by:

Hi!! Years ago I built a database to control the production of a little factory. The users wanted to work in a Windows Net workgroup so I created an mdb with all the tables and data an after...

Microsoft Access / VBA

linking to a password protected database

by: gasturbtec | last post by:

please help im new at access programming and i just got this project dropped in my lap because the old programmer quit. i've been doing ok so far but now i need to add code to an existing database...

Microsoft Access / VBA

Slow performance progromatically linking tables in Access

by: Mark P | last post by:

I have a bit of vb code that uses Tables.Append to programatically link tables from Oracle and DB2 datasources. The problem I am having on some client machines is that the link will take anywhere...

Microsoft Access / VBA

Linking multiple tables alternatives

by: dskillingstad | last post by:

I've been struggling with this problem for some time and have tried multiple solutions with no luck. Let me start with, I'm a novice at Access and I'm not looking for someones help to design my...

Microsoft Access / VBA

Access appears to hang when linking Oracle table via ODBC

by: bdtmike | last post by:

I'm using Access to view data from an Oracle 9i database. When I try to link an Oracle database, the PC appears to Hang before finally presenting the list of tables to choose from. It's a large...

Microsoft Access / VBA

Linking and disconnecting from backend databases

by: cmd | last post by:

I use a utility database and the following code to link from an original backend to a temporary backend, in order to replace the original with a newer version: Dim dbs As Database Dim tdf As...

Microsoft Access / VBA

Linking Tables to network Database

by: deiopajw | last post by:

I have a Back end database on a network drive. The copies of the front end are located on individual pc's (in their C drive). The problem arises when a laptop user naturally hooks up to the...

Microsoft Access / VBA

Linking tables and memory growth

by: watto | last post by:

I have a large database application with user data in a backend and forms, code etc in a frontend. It includes a facility for migrating data from an earlier backend to the current backend by...

Microsoft Access / VBA

Re-linking problems if linked db no longer exists..Help!

by: ARC | last post by:

I'm having trouble here with Access 2007 and connecting to a different database. The code below works great IF the previous back-end database connection is still present and you are trying to...

Microsoft Access / VBA

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

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

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

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

Windows Server

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

C / C++