|
|
I'm sorry if I am posting this in the wrong place -
I have added custom fields to my contact form and would like to link them to
my calendar and have them calculate some other things. I don't know anything
about programming, but I need to learn in order to make this work. What do I
need to learn and where is the best place to look. Meaning, I know NOTHING
about programming, and frankly I don't even understand what the difference
between VB, VB.net etc are - I just really need to customize Outlook and BCM
to work for me and I have not been successful in finding anyone who I can pay
to do this - so, I figure I should just learn it myself.
Thanks
Carole
--
Greek Vacation Rentals, Inc
|
|
Carole:
Could you be more specific? What do you want to do with the new fields?
You can use the custom fields by right clicking on the Calendar view, choose
Customize Current View, click on Fields button, and in the Select Available
Fields From dropdown you would choose User Defined Fields in Folder. You
can also use those fields in the Automatic Formatting section to create
conditions -- this might be what you're attempting.
HTH,
Lon
_________________________________________________
Lon Orenstein
pinpointtools
Lon[ at ]pinpointtools.com
www.pinpointtools.com
"Carole Kezios" <CaroleKezios[ at ]discussions.microsoft.com> wrote in message
news:0D861FFC-37B1-4E3E-80EF-2099883FCB9D[ at ]microsoft.com...
[Quoted Text] > I'm sorry if I am posting this in the wrong place -
>
> I have added custom fields to my contact form and would like to link them
> to
> my calendar and have them calculate some other things. I don't know
> anything
> about programming, but I need to learn in order to make this work. What do
> I
> need to learn and where is the best place to look. Meaning, I know NOTHING
> about programming, and frankly I don't even understand what the difference
> between VB, VB.net etc are - I just really need to customize Outlook and
> BCM
> to work for me and I have not been successful in finding anyone who I can
> pay
> to do this - so, I figure I should just learn it myself.
>
> Thanks
>
> Carole
> --
> Greek Vacation Rentals, Inc
>
|
|
Hi Lon
I have added some fields that include:
Checkin date, checkout date
Number of adults
Number of children
Airport pickup required
Airline
Flight number
Arrival time
Departure time
From the checkin and checkout dates I would like to calculate the number of
nights the guests are interested in. (I did figure out the DateDiff command)
I would also like to add the dates to a calendar - with the option of
changing it from tentative when it is an inquiry, to "busy" when it is
actually a confirmed booking. (this could be done on either 5 different
calendars or one calendar, using different colors for each property)
From the adults and children fields I would like to calculate the total
number of guests. I'll have a field that is populated with this number, and
from the result I would have a nightly rate calculated - with an option of
manually changing this result.
Finally, from the checkin/checkout dates and the airport transfer/arrival
information I would like to be abe to create a report which shows
checkins/checkouts / apartment, airport transfer info so I can give this info
to our housekeeper and driver.
Thanks for any suggestions you have ---
Carole
"Lon Orenstein" wrote:
[Quoted Text] > Carole:
>
> Could you be more specific? What do you want to do with the new fields?
>
> You can use the custom fields by right clicking on the Calendar view, choose
> Customize Current View, click on Fields button, and in the Select Available
> Fields From dropdown you would choose User Defined Fields in Folder. You
> can also use those fields in the Automatic Formatting section to create
> conditions -- this might be what you're attempting.
>
> HTH,
> Lon
>
> _________________________________________________
> Lon Orenstein
> pinpointtools
> Lon[ at ]pinpointtools.com
> www.pinpointtools.com
>
> "Carole Kezios" <CaroleKezios[ at ]discussions.microsoft.com> wrote in message
> news:0D861FFC-37B1-4E3E-80EF-2099883FCB9D[ at ]microsoft.com...
> > I'm sorry if I am posting this in the wrong place -
> >
> > I have added custom fields to my contact form and would like to link them
> > to
> > my calendar and have them calculate some other things. I don't know
> > anything
> > about programming, but I need to learn in order to make this work. What do
> > I
> > need to learn and where is the best place to look. Meaning, I know NOTHING
> > about programming, and frankly I don't even understand what the difference
> > between VB, VB.net etc are - I just really need to customize Outlook and
> > BCM
> > to work for me and I have not been successful in finding anyone who I can
> > pay
> > to do this - so, I figure I should just learn it myself.
> >
> > Thanks
> >
> > Carole
> > --
> > Greek Vacation Rentals, Inc
> >
>
>
|
|
Well, this is definitely above your expertise level and probably can't just
be done as a report -- you want some automation to happen which means code
written to make that happen. BCM's report writer isn't powerful enough to
customize what you want but MS Access's is and that isn't too hard to learn
how to connect. Maybe some developers or programmers are lurking out there
and would be interested in this project...
HTH,
Lon
--
_________________________________________________
Lon Orenstein
pinpointtools
Lon[ at ]pinpointtools.com
www.pinpointtools.com
"Carole Kezios" <CaroleKezios[ at ]discussions.microsoft.com> wrote in message
news:F0DBD464-B204-4631-85CB-E2466783BF5C[ at ]microsoft.com...
[Quoted Text] > Hi Lon
>
> I have added some fields that include:
> Checkin date, checkout date
> Number of adults
> Number of children
> Airport pickup required
> Airline
> Flight number
> Arrival time
> Departure time
>
> From the checkin and checkout dates I would like to calculate the number
> of
> nights the guests are interested in. (I did figure out the DateDiff
> command)
> I would also like to add the dates to a calendar - with the option of
> changing it from tentative when it is an inquiry, to "busy" when it is
> actually a confirmed booking. (this could be done on either 5 different
> calendars or one calendar, using different colors for each property)
>
> From the adults and children fields I would like to calculate the total
> number of guests. I'll have a field that is populated with this number,
> and
> from the result I would have a nightly rate calculated - with an option of
> manually changing this result.
>
> Finally, from the checkin/checkout dates and the airport transfer/arrival
> information I would like to be abe to create a report which shows
> checkins/checkouts / apartment, airport transfer info so I can give this
> info
> to our housekeeper and driver.
>
> Thanks for any suggestions you have ---
>
> Carole
>
>
>
>
>
> "Lon Orenstein" wrote:
>
>> Carole:
>>
>> Could you be more specific? What do you want to do with the new fields?
>>
>> You can use the custom fields by right clicking on the Calendar view,
>> choose
>> Customize Current View, click on Fields button, and in the Select
>> Available
>> Fields From dropdown you would choose User Defined Fields in Folder. You
>> can also use those fields in the Automatic Formatting section to create
>> conditions -- this might be what you're attempting.
>>
>> HTH,
>> Lon
>>
>> _________________________________________________
>> Lon Orenstein
>> pinpointtools
>> Lon[ at ]pinpointtools.com
>> www.pinpointtools.com
>>
>> "Carole Kezios" <CaroleKezios[ at ]discussions.microsoft.com> wrote in message
>> news:0D861FFC-37B1-4E3E-80EF-2099883FCB9D[ at ]microsoft.com...
>> > I'm sorry if I am posting this in the wrong place -
>> >
>> > I have added custom fields to my contact form and would like to link
>> > them
>> > to
>> > my calendar and have them calculate some other things. I don't know
>> > anything
>> > about programming, but I need to learn in order to make this work. What
>> > do
>> > I
>> > need to learn and where is the best place to look. Meaning, I know
>> > NOTHING
>> > about programming, and frankly I don't even understand what the
>> > difference
>> > between VB, VB.net etc are - I just really need to customize Outlook
>> > and
>> > BCM
>> > to work for me and I have not been successful in finding anyone who I
>> > can
>> > pay
>> > to do this - so, I figure I should just learn it myself.
>> >
>> > Thanks
>> >
>> > Carole
>> > --
>> > Greek Vacation Rentals, Inc
>> >
>>
>>
|
|
So is it just the report feature that is difficult in BCM? Is there any part
of what I want to achieve, like linking the custom fields to the calendar
that can be achieved? And calculating the number of nights (I am able to make
this work in an Outlook form, but I get errors when I try in a BCM form).
Would I have better luck if I just forgot about BCM and did this all in
Outlook, of course letting go of the connection between BCM and MOA07?
Carole
--
Greek Vacation Rentals, Inc
"Lon Orenstein" wrote:
[Quoted Text] > Well, this is definitely above your expertise level and probably can't just
> be done as a report -- you want some automation to happen which means code
> written to make that happen. BCM's report writer isn't powerful enough to
> customize what you want but MS Access's is and that isn't too hard to learn
> how to connect. Maybe some developers or programmers are lurking out there
> and would be interested in this project...
>
> HTH,
> Lon
>
> --
> _________________________________________________
> Lon Orenstein
> pinpointtools
> Lon[ at ]pinpointtools.com
> www.pinpointtools.com
>
>
> "Carole Kezios" <CaroleKezios[ at ]discussions.microsoft.com> wrote in message
> news:F0DBD464-B204-4631-85CB-E2466783BF5C[ at ]microsoft.com...
> > Hi Lon
> >
> > I have added some fields that include:
> > Checkin date, checkout date
> > Number of adults
> > Number of children
> > Airport pickup required
> > Airline
> > Flight number
> > Arrival time
> > Departure time
> >
> > From the checkin and checkout dates I would like to calculate the number
> > of
> > nights the guests are interested in. (I did figure out the DateDiff
> > command)
> > I would also like to add the dates to a calendar - with the option of
> > changing it from tentative when it is an inquiry, to "busy" when it is
> > actually a confirmed booking. (this could be done on either 5 different
> > calendars or one calendar, using different colors for each property)
> >
> > From the adults and children fields I would like to calculate the total
> > number of guests. I'll have a field that is populated with this number,
> > and
> > from the result I would have a nightly rate calculated - with an option of
> > manually changing this result.
> >
> > Finally, from the checkin/checkout dates and the airport transfer/arrival
> > information I would like to be abe to create a report which shows
> > checkins/checkouts / apartment, airport transfer info so I can give this
> > info
> > to our housekeeper and driver.
> >
> > Thanks for any suggestions you have ---
> >
> > Carole
> >
> >
> >
> >
> >
> > "Lon Orenstein" wrote:
> >
> >> Carole:
> >>
> >> Could you be more specific? What do you want to do with the new fields?
> >>
> >> You can use the custom fields by right clicking on the Calendar view,
> >> choose
> >> Customize Current View, click on Fields button, and in the Select
> >> Available
> >> Fields From dropdown you would choose User Defined Fields in Folder. You
> >> can also use those fields in the Automatic Formatting section to create
> >> conditions -- this might be what you're attempting.
> >>
> >> HTH,
> >> Lon
> >>
> >> _________________________________________________
> >> Lon Orenstein
> >> pinpointtools
> >> Lon[ at ]pinpointtools.com
> >> www.pinpointtools.com
> >>
> >> "Carole Kezios" <CaroleKezios[ at ]discussions.microsoft.com> wrote in message
> >> news:0D861FFC-37B1-4E3E-80EF-2099883FCB9D[ at ]microsoft.com...
> >> > I'm sorry if I am posting this in the wrong place -
> >> >
> >> > I have added custom fields to my contact form and would like to link
> >> > them
> >> > to
> >> > my calendar and have them calculate some other things. I don't know
> >> > anything
> >> > about programming, but I need to learn in order to make this work. What
> >> > do
> >> > I
> >> > need to learn and where is the best place to look. Meaning, I know
> >> > NOTHING
> >> > about programming, and frankly I don't even understand what the
> >> > difference
> >> > between VB, VB.net etc are - I just really need to customize Outlook
> >> > and
> >> > BCM
> >> > to work for me and I have not been successful in finding anyone who I
> >> > can
> >> > pay
> >> > to do this - so, I figure I should just learn it myself.
> >> >
> >> > Thanks
> >> >
> >> > Carole
> >> > --
> >> > Greek Vacation Rentals, Inc
> >> >
> >>
> >>
>
>
|
|
|