C
Chip
Hey Everyone,
Here's my problem. The backend for this problem is a table on
SharePoint. The field in question is a Date / Time field. Prior to
me making the switch to SharePoint, I used to store appointments with
two separate fields. One for date (mm/dd/yy is my favorite) and one
for time (xx:xx 24 hour time in medicine). This way, the end user I
feel has the most flexibility. If someone wants to change the date,
the user only needs to edit one field. Same theroy with time. And if
the date adn time both need edited, well, nuff said...
The problem I'm finding is that SharePoint doesnt like a Time field by
itself. They have room for a date field. But in order for to
incorporate time, I need to have a a Date/Time field (Dec 11, 1970
09:00). So in my front end app, I have a date field and a time field
as I wrote above. They are unbound controls. What I thought I'd do
was create a third control and bind that control to the field on the
SharePoint table. How do I code the field to take the input from the
date field and the input from the time field, and combine them into
one field.
So I set the Control Source of this third field to =Trim([Exam Date])
&" "&Trim([Text80])
But I get # Error and it says its a circular reference. I dont
normally get circular errors so I'm stumped. Where am I going wrong?
On the drop down error thingy, it says I should edit the Control
Source. Thoughts?
chip
Here's my problem. The backend for this problem is a table on
SharePoint. The field in question is a Date / Time field. Prior to
me making the switch to SharePoint, I used to store appointments with
two separate fields. One for date (mm/dd/yy is my favorite) and one
for time (xx:xx 24 hour time in medicine). This way, the end user I
feel has the most flexibility. If someone wants to change the date,
the user only needs to edit one field. Same theroy with time. And if
the date adn time both need edited, well, nuff said...
The problem I'm finding is that SharePoint doesnt like a Time field by
itself. They have room for a date field. But in order for to
incorporate time, I need to have a a Date/Time field (Dec 11, 1970
09:00). So in my front end app, I have a date field and a time field
as I wrote above. They are unbound controls. What I thought I'd do
was create a third control and bind that control to the field on the
SharePoint table. How do I code the field to take the input from the
date field and the input from the time field, and combine them into
one field.
So I set the Control Source of this third field to =Trim([Exam Date])
&" "&Trim([Text80])
But I get # Error and it says its a circular reference. I dont
normally get circular errors so I'm stumped. Where am I going wrong?
On the drop down error thingy, it says I should edit the Control
Source. Thoughts?
chip