473,320 Members | 1,921 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

linked forms (or why Access is retarded)

AccessIdiot
493 256MB
Or maybe why my username is AccessIdiot :P

I just discovered the linked form functionality of the form wizard. I dumped the fields from two tables linked by a Survey_ID (autonumber primary key in Survey table and number foreign key in Replicate table). Access creates two forms for you with the appropriate fields.

But for some reason the Survey_ID does not get carried over into the replicate form. Access recognizes that the replicate belongs to a certain Survey_ID number because I can see in the filter property of the form [Surve_ID = 14] (or whatever number) but the Survey_ID field on the Replicate form is 0.

Why? And is there a fix? This seems very fundamental to linking forms that are linked by a primary/foreign key and yet even this very basic example fails.

Any advice/help much appreciated!

melissa
Mar 29 '07 #1
5 1752
Denburt
1,356 Expert 1GB
I havent worked with the wizards in a while however once you review my last post in your other thread I am sure things will be much more clear if you would like to see any changes I made I will gladly send them to you.

Have a good night.

Post
Mar 30 '07 #2
developing
110 100+
wait...so one of the forms is a subform? if yes, then add Me.Bookmark property to make sure the update takes place....

i know what u mean, for some reason, access is kinda flaky when it comes to updating linked fields in forms
Mar 30 '07 #3
ADezii
8,834 Expert 8TB
Or maybe why my username is AccessIdiot :P

I just discovered the linked form functionality of the form wizard. I dumped the fields from two tables linked by a Survey_ID (autonumber primary key in Survey table and number foreign key in Replicate table). Access creates two forms for you with the appropriate fields.

But for some reason the Survey_ID does not get carried over into the replicate form. Access recognizes that the replicate belongs to a certain Survey_ID number because I can see in the filter property of the form [Surve_ID = 14] (or whatever number) but the Survey_ID field on the Replicate form is 0.

Why? And is there a fix? This seems very fundamental to linking forms that are linked by a primary/foreign key and yet even this very basic example fails.

Any advice/help much appreciated!

melissa
If it is not carrying over, it is a simple matter to manually transfer over the [Survey_ID] Field from the Master to the Linked Form or to pull it from the Linked Form in its Open() Event.
Mar 30 '07 #4
AccessIdiot
493 256MB
Thanks to all who answered.

I guess I'm just flabbergasted as to WHY it's not carrying over. In the most simple case of Customers and Orders where Customer.CustomerID = Orders.CustomerID - this is like saying that for a given Customer going from the Customer form to the Orders form, Access filters on, say Customer.CustomerID = 12 but doesn't insert "12" into the Orders.CustomerID field in the Orders table. Why not? Shouldn't that be a given with linked forms? Isn't that the point of having the wizard?

Or am I missing the whole point?

Denburt I'm checking the other thread now but I am hoping to understand this as well for future projects or even for other forms within my current complicated project.

cheers,
melissa
Mar 30 '07 #5
NeoPa
32,556 Expert Mod 16PB
I can understand the question, but in my experence, judging why something like this is implemented in such a way involves attention to the detail. Without knowing exactly all the selections made in the wizard, it's hard to know why Access felt that this was the appropriate way forward. It's often frustrating I know, when Access (or any other software for that matter) behaves in an unpredictable way, but it's often for reasons that are simply not understood.

Think of your own recent experience, if you look back on some of the things you've learnt recently, you'll see a number of things that make sense now which seemed totally idiotic when you first came across them.

I can't give you a definitive answer without a much better understanding myself of exactly what went down, but I'd be surprised if there weren't one.
Mar 30 '07 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: jason | last post by:
Is it actually possible for a local access 2000 database to link to a remote database online via linked tables... I know www.aspfaq.com has spoken about possibliites (although not secure) for...
4
by: Clive | last post by:
Hi all. I'm fairly new to access (97) programming so please forgive me if this has been asked a thousand times. I have a two forms: Form A open forms B by a button/control (form B enters...
2
by: Sam DeRT | last post by:
Is there a way to hard code what a path to a linked table would be without going through the Linked Table Manager or a re-linking process? My issue is that I'm installing a database with linked...
0
by: Privacy Trap | last post by:
Hi I have a slight problem in trying to set up 2 forms linked to tables. What I want to do is to inform a control on one form(Apps) as to the value of a key of a 'new' record entered via a...
7
by: smd | last post by:
Hello and thanks for taking the time to read this. I've looked all over the web and newsgroups and can't find a solution to my problem. I've posted this question to the Access 2000 group as well -...
1
by: Meaney | last post by:
Hi, I have two linked forms. The first form is called Exposure and the second form is called Counts. On the first form (Exposure) there is a text box that asks the user to input an ExposureID...
14
klarae99
by: klarae99 | last post by:
I am wondering if access 2003 has the ability to open a linked Word Document, without that document being related directly to a table (I do not need to merge data with the document). I am...
3
by: gblaxx42 | last post by:
Hello All. I am building a databse for the 56th Stryker Brigade in Pennsylvania. I have to track many different types of data for soldiers. (i.e. training info, personnel data, etc) I have created...
4
by: xperre van wilrijk | last post by:
Hi, I have inherited an access userinterface that links to sql server tables through ODBC. The SQL server database contains data related to villages in my country and is populated by my...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.