I hava table named tblPeople with the following fields:
Id Primary Key
Name
Tea......checkbox
Coffee.....checkbox
Water.....checkbox
Juice.....checkbox
I would like to have a query which will tell me how many times each item is ticked. One person can tick more than one check-box. I can...
I have a primary key with autonumber in my main table . I want Access 2000 to start the numbers from 1 but it always starts from some other number except 1. This is so annoying. I have tried deleting the CustomerId and putting it back in.....but of no avail. Please can you suggest something to...
I have 10 commenst on my form and the user can click as many. When the report is produced I would like only the checked expressions to appear. Is it possible to do that? At the moment evrything on the form is appearing on the report. Please help me.
Is there anyway I can have several sections in the form to give me totals of subsections? I wanted to have small sections with its own subsections and their totals. Is that possible?
I have added a hyperlink on my form called "email"which when clicked, should go to the hotmail sign in page............it doesn't work. No matter what web address i type in, the link does not work. Can you help me please?:(
I have a box in my main form called "standard comments" and I want user to choose as many comments as they want from a sub-form connected to it. Example, the sub-form may have a check box next to each comment, and when the user ticks these checkboxes the chosen comments are all displayed in the...
Forms not updating !!!!!!
As i don't know Access very well, I am having problems with the forms. I have updated the table with new values but those values are not reflected in the form ! Please help me. thanking you in advance.
I am new to Access and trying to create a form . One element has a combi box and I want the user to be able to choose more than one selection from the list in my combi-box. Is that possible at all? At the moment, I can chose only one line from my combi-box. Thanks