Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Microsoft Access Form Question

Posted on 2016-08-26
7
Medium Priority
?
54 Views
Last Modified: 2016-08-28
When I type from Form, nothing happens.
do you know why?
0
Comment
Question by:Hiroyuki Tamura
  • 3
  • 2
  • 2
7 Comments
 
LVL 20

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 24

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 24

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 20

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
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: …
Suggested Courses

577 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