Improve company productivity with a Business Account.Sign Up

x
?
Solved

Unique Values on the form and Check box properties

Posted on 2011-02-26
5
Medium Priority
?
284 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 2000 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

579 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