Solved

Microsoft Access Form Question

Posted on 2016-08-26
7
47 Views
Last Modified: 2016-08-28
When I type from Form, nothing happens.
do you know why?
0
Comment
Question by:Tony T
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 19

Assisted Solution

by:Serena Hsi
Serena Hsi earned 250 total points
ID: 41772710
What are you trying to do? Create a Form or write VBA code for a form?
0
 
LVL 20

Assisted Solution

by:crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access earned 250 total points
ID: 41772922
perhaps you are trying to enter data? You did not give enough information so we are guessing ...

As a general rule, each form and subform should be based on just one table. Perhaps you have a form with more than one table in the record source and have created a recordset that is not updateable.
0
 

Author Comment

by:Tony T
ID: 41772980
forgot to upload sample
Database4.zip
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:Tony T
ID: 41773035
my question is, when i set relationship, form gets lock.
do you know how to set relationship properly?
0
 
LVL 20

Accepted Solution

by:
crystal (strive4peace) - Microsoft MVP, Access earned 250 total points
ID: 41773060
your form has both Table1 and Table2 as sources ... and relationship is not right.  The main field of the relationship should have a Unique index on it (which a Primary Key will have but not necessarily another field unless you add it). Be sure to check "Enforce Referential Integrity" when you create relationship.  Watch this short video:

Name fields uniquely. ID field name should be qualified with Table1ID, Table2ID -- or more specifically, CustomerID, ProductID, etc.  Each field in the database should have a unique name. It is ok (and, in my opinion, best) to name the field the same as a field in another table when it is a key field ... in other words, each field name should uniquely represent a particular data element.  Key fields represent the same data.

video Tip: Enforce Referential Integrity on Access Relationships (cc) closed-caption
http://www.youtube.com/watch?v=_zxxc9jzWEg

Also, your form is based on TWO tables -- best to have a main form based on Table1 and a subform based on Table2 with LinkMasterField and LinkChildFields set for the subform control. I realize you are new to Access and I am probably using terminology you do not (yet!) know ... this in intentional ... find out what these new words mean

you may have to also Enable the Content -- best to set defaults to allow the location where you store databases.  Here is a video that can help with that:

Access Defaults ... take a tour ... (cc)
 http://www.youtube.com/watch?v=CF9n0B3MU_w

both videos have captions which you may have to click  'cc' in the lower right of the video viewing window to show
0
 

Author Comment

by:Tony T
ID: 41773083
thank you.
Snap4.png
0
 
LVL 19

Assisted Solution

by:Serena Hsi
Serena Hsi earned 250 total points
ID: 41773231
Steps to re-assigning a primary key to a table:

1) Delete table relationships that share the current primary key (close open tables, if any)
2) Remove the existing primary key
2) Set the primary key using a field(s) you already have, in your screenshot, that'd be CIN.

Microsoft has a complete walk-through on how to modify each of these steps:
https://support.office.com/en-us/article/Add-or-change-a-table-s-primary-key-in-Access-0dde1a80-d913-4d9b-a1b3-061f24ccd991
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question