engrlorie
Last Activity: Apr 1 '11, 05:56 AM
Joined: Feb 5 '11
Location: Manila, Philippines
-
engrlorie started a topic How to connect to access database with multiple tables and add/update the records?in Visual BasicHow to connect to access database with multiple tables and add/update the records?
I have four tables in access 2003: T1 (8 fields), t2 (5 fields), t3 (7 fields), t4 (3 fields) all connected to each other with t1.a = t2.a, t1.a=t3.a, t1.a=t4.a (T2, T3 and T4 contains the FK for T1.
My program has a listbox with t1.a populated on it. When the user clicks on an "a value," it would search the database and populate the textboxes which are supposedly connected to the fields (distributed to the 4 tables).
My... -
How to fix "Compile Error Expected: end of statement" in a query?
I am a newbie in programing and is currently designing a program using VB6 with access 03 database. Unfortunately, I am stuck with the error. Please help me.. can't decipher the problem myself. Scenario is I have 4 tables (lightinfo, location, characteristics , and pics). They are connected through National ID from lightinfo.
...Code:strQuery = "SELECT LIGHTINFO.info_NationalNo, LIGHTINFO.info_InternationalNo, LIGHTINFO.info_namriaName,
Last edited by Niheel; Feb 5 '11, 08:30 PM.
No activity results to display
Leave a comment: