Solved

Unique Values on the form and Check box properties

Posted on 2011-02-26
5
277 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
[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
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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

705 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