Solved

Unique Values on the form and Check box properties

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

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…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

776 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