Home
Monday, May 29, 2017
4:43:31 AM
Users online: 0   You are here >> Home > Programming

Forums | Programming Forums search
Forum FAQ
   
  1  
2 Linked Recordsets in 1 Form Possible?? Access 2007
Demonic 
28/8/08 11:37:24 AM
Guru

Is it possible to use 2 Linked Tables in a Single form?

I've split up an existing database and now have decided i need another table but can't eem to link my form to the new table it only likes my old form

-----
Mr Trademart

TTV4 17/6/04 to 20/1/06

)Sydney(

Demonic 
28/8/08 12:20:42 PM
Guru

Solved Linked Via a Query looks like its working fine

God i hate access

-----
Mr Trademart

TTV4 17/6/04 to 20/1/06

)Sydney(

eckythump 
28/8/08 6:18:51 PM
Champion

Quote by Demonic
God i hate access


Use something else then.

MySQL and Postgres are both free and infinitely better. Take your pick.

Even SQLite would probably be a step-up.

-----
"Grandfather had an accident, he got burnt." "Oh no, how bad?" "Well, they don't fuck around at the crematorium."

kikz 
28/8/08 7:28:02 PM
Immortal

A form is design to be backed by a data source. Access is fine if you understand it. Binding one data source per form is standard practice.

-----
Q6600@3.2Ghz | 8Gb PC6400 | 2 x 500Gb RAID 0 + 2 x 320 Gb RAID 0 | 19" Benq FP591 + 24" Samsung 245B + 19" Dell | 8800GTS 640 Mb + 8400GS 256 Mb | Gigabyte GA-P35-DS3P | Antec P182 | Corsair HX-620 | Thermalright 120 Extreme | Vista x64

Jeruselem 
29/8/08 10:25:06 AM
Guru

Quote by kikz
A form is design to be backed by a data source. Access is fine if you understand it. Binding one data source per form is standard practice.



Yes - using Access as a back-end is being stupid but it's fine as the front-end. Access is a lot easier to manage than say Crystal Reports.


Edited by Jeruselem: 29/8/2008 10:25:19 AM

-----
PC 1: XP Home SP2, Opty 165@1.8Ghz, GEIL 1GB PC3200, 320GB SATA Cuda ES,XFX 9600GSO 580/700x2/1450, Seasonic S12+ 550W
PC 2: XP Home SP3, XP 3000+@2.24 Ghz, 1GB PC3200, 80GB IDE,ASUS nVidia 6800 512MB, Antec PlanetWatts 380W

nicephotog-jvm.net 
29/8/08 8:20:18 PM
Master

JOIN with a clause.

-----
NIN - Reptile (Reciprocating Marine engine)

SquallStrife 
2/9/08 1:48:40 PM
Titan

Quote by Jeruselem
Access is a lot easier to manage than say Crystal Reports.



This.

I make extensive use of SQL Pass-though Queries, to make our Oracle DBMS do all the grunt work, while Access just makes it pretty.

-----
Q6600 @ 3.6GHz | 8800GTS | XP x64 | Vista HP x64 | OSX 10.5.4

Quote by TinBane
The ONLY fuel saving benefit of this product, is that the car expends less energy to accelerate, because your wallet is lighter.

  1  
Forums | Programming