(Msg. 9) Posted: Wed Oct 01, 2008 1:29 pm
Post subject: Re: Making Check Boxes [Login to view extended thread Info.] Archived from groups: microsoft>public>access>tablesdbdesign (more info?)
Ok- thank you. I will start with the basics. And thank you for your honesty-
I may have jumped the gun with something I do not quite understand. Thanks
again.
"Fred" wrote:
> Hello Jami B.
>
> If you will forgive the directness which is an attempt to be helpful.
>
> The foundation of everything that Access does is storage of information in
> tables. Everything else is just an "interface" to the tables. It sounds
> like you do not understand this or possibly that you do not even understand
> what tables are. You're going to have to start by learning that before you
> will be able to do any design work with Access.
>
> Sincerely,
>
> Fred
>
>
(Msg. 10) Posted: Wed Oct 01, 2008 2:44 pm
Post subject: Re: Making Check Boxes [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Wed, 1 Oct 2008 13:04:01 -0700, Jami B. <JamiB.DeleteThis@discussions.microsoft.com>
wrote:
>Unfortunately, I do not know how to bind any fields to any particular
>contact, and it would be too much to ask for a detailed "how-to" but is there
>a quick way to explain how to bind the information so my check boxes work
>properly? I am somewhat new to creating new forms and tables with Access, so
>forgive me if I seem naive on the Access lingo. Thanks so much for your time!
Again:
*Start with the Tables*.
Don't even OPEN the forms window until you have tables with all of the fields
needed to store the information that you want to record.
This would include a Yes/No field in the appropriate table (which I can't
really identify based on what you've posted).
Once you have your tables set up, with all the needed fields and
relationships, *then* create your Form.
You might want to look at some of the tutorials and sample databases
available:
(Msg. 11) Posted: Wed Oct 01, 2008 2:44 pm
Post subject: Re: Making Check Boxes [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thank you so much for your help. I will look over the tutorials and hopefully
they will get me far enough where I can complete this database. Thank you so
much again- and hopefully, I won't bother you with any more questions. Thanks
again.
"John W. Vinson" wrote:
> On Wed, 1 Oct 2008 13:04:01 -0700, Jami B. <JamiB RemoveThis @discussions.microsoft.com>
> wrote:
>
> >Unfortunately, I do not know how to bind any fields to any particular
> >contact, and it would be too much to ask for a detailed "how-to" but is there
> >a quick way to explain how to bind the information so my check boxes work
> >properly? I am somewhat new to creating new forms and tables with Access, so
> >forgive me if I seem naive on the Access lingo. Thanks so much for your time!
>
> Again:
>
> *Start with the Tables*.
>
> Don't even OPEN the forms window until you have tables with all of the fields
> needed to store the information that you want to record.
>
> This would include a Yes/No field in the appropriate table (which I can't
> really identify based on what you've posted).
>
> Once you have your tables set up, with all the needed fields and
> relationships, *then* create your Form.
>
> You might want to look at some of the tutorials and sample databases
> available:
>
> Jeff Conrad's resources page:
> http://www.accessmvp.com/JConrad/accessjunkie/resources.html >
> The Access Web resources page:
> http://www.mvps.org/access/resources/index.html >
> A free tutorial written by Crystal (MS Access MVP):
> http://allenbrowne.com/casu-22.html >
> MVP Allen Browne's tutorials:
> http://allenbrowne.com/links.html#Tutorials > --
>
> John W. Vinson [MVP]
>
(Msg. 12) Posted: Wed Oct 01, 2008 3:17 pm
Post subject: RE: Making Check Boxes [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On the Property Sheet click on the Data tab and it is the first item listed.
--
KARL DEWEY
Build a little - Test a little
"Jami B." wrote:
> Access 2007 may be different, but I could not find the Control Source option.
> Any other suggestions?
>
> "KARL DEWEY" wrote:
>
> > First read John W. Vinson's response.
> >
> > I assume your form uses a query to pull records from your table.
> > Open the form in design view. Right click the form and select Properties.
> > Click on the checkbox and then click in the Control Source property to select
> > your field.
> > --
> > KARL DEWEY
> > Build a little - Test a little
> >
> >
> > "Jami B." wrote:
> >
> > > How do I go about binding the field to the record? Is it in properties?
> > >
> > > "KARL DEWEY" wrote:
> > >
> > > > The checkbox needs to be bound to a field in the table so the record will
> > > > store the information.
> > > > --
> > > > KARL DEWEY
> > > > Build a little - Test a little
> > > >
> > > >
> > > > "Jami B." wrote:
> > > >
> > > > > I am using the Student form for (obviously) a list for students. I had to add
> > > > > check boxes through the design view, but when I click on the check boxes for
> > > > > each contact, it clicks it for ALL of the students. How do I make the check
> > > > > boxes check for each individual contact without it checking all of them?
> > > > > Thanks.
(Msg. 13) Posted: Wed Oct 01, 2008 4:42 pm
Post subject: Re: Making Check Boxes [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Wed, 1 Oct 2008 14:08:01 -0700, Jami B. <JamiB.RemoveThis@discussions.microsoft.com>
wrote:
>Thank you so
>much again- and hopefully, I won't bother you with any more questions.
You're most welcome - and indeed you're most welcome to keep asking questions
as needed. We're all volunteers here and we wouldn't be here if we didn't want
to help folks! So don't hesitate to post back if you're confused about a
tutorial or about your table/form structures.
--
All times are: Eastern Time (US & Canada) (change) Goto page Previous1, 2
Page 2 of 2
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other