Question about Microsoft Computers & Internet

1 Answer

Microsoft Access Program

How can I limit the data entry in my subform which is in datasheet view?

Posted by on

  • Princess Fairlane Anajao

    Thank you for the opportunity to ask a solution to my problem. Hope I'll get some answers soon. Many many thanks!

  • Princess Fairlane Anajao

    Thank you for the help ke5uyx! But what I mean is how can I limit the number of records be encoded in a row in a datasheet view subform like for example the folowing is my subform



    Name Birthdate Age

    Princess 07/21/1974 33

    Queen 06/051973 35



    if the encoder will add more name in the subform it will give a message that says "only two persons are allowed."



    Thank you for the solution. God bless!

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 9 Answers

Sure, Assuming that the field types used offer that option, and most do, but memo may not.
While in the table view mode go to the design mode. Once there look for field length option, and make your change. Be prepared to have existing data truncated to the new max length. You have found out that the datasheet view is the quick and dirty way to update table fields and it uses the properties from the table design.

Posted on Jun 27, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to invoke a ms.access using parser


To parse a Text field that contains two words separated by a comma, follow these steps:
  1. Open any existing database.
  2. Create a table with the following structure: Table: Parse2Words
    ------------------
    Field Name: Empl
    Data Type: Text
  3. View the Parse2Words table in Datasheet view and type the following three records in the Empl field: Smith, John
    Callahan, Laura
    Fuller, Andrew
  4. Create the following query based on the Parse2Words table: Query: QueryTest
    ------------------------------------------------------------------
    Field: FirstName: Right$([Empl],Len([Empl])- InStr(1,[Empl],",")-1)
    Show: True
    Field: LastName: Left$([Empl],InStr(1,[Empl],",")-1)
    Show: True

    NOTE: You can modify the QueryTest query to account for spaces between the two parts in the Empl field. For example, if the text in the Empl field is "Smith,John" without spaces, remove the -1 from the FirstName field expression.
  5. Run the query. Note that the QueryTest query separates the text in the Empl field into the two fields below: FirstName LastName
    --------------------
    John Smith
    Laura Callahan
    Andrew Fuller

Jan 08, 2011 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Cannoty access the internet after installing IE8


You can un-install IE8 by doing the following: Go into the Control Panel, Uninstall a Program; on gthe top-left side of the screen, you will see "View Installed Updates". Click on this. Somewhere under "Mictosoft Silverlight" you will find an entry for IE8. Click this. It will be removed, your previous version browser will be restored. Hopefully all will be well.

Nov 10, 2009 | Microsoft Internet Explorer 8

3 Answers

I need to find an alternative to Sharepoint


Now that the 2016 on-premises and cloud versions were released, I'm sure there's no need to look for a replacement for Sharepoint, especially with this new Linked Table Manager feature. It allows you to manage complex Access data easily.
In order to import Access spreadsheets, you should follow these steps:
1. locate the address of the site where the spreadsheets you need to import are situated
2. identify the data you want to be imported. You have an option to choose either to import the whole list or just a view, but remember that while you can copy several lists, you can copy only one view of it.
Looking for specialists to optimize your product to the latest version or migrate to Office 365? The "Digital Design" (http://www.digdes.com/) software development team will help you with it. It is a company with solid expertise in Sharepoint services and impressive clientele. Check out its website Digital Design

Jun 04, 2009 | Microsoft Office SharePoint Server 2007...

1 Answer

Want to populate a form with data from a table, the Id number is keyed into the form and once it's matches with the Id in the table I want the other fields on the form to be populated with the data from...


Create a Form from the main table with a subform based on the other data you will want populated. You put the fields in the subform that you want populated from the main form. Go to the properties for the subform and select the data tab, In the data tab, select the Link Master Fields and choose the field you want linked. When you type the ID number in the main form, the other firlds you have in hte subform should populate from the data inthe table.

May 14, 2009 | Microsoft Access 2003 for PC

1 Answer

Access 2003 subform won't scroll


Check microsoft.com/office for any updates.

Convert you database to Acess 2000 and see if the problem goes away.

Oct 20, 2008 | Microsoft Office Professional 2007 Full...

2 Answers

Cache memory


A cache is a temporary storage area where frequently accessed data can be stored for rapid access. Once the data is stored in the cache, future use can be made by accessing the cached copy rather than re-fetching or recomputing the original data, so that the average access time is shorter. Cache, therefore, helps expedite data access that the CPU would otherwise need to fetch from main memory.

A cache is a block of memory for temporary storage of data likely to be used again. The CPU and hard drive frequently use a cache, as do web browsers and web servers.

A cache is made up of a pool of entries. Each entry has a datum (a nugget of data) which is a copy of the datum in some backing store. Each entry also has a tag, which specifies the identity of the datum in the backing store of which the entry is a copy.

When the cache client (a CPU, web browser, operating system) wishes to access a datum presumably in the backing store, it first checks the cache. If an entry can be found with a tag matching that of the desired datum, the datum in the entry is used instead. This situation is known as a cache hit. So, for example, a web browser program might check its local cache on disk to see if it has a local copy of the contents of a web page at a particular URL. In this example, the URL is the tag, and the contents of the web page is the datum. The percentage of accesses that result in cache hits is known as the hit rate or hit ratio of the cache.

The advantage of cache memory is that the CPU does not have to use the motherboard’s system bus for data transfer. Whenever data must be passed through the system bus, the data transfer speed slows to the motherboard’s capability. The CPU can process data much faster by avoiding the bottleneck created by the system bus

Jul 17, 2008 | Microsoft Windows Server Standard 2003 for...

1 Answer

Access 2007 forms wizard


If you run a repair install of office 2003

Jun 04, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

How to compare a value in a subform with parent form's value in Dcount


Assuming that Process id is an integer, this should do the trick:

DCount("[stageid]", "Process Stages", "[Process id] = " & Me.Parent! [Process id])

Regards -- Joe (Access VBA samples)

May 01, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Restict closing the main form when some controls on the subform are empty


Hi there. I didn't notice this was so old until I had already worked on it for some time. Did you get this the way you want it? If not, I suggest either using a BeforeUpdate control to ensure the condition is met that the subform contain data, or validate the particular field(s) with isnull. Thanks for posting back if you still need help, or otherwise rating FixYa!

Oct 03, 2007 | Microsoft Office Standard for PC

1 Answer

Access 2003


Hi smiths, Try adding a Label to the report in Design View. In the Properties, select the control source for this field. Insert one for your vertical and horizontal calculations as needed. Hope this helps. Regards DeltaC

Sep 10, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?

Open Questions:

Computers & Internet Logo

Related Topics:

62 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...