Changing data source for Access 97

[Geoff Matthews]

I apologize for the basic question, but MS's documentation has been no
help at all.
I'm working on a database, and need to create a form for schedules,
M-F, 8-4.
I've settled on an easy way out, by creating 5 similar tables (Monday,
Tuesday, Wednesday, etc.) with the same fields (8, 9, 10, etc.) that
link up to one table (Schedule) and then to the person. Not elegant,
but I'm beginner.

I've tried to design a form from scratch, directing checkboxes to each
time field for each table, but the checkboxes are blanked out. I've
put the following information in the Control Source field with the
Data Tab:

Monday.8

Yet the message reads:

Control can't be edited; it's bound to unknow field 'monday.8'.

If I use the expression builder, select the appropriate table and
field (which is [Monday]![8]):

Control can't be edited; it's bound to the expression '[Monday]![8]'

Any suggestions are welcome.

[DFS]

Re: Changing data source for Access 97

"Geoff Matthews" <vodyanoi@yahoo .com> wrote in message
news:67eaf128.0 401121524.45762 879@posting.goo gle.com...[color=blue]
> I apologize for the basic question, but MS's documentation has been no
> help at all.
> I'm working on a database, and need to create a form for schedules,
> M-F, 8-4.
> I've settled on an easy way out, by creating 5 similar tables (Monday,
> Tuesday, Wednesday, etc.) with the same fields (8, 9, 10, etc.) that
> link up to one table (Schedule) and then to the person. Not elegant,
> but I'm beginner.[/color]

Geoff,

Best to start off with a proper design. Post more details about who and
what is being scheduled: People, Autos, Jobs, Service Calls, etc. What
time periods: 1/2 hours, hours, days, weeks, months, etc?


[color=blue]
> I've tried to design a form from scratch, directing checkboxes to each
> time field for each table, but the checkboxes are blanked out. I've
> put the following information in the Control Source field with the
> Data Tab:
>
> Monday.8
>
> Yet the message reads:
>
> Control can't be edited; it's bound to unknow field 'monday.8'.
>
> If I use the expression builder, select the appropriate table and
> field (which is [Monday]![8]):
>
> Control can't be edited; it's bound to the expression '[Monday]![8]'
>
> Any suggestions are welcome.[/color]

[Mike Storr]

Re: Changing data source for Access 97

Have you set the source for the control, but not the form?
If you're using a bound form, then the forms RecordSource should be the
table or query name and the controls ControlSource should be the field name.
If you're not wanting to use a bound form, then the process of populating
the form becomes more in-depth and more details would be needed.

Mike Storr

https://www.veraccess.com

"Geoff Matthews" <vodyanoi@yahoo .com> wrote in message
news:67eaf128.0 401121524.45762 879@posting.goo gle.com...[color=blue]
> I apologize for the basic question, but MS's documentation has been no
> help at all.
> I'm working on a database, and need to create a form for schedules,
> M-F, 8-4.
> I've settled on an easy way out, by creating 5 similar tables (Monday,
> Tuesday, Wednesday, etc.) with the same fields (8, 9, 10, etc.) that
> link up to one table (Schedule) and then to the person. Not elegant,
> but I'm beginner.
>
> I've tried to design a form from scratch, directing checkboxes to each
> time field for each table, but the checkboxes are blanked out. I've
> put the following information in the Control Source field with the
> Data Tab:
>
> Monday.8
>
> Yet the message reads:
>
> Control can't be edited; it's bound to unknow field 'monday.8'.
>
> If I use the expression builder, select the appropriate table and
> field (which is [Monday]![8]):
>
> Control can't be edited; it's bound to the expression '[Monday]![8]'
>
> Any suggestions are welcome.[/color]

[Geoff Matthews]

Re: Changing data source for Access 97

I'm not using a bound form (the RecordSource is blank).

The following tables are involved:

Monday
Tuesday
Wednesday
Thursday
Friday

Each of these tables has the following fields:

8
9
10
11
12
13
14
15
16
ScheduleID

The ScheduleID links to a table (schedule) which then links to the
individual for whom we are setting the schedule.

"Mike Storr" <storrboy@sympa tico.ca> wrote in message news:<UeJMb.775 7$881.1072199@n ews20.bellgloba l.com>...[color=blue]
> Have you set the source for the control, but not the form?
> If you're using a bound form, then the forms RecordSource should be the
> table or query name and the controls ControlSource should be the field name.
> If you're not wanting to use a bound form, then the process of populating
> the form becomes more in-depth and more details would be needed.
>
> Mike Storr
> www.veraccess.com
>
>
> "Geoff Matthews" <vodyanoi@yahoo .com> wrote in message
> news:67eaf128.0 401121524.45762 879@posting.goo gle.com...[color=green]
> > I apologize for the basic question, but MS's documentation has been no
> > help at all.
> > I'm working on a database, and need to create a form for schedules,
> > M-F, 8-4.
> > I've settled on an easy way out, by creating 5 similar tables (Monday,
> > Tuesday, Wednesday, etc.) with the same fields (8, 9, 10, etc.) that
> > link up to one table (Schedule) and then to the person. Not elegant,
> > but I'm beginner.
> >
> > I've tried to design a form from scratch, directing checkboxes to each
> > time field for each table, but the checkboxes are blanked out. I've
> > put the following information in the Control Source field with the
> > Data Tab:
> >
> > Monday.8
> >
> > Yet the message reads:
> >
> > Control can't be edited; it's bound to unknow field 'monday.8'.
> >
> > If I use the expression builder, select the appropriate table and
> > field (which is [Monday]![8]):
> >
> > Control can't be edited; it's bound to the expression '[Monday]![8]'
> >
> > Any suggestions are welcome.[/color][/color]