Solved

Unique Values on the form and Check box properties

Posted on 2011-02-26
5
275 Views
Last Modified: 2012-05-11
Hi

i am creating a form based on a table. i have two combo box based on which the information in the details section should be modified. Also the combo box should show only unique values.

How can i also stop the check box from creating new line items in the table when i click on the last check box.

And the last thing is, how can i create a column view on the forms detail section showing the first three items in the first line and the next three below them and so on.

I am attaching a copy of the database.

Your help on this is appreciated.

Thanks,
Sai.
Test.accdb
0
Comment
Question by:Saichand
  • 3
  • 2
5 Comments
 
LVL 3

Expert Comment

by:DockieBoy
ID: 34990190
Sorry, I only use access 2003, so I can't open your accdb.  If you can change it to mdb I would be happy to take a look, or I am sure that someone else who isn't anti > 2003 will see this post and help you out.  :)
0
 

Author Comment

by:Saichand
ID: 34990569
attached is the file in 2003 format
Test.mdb
0
 
LVL 3

Accepted Solution

by:
DockieBoy earned 500 total points
ID: 34990627
Ok, so I am confused as to what you are trying to achieve here, could you please try to explaine again exactly how the form is to be used and the result you are trying to achieve.  :)

For your query about the checkbox creating a new line entry, it is not actually creating a record.  The new check box needs to appear so as you have the ability to create the new record.  As soon as you check the last check box it updates in your table to reflect the value of the checkbox and in doing so creates a new record, then a new little check box appears so you can continue the process.

If you would like to stop that from happening you can set the forms Allow Additions property to No.
0
 
LVL 3

Expert Comment

by:DockieBoy
ID: 34990631
Also, in the db you don't have a primary key and all the fields data propy type's are set to Text, is there a reason for this?
0
 

Author Comment

by:Saichand
ID: 34993337
there is no reason why i have the table without a prumary key and without datatypes.

i wanted the two combo box above to display only the unique content off the table and when i coose a criteria and the detail section get modified.

Also i want the detail section to the displayed in below design.
item 1                        item 2                        item 3
item 4                        item 5                        item 6
and so on
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…

839 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