Solved

Microsoft Access Form Question

Posted on 2016-08-26
7
45 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 18

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 19

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:Hiroyuki Tamura
ID: 41772980
forgot to upload sample
Database4.zip
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

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 19

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:Hiroyuki Tamura
ID: 41773083
thank you.
Snap4.png
0
 
LVL 18

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
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…

820 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