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. 3 2116
"Geoff Matthews" <vo******@yahoo.com> wrote in message
news:67**************************@posting.google.c om... 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.
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?
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.
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" <vo******@yahoo.com> wrote in message
news:67**************************@posting.google.c om... 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.
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" <st******@sympatico.ca> wrote in message news:<Ue********************@news20.bellglobal.com >... 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" <vo******@yahoo.com> wrote in message news:67**************************@posting.google.c om... 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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Stefan Finzel |
last post by:
Hi,
is there a way to change the display property on Windows Mobile 2003 SE
Mobile/Pocket Internet Explorer? See following example.
Please note: visibilty property has the same problem.
Is...
|
by: Alan Munter |
last post by:
I have changed the passwords on our MySQL DB server for a few users.
I went in to the ODBC data sources configuration on their machines and
changed the passwords to the new ones.
However, every...
|
by: Marizel |
last post by:
I'm not sure there's an easy solution to this, but thought I'd ask. I
often find myself with a query which I'd like to reuse, but with a
different datasource. These datasources generally have...
|
by: Andrew |
last post by:
Hello,
I am trying to create a chart whose underlying query is linked to 2
combo boxes on the same form.
I want to pass the values from the combo boxes into the chart query to
allow the chart...
|
by: Corey B |
last post by:
I have a page with a DetailsView control and a SQLDataSource control.
The SQLDataSource control is connected to an Access database.
Everything works fine. Now I want to change the back end...
|
by: blufox |
last post by:
Hi All,
Can i change the execution path of methods in my process at runtime?
e.g
a()->b()->c()->d()->e()
Now, i want execution to be altered at runtime as -
|
by: RB0135 |
last post by:
Hi,
I hope I worded the subject correctly.
Under VS2005, I have created the wizard to add a datasource that
connects to my SQL2005 server. I ran through the wizard and this
created a Dataset,...
|
by: DrJarmin |
last post by:
Hello
The problem is this: in the criteria for a list box I reference the
parent form - and Access KEEPS changing the criteria for one that
won't work. Details below:
I have a couple of list...
|
by: steven_nospam at Yahoo! Canada |
last post by:
I am a UNIX person (not much experience with MS Access) who during a
recent upgrade on an IBM RS/6000 server had to convert our system due
to an upgrade to a new software revision.
The old...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |