|
by: Ralf |
last post by:
Hi,
I have 4 tables: "T_father1",...,"T_father4".
In relation to these father-tables I have a child-table: "T_Child"
(with only 1 foreignkey-field: FsID) alread filled with some records.
That means each record of "T_Child" has in its field "FsID" a primary
key of one of the 4 father tables.
If I want to create the 4 foreign-key...
|
by: jbroome |
last post by:
I have several tables that contain the same information as Identifying
records but then with additional info that differs from table to
table.
e.g. 1 database of school students with their relevent info
Another dbase with subject info and grades etc assigned to the
students info
I wish to use one form to enter data into all tables. The...
|
by: Joanna Epstein |
last post by:
I have several tables formatted as follows:
ITEM #, ITEM DESCRIPTION, PL, JANUARY
ITEM #, ITEM DESCRIPTION, PL, FEBRUARY
And so on… I need to create a final report that merges all of the
information from these tables to form a tabular report reflecting the
information for all items for each month. However, the items in the
item number...
|
by: Coy Howe |
last post by:
What is the best way to enter a new record and have a common ID # or
Social Security #, for example, populate several tables at the same
time? I have a main table with an auto number and a dozen attached
tables with numbers. They all have a 1 to 1 relationship that cascades
info from the main table. I have tried several ideas (update...
|
by: Eagle |
last post by:
Hi all,
This one's drivin' me nuts. Any help would be appreciated. (Access 2000).
I have 3 tables:
tblTools: having the basic data of a tool and a field (txt) showing yes or
no with regard to being in-stock. Unique toolNr is the primary key.
tblOut: stores info on emloyee_ID and date of any occasion that the tool is
being handed over...
|
|
by: mark |
last post by:
(windows app not web)
I have a procedure to populate a given datagrid (Datagrid1) with a dataset
from an indexed data connection. It works:
Globals: Dim FileName1 As String
Dim DS As System.Data.DataSet
Dim OleDbConnection1(20) As System.Data.OleDb.OleDbConnection
Dim OleDbDataAdapter1(20) As System.Data.OleDb.OleDbDataAdapter
Dim...
|
by: Dowwy |
last post by:
I have an Access database on a Windows Server 2003 share. This
database contains linked tables that actually reside on a SQL Server.
There are a couple of things that I've noticed recently:
1) Some users cannot open the database if another person is already in
it, but some can. The people who cannot open it do not receive any
type of...
|
by: apartain |
last post by:
My database is based on Work Order Numbers. If an employee enters labor, they must include the WO Number for it. Equipment, subcontractors, per diem and materials all must also have a WO number.
I have the following tables:
Work Orders
Labor (includes per diem and time entries)
Equipment
Subcontractors
Materials
I have created a...
|
by: farouqdin |
last post by:
Hi all i have code which loops through table and deletes the duplicate
records. This code does it for one table. How do i change it so it
goes through several tables?
On Error Resume Next
Dim db As DAO.Database, rst As DAO.Recordset
Dim strDupName As String, strSaveName As String
Set db = CurrentDb()
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
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...
|
|
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...
|
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...
|
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...
|
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...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|