Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Microsoft Access Form Question

Posted on 2016-08-26
7
Medium Priority
?
50 Views
Last Modified: 2016-08-28
When I type from Form, nothing happens.
do you know why?
0
Comment
Question by:Hiroyuki Tamura
[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 1000 total points
ID: 41772710
What are you trying to do? Create a Form or write VBA code for a form?
0
 
LVL 22

Assisted Solution

by:crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access earned 1000 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:Hiroyuki Tamura
ID: 41772980
forgot to upload sample
Database4.zip
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

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

Accepted Solution

by:
crystal (strive4peace) - Microsoft MVP, Access earned 1000 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:Hiroyuki Tamura
ID: 41773083
thank you.
Snap4.png
0
 
LVL 19

Assisted Solution

by:Serena Hsi
Serena Hsi earned 1000 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

704 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