Normal Topic Calendar DB How would you ? (Read 685 times)
proudpoppy
Full Member
Members
***
Offline


Do What ??

Posts: 420
Location: South Carolina
Joined: Apr 7th, 2004
Calendar DB How would you ?
Aug 3rd, 2005 at 5:00pm
Print Post Print Post  
1.In the calendar program authored by Ray would it be possible to xpost something from another dB into it.

2.How would you get the "~" entered at the same time?

3.If you wanted to use it for multiple people in the same application would all the variables have to be renamed for each employee?

Pretty sure the answer to #3 is Yes !!  Grin

                                               Thanks

  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Calendar DB How would you ?
Reply #1 - Aug 3rd, 2005 at 5:30pm
Print Post Print Post  
1. Yes but it will take some math and at least one more element. At the bottom of the form there are two elements which you can not see. A Calendar Month and a Calendar Year. If you combine them both into another element you have a unique Id which you can use for the XPost.

Now comes the Tricky part. The boxes(Elements) on the form are named D1 through D42. D1 being the very first box and D42 being the last. D1 is not always going to be the first of the month. The code for figuring out which D Box is going to hold the first days information can be found on the Next Record Button, The Prev Record button, or the Form on Form Entry event.

2. At the same time as the XPost, Simply just post a string variable
Code
Select All
Var vStuffToPost as String
vStuffToPost = "~" + ValueToBePosted
XPost("Data\Calendar.db",  "5_1995", "Cal_Key", vStuffToPost, "D26", "ADD") 



3. Are you talking about multiple people using the same form or have a different form for each person(Sally_Calendar, Joe_Calendar,..)?

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
proudpoppy
Full Member
Members
***
Offline


Do What ??

Posts: 420
Location: South Carolina
Joined: Apr 7th, 2004
Re: Calendar DB How would you ?
Reply #2 - Aug 3rd, 2005 at 6:23pm
Print Post Print Post  
Thanks Ray, sounds workable

I Plan to have a different form for each person.
Cheesy
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Calendar DB How would you ?
Reply #3 - Aug 3rd, 2005 at 6:33pm
Print Post Print Post  
You would need to have different GlobalValue() names for each form. I think there are two. CalendarMonth and CalendarYear. Other than that everything should be the same.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged