hi all,
Tables: story, shot
story-fieldnames, project, date episode
shot-fieldnames, scene,shot, filename(imagepath),action and dialogue.
Form has field from both the tables. how do i fetch the record from these two tables and display it.
form name-tracker. where it has all the field form both the tables.
how to fetch records from both the tables
help me
4  2233 
Tables: story, shot
story-fieldnames, project, date episode
shot-fieldnames, scene,shot, filename(imagepath),action and dialogue.
Form has field from both the tables. how do i fetch the record from these two tables and display it.
form name-tracker. where it has all the field form both the tables.
how to fetch records from both the tables
Is this in VB? If so, what version?
If it's an Access form, you'd be better off posting this question in the Access forum.
Is this in VB? If so, what version?
If it's an Access form, you'd be better off posting this question in the Access forum.
No
vb6.0 enterprise edition.
No
vb6.0 enterprise edition.
Ok.
How far have you got with the coding? For instance, have you done any code to set up a database connection, and that sort of thing?
Ok.
How far have you got with the coding? For instance, have you done any code to set up a database connection, and that sort of thing?
- Private Sub Form_Load()
-
-
Set CON = New ADODB.Connection
-
CON.CursorLocation = adUseClient
-
-
CON.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & App.Path & "\storyboard.mdb;"
-
-
CON.Open
-
-
-
Call rLOAD
-
-
Do While Not storyboard.EOF
-
scene_txt.AddItem storyboard!scene 'List all the sceneNo items into the ComboBox
-
storyboard.MoveNext
-
Loop
-
-
-
' Close Recordset
-
storyboard.close
-
-
' Clear the memory
-
Set storyboard = Nothing
-
-
End Sub
myconnection module - Public CON As ADODB.Connection
-
-
Public Sub myconnection()
-
Set CON = New ADODB.Connection
-
CON.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\storyboard.mdb;Persist Security Info=False"
-
End Sub
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: tom |
last post by:
I am new to SQL administration.
>From a list of IDs that are the primary key in one table (i.e. Customer
Table), I want to make changes in tables that use those IDs as a
foreign key.
...
|
by: DaveDiego |
last post by:
I've had a user delete one of the client records, I do have a version of
the DB with all records intact before the deletion occured.
Whats the best approach to getting all the related records in...
|
by: PC Datasheet |
last post by:
Looking for suggestions ----
A database was designed for a national automobile inspection program. In
it's simplest form, the database has two tables:
TblOwner
OwnerID
<Year/Make/Model owned...
|
by: shriil |
last post by:
Hi
I have this database that calculates and stores the incentive amount
earned by employees of a particular department. Each record is
entered
by entering the Date, Shift (morn, eve, or night)...
|
by: mclueless |
last post by:
I am working with VB6 and Access. There is a SQL query I have written to retrieve a few records. But when I try to display these records in a listbox, only the first one is fetched, others are not....
| | |
by: camarun20 |
last post by:
Hi ,
I constructed an MS access query in java to retrieve the rows in random.
The code snipet
Connection con = DriverManager.getConnection( database ,"","");
Statement s =...
|
by: padmaneha |
last post by:
Hi
Thanks for your response but the query which you gave in my previous post doesnt work. It displays the same cnt for movie reviews and videoreviews
Let me explain you in detail
As I...
|
by: Soniad |
last post by:
Hello,
In stored procedure, i am using query that fetches 2 columns record but single row. i have used cursor to fetch single record.
is there any way to fetch the record and put it in...
|
by: BinaryBird |
last post by:
Hi, i have a small script to display records from two tables. Table 1 keeps track of teams and table 2 keeps track of the members.
<?php
$dl = mysql_connect...
|
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,...
|
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...
| | |
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,...
|
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...
|
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...
|
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,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...
|
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...
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
