DBY
Who's Online
0 registered (), 7 Guests and 6 Spiders online.
Key: Admin, Global Mod, Mod
Latest Photo Gallery
light pole in the water
Eastern State Penitentiary - Philadelphia
Top Posters (30 Days)
Anartist 14
HarryB 12
Goofy 10
FinalDJ 10
m2h 8
Fitzy 5
Meph 2
Doorslammer 1
Nightowl 1
Dough 1
Topic Options
#160333 - 01/08/09 02:35 AM does anyone know...
WeerDo Offline
King of the Ewoks

Registered: 06/10/01
Posts: 3921
Loc: New York City
an easy way to make something like an appointment scheduling grid in Access 2007.

yea, i know... Access... but i'm doing a friend a favor and it is what it is.

what i'm looking for is something like the outlook calendar day view, where you have appointments in the time slots.

activeX component maybe?

i have an idea of how to manually make this, but i really want to not put that kind of effort into it.
on that note, i'll also take suggestions on brainstorm ideas of easy/quick ways to do it manually.

the idea i have is to make a grid form with labels at each time slot, and lots of vba code.

Top
#160334 - 01/08/09 03:29 AM Re: does anyone know... [Re: WeerDo]
Frollard Offline
911, do you need police, fire, or ambulance?

Registered: 01/13/02
Posts: 4948
Loc: Canada
I love google calendar...

sorry.
_________________________
In a world where the blind leads the blind, who do you follow?

Top
#160336 - 01/08/09 04:33 AM Re: does anyone know... [Re: Frollard]
WeerDo Offline
King of the Ewoks

Registered: 06/10/01
Posts: 3921
Loc: New York City
good job Frol... have a razzie.

one other thing, is there a way to expose a custom variable on a sub form that i can assign in the property sheet from parent level.

to draw a parallel and hopefully explain it better...

like in .net, you can make user controls (.ascx files). expose a variable like say background color. and when you use the user control multiple times, you can specify background color for each from the property sheet at the parent page. and end up with 4 or 5 of these usercontrols on the page with different background colors.

can i use a sub-form in this manner?

can i use anything in this manner?

why does access suck so much?

... why?

-edit-
a description that might help
lets say i've got a form made for the schedule. and i wanna display the schedules of three people... tom, dick, and harry.
i wanna be able to throw three subforms on the main form and give it a variable (user ID) that will get the schedule data for each person. subform1 displays tom, subform2 - dick, subform3 - harry.


Edited by WeerDo (01/08/09 04:56 AM)
Edit Reason: added stuff

Top
#160629 - 01/14/09 10:57 AM Re: does anyone know... [Re: WeerDo]
WeerDo Offline
King of the Ewoks

Registered: 06/10/01
Posts: 3921
Loc: New York City
so back to this now... i've got another question maybe one of you guys might have an idea about.

i need to access a subform's properties (its Tag specifically) from within the subform via VBA. huh?... i'll explain.

imagine theres a small cardboard box inside of a large cardboard box. (form and subform)
i write on the side of the small box, box1. (assign subform tag)

now, from within the small box (VBA in subform)...
i need to get outside and read the side of the box to know that it is box1 (read subfrom Tag value).

now heres the kicker...

the subform is on this form 4 times. so all VBA code i write in the subform will be saved across the board. so i CAN'T just hard-code the commands to go find Parent!SubForm1.Tag
cuz there are 4 of em, and they each have to reference their own property, SubForm1 refs the SubForm1.Tag, SubForm2 refs the SubForm2.Tag, and so on....

this would be so much easier like... anywhere else.

Top
#160937 - 01/21/09 07:12 AM Re: does anyone know... [Re: WeerDo]
Frollard Offline
911, do you need police, fire, or ambulance?

Registered: 01/13/02
Posts: 4948
Loc: Canada
I totally see where you're coming from - is there a way to store a list of the properties in the parent? I've been disconnected from VB for a long time...
_________________________
In a world where the blind leads the blind, who do you follow?

Top



Moderator:  Doorslammer, Nightowl, NightShade, Rez 
Shout Box

Today's Birthdays
No Birthdays
May
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31