Form Programming Question...

  • Thread starter Thread starter Manny
  • Start date Start date
M

Manny

Hi there,

I don't know if what I'm trying to do here is quite
complicated or not, but I have no idea where to start.

I trying to build a kind of schedule on a form. what I
want to accomplish is this;

Display Dates like 25-May-04 - 26-may-04 .... as headers
on a subform and then being able to record stuff on those
columns. In other words, I want to be able to see a
schedule of each manager on a form.

Let's say,

Joe Blow

May-25-04 - May-26-04 - May-27-04 ....
Doing some stuff doing more stuff and doing more stuf
Doing more stuff

I don't know if I'm explainnig things good. Let me know
if you don't understand what I'm trying to accomplish
here.

Any inputs on this one anybody??

Thanks very much in advance.

Manny
 
have you mapped out and implemented your tables/relationships? if so, what
are they? it's hard to answer your question without any idea of how you are
storing the data and relating it.
 
Yes, What I'm trying to accomplish is something very
similar to Outlook has. Time on the left and dates across
the top.

Any ideas on how can I do this?

Thanks in Advance.

Manny
 
Manny, you didn't answer my questions. folks here mostly help solve specific
issues and answer specific questions, with specific solutions. i doubt that
anyone is going to instruct you on how to build a database from the ground
up. that's like asking somebody to tell you how to build a house, as opposed
to asking how to square a window frame or wire an outlet.
you need to start by learning the basics of relational databases, and the
basics of how to use the software. here's a list of resources (blatantly
copied from a Jeff Conrad post dated 5/26/04 <bows to Jeff>):

Number One on your start list:

http://www.mvps.org/access/
(A definite must!)

Microsoft Knowledge Base for searching:
http://support.microsoft.com/?scid=fh;[ln];kbhowto


Getting Started:

http://www.mvps.org/access/tencommandments.htm

Naming Conventions:
http://www.xoc.net/standards/rvbanc.asp

http://www.eade.com/AccessSIG/downloads.htm
(See the last download titled "Understanding Normalization")

http://support.microsoft.com/?id=234208
ACC2000: "Understanding Relational Database Design"

http://www.datatexcg.com/Downloads/DatabaseDesignTips1997.pdf

Interface Design topics:
http://www.isii.com/ui_design.html


Tutorial Style:

http://www.microsoft.com/Accessdev/articles/bapp97/toc.htm

Microsoft Access 2000: Building Applications with Forms and Reports
http://tinyurl.com/2szmm

http://www.dur.ac.uk/its/training/select/?selectCourse=IT47&campus=durham
(Sample practice file for download as well)

http://www.geekgirls.com/databasics_01.htm

http://mis.bus.sfu.ca/tutorials/MSAccess/tutorials.html

http://www.microsoft.com/office/previous/xp/columns/column06.asp

http://www.functionx.com/access/

http://www.bcschools.net/staff/AccessHelp.htm#Top

http://www.fontstuff.com/access/index.htm

http://www.fgcu.edu/support/office2000/access/

http://www.oit.duke.edu/ats/training/docs/access1/

http://cisnet.baruch.cuny.edu/holowczak/classes/2200/access/accessall.html#sec_intro

http://ddmara.tripod.com/access/index.html


Sample Database Models/Table Designs:

http://www.databaseanswers.com/data_models/index.htm


Download Samples:

http://rogersaccesslibrary.com/TableOfContents3.asp

http://www.invisibleinc.com/divFiles.cfm?divDivID=4

http://www.candace-tripp.com/access_downloads.htm

http://www.datastrat.com/DataStrat2.html


The mighty Sensei Leban's site for all things magical:
(Please bow in reverence on your way in.)

http://www.lebans.com/


Advanced Topics:

http://www.trigeminal.com/utility.asp

http://www.mentalis.org/index2.shtml


Misc: Downloads/Samples/Helpful Articles

http://www.granite.ab.ca/access/accesslinks.htm

http://allenbrowne.com/tips.html

http://www.viescas.com

http://www.daiglenet.com/msaccess.htm

http://www.users.bigpond.com/papwalker/

http://www.applecore99.com/index.asp

http://www.helenfeddema.com/access.htm

http://www.dbases.net/knowledge_base/

http://ourworld.compuserve.com/homepages/attac-cg/

http://www.aadconsulting.com/index.html

http://accdevel.tripod.com/

http://ffdba.com/downloads.htm

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

http://www.mvps.org/btmtz/


Helpful Articles/Code Samples:

http://www.pacificdb.com.au/MVP/MVPCode.htm

http://members.rogers.com/douglas.j.steele/AccessIndex.html

http://www.winsoft.sk/daofaq.htm

http://www.calvinsmithsoftware.com/HardToFindTips.htm

http://www.mvps.org/vbnet/

http://www.master-office.com/developers.htm

http://www.trevor.easynet.co.uk/AccFAQ/


A massive list of other Access links:

http://www.geocities.com/waddly/accory.html

http://dmoz.org/Computers/Software/Databases/MS_Access/


Add-Ins/Utilities:

http://mphillipson.users.btopenworld.com/

http://www.fmsinc.com/

http://www.moshannon.com/

http://www.rickworld.com

http://www.peterssoftware.com/ss.htm

http://www.dbi-tech.com/default.asp

http://www.zada.com.au/accessaddins.htm

http://www.mztools.com


Live Access chats every Tuesday and Thursday with St. Vinson:

http://go.compuserve.com/msdevapps?loc=us&access=public


Access User-Level Security:

Security FAQ (the Security Bible):
http://support.microsoft.com/?kbid=207793

Jack Macdonald's Security Document:
http://www.geocities.com/jacksonmacd/AccessSecurity.html

Lynn Trapp's Ten Security Steps:
http://www.ltcomputerdesigns.com/Security.htm

Joan Wild's Tips:
http://www.jmwild.com/security02.htm


Creating menu bars and tool bars:

http://www.microsoft.com/Accessdev/articles/bapp97/chapters/ba01_6.htm


Book Recommendations:

http://www.developershandbook.com/
(A VERY good book to have)

http://www.viescas.com/Info/books.htm

http://www.fmsinc.com/toplevel/books.htm


Some of the MVP web sites:

http://www.mvps.org/links.html


Database Recovery:

http://www.pksolutions.com/


Search Google archives on Access newsgroup posts:

http://tinyurl.com/ctj2
 
Yes Tina, I know what you're saying. even though I've
developing Access Databases for some years now, I just
don't know where to start here on this specific need.

I'm NOT asking anyone to help me start my database from
the ground up, I'm just asking for some advince where or
how to start or some hints how to structure this specific
need. This scheduler that I'm trying to build is just a
part of a much larger system that I'm builing.

Sorry to the group If anybody thought that I was trying
anyone to help me build my entire system.

Thanks,

Manny

-----Original Message-----
Manny, you didn't answer my questions. folks here mostly help solve specific
issues and answer specific questions, with specific solutions. i doubt that
anyone is going to instruct you on how to build a database from the ground
up. that's like asking somebody to tell you how to build a house, as opposed
to asking how to square a window frame or wire an outlet.
you need to start by learning the basics of relational databases, and the
basics of how to use the software. here's a list of resources (blatantly
copied from a Jeff Conrad post dated 5/26/04 <bows to Jeff>):

Number One on your start list:

http://www.mvps.org/access/
(A definite must!)

Microsoft Knowledge Base for searching:
http://support.microsoft.com/?scid=fh;[ln];kbhowto


Getting Started:

http://www.mvps.org/access/tencommandments.htm

Naming Conventions:
http://www.xoc.net/standards/rvbanc.asp

http://www.eade.com/AccessSIG/downloads.htm
(See the last download titled "Understanding Normalization")

http://support.microsoft.com/?id=234208
ACC2000: "Understanding Relational Database Design"

http://www.datatexcg.com/Downloads/DatabaseDesignTips1997 ..pdf

Interface Design topics:
http://www.isii.com/ui_design.html


Tutorial Style:

http://www.microsoft.com/Accessdev/articles/bapp97/toc.ht m

Microsoft Access 2000: Building Applications with Forms and Reports
http://tinyurl.com/2szmm

http://www.dur.ac.uk/its/training/select/? selectCourse=IT47&campus=durham
(Sample practice file for download as well)

http://www.geekgirls.com/databasics_01.htm

http://mis.bus.sfu.ca/tutorials/MSAccess/tutorials.html

http://www.microsoft.com/office/previous/xp/columns/colum n06.asp
ss/accessall.html#sec_intro

http://ddmara.tripod.com/access/index.html


Sample Database Models/Table Designs:

http://www.databaseanswers.com/data_models/index.htm


Download Samples:

http://rogersaccesslibrary.com/TableOfContents3.asp

http://www.invisibleinc.com/divFiles.cfm?divDivID=4

http://www.candace-tripp.com/access_downloads.htm

http://www.datastrat.com/DataStrat2.html


The mighty Sensei Leban's site for all things magical:
(Please bow in reverence on your way in.)

http://www.lebans.com/


Advanced Topics:

http://www.trigeminal.com/utility.asp

http://www.mentalis.org/index2.shtml


Misc: Downloads/Samples/Helpful Articles

http://www.granite.ab.ca/access/accesslinks.htm

http://allenbrowne.com/tips.html

http://www.viescas.com

http://www.daiglenet.com/msaccess.htm

http://www.users.bigpond.com/papwalker/

http://www.applecore99.com/index.asp

http://www.helenfeddema.com/access.htm

http://www.dbases.net/knowledge_base/

http://ourworld.compuserve.com/homepages/attac-cg/

http://www.aadconsulting.com/index.html

http://accdevel.tripod.com/

http://ffdba.com/downloads.htm

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.ht ml

http://www.mvps.org/btmtz/


Helpful Articles/Code Samples:

http://www.pacificdb.com.au/MVP/MVPCode.htm

http://members.rogers.com/douglas.j.steele/AccessIndex.ht ml

http://www.winsoft.sk/daofaq.htm

http://www.calvinsmithsoftware.com/HardToFindTips.htm

http://www.mvps.org/vbnet/

http://www.master-office.com/developers.htm

http://www.trevor.easynet.co.uk/AccFAQ/


A massive list of other Access links:

http://www.geocities.com/waddly/accory.html

http://dmoz.org/Computers/Software/Databases/MS_Access/


Add-Ins/Utilities:

http://mphillipson.users.btopenworld.com/

http://www.fmsinc.com/

http://www.moshannon.com/

http://www.rickworld.com

http://www.peterssoftware.com/ss.htm

http://www.dbi-tech.com/default.asp

http://www.zada.com.au/accessaddins.htm

http://www.mztools.com


Live Access chats every Tuesday and Thursday with St. Vinson:

http://go.compuserve.com/msdevapps?loc=us&access=public


Access User-Level Security:

Security FAQ (the Security Bible):
http://support.microsoft.com/?kbid=207793

Jack Macdonald's Security Document:
http://www.geocities.com/jacksonmacd/AccessSecurity.html

Lynn Trapp's Ten Security Steps:
http://www.ltcomputerdesigns.com/Security.htm

Joan Wild's Tips:
http://www.jmwild.com/security02.htm


Creating menu bars and tool bars:

http://www.microsoft.com/Accessdev/articles/bapp97/chapte rs/ba01_6.htm


Book Recommendations:

http://www.developershandbook.com/
(A VERY good book to have)

http://www.viescas.com/Info/books.htm

http://www.fmsinc.com/toplevel/books.htm


Some of the MVP web sites:

http://www.mvps.org/links.html


Database Recovery:

http://www.pksolutions.com/


Search Google archives on Access newsgroup posts:

http://tinyurl.com/ctj2




Yes, What I'm trying to accomplish is something very
similar to Outlook has. Time on the left and dates across
the top.

Any ideas on how can I do this?

Thanks in Advance.

Manny


.
 
ok, sorry for the misunderstanding. good luck! :)


Manny said:
Yes Tina, I know what you're saying. even though I've
developing Access Databases for some years now, I just
don't know where to start here on this specific need.

I'm NOT asking anyone to help me start my database from
the ground up, I'm just asking for some advince where or
how to start or some hints how to structure this specific
need. This scheduler that I'm trying to build is just a
part of a much larger system that I'm builing.

Sorry to the group If anybody thought that I was trying
anyone to help me build my entire system.

Thanks,

Manny

-----Original Message-----
Manny, you didn't answer my questions. folks here mostly help solve specific
issues and answer specific questions, with specific solutions. i doubt that
anyone is going to instruct you on how to build a database from the ground
up. that's like asking somebody to tell you how to build a house, as opposed
to asking how to square a window frame or wire an outlet.
you need to start by learning the basics of relational databases, and the
basics of how to use the software. here's a list of resources (blatantly
copied from a Jeff Conrad post dated 5/26/04 <bows to Jeff>):

Number One on your start list:

http://www.mvps.org/access/
(A definite must!)

Microsoft Knowledge Base for searching:
http://support.microsoft.com/?scid=fh;[ln];kbhowto


Getting Started:

http://www.mvps.org/access/tencommandments.htm

Naming Conventions:
http://www.xoc.net/standards/rvbanc.asp

http://www.eade.com/AccessSIG/downloads.htm
(See the last download titled "Understanding Normalization")

http://support.microsoft.com/?id=234208
ACC2000: "Understanding Relational Database Design"

http://www.datatexcg.com/Downloads/DatabaseDesignTips1997 .pdf

Interface Design topics:
http://www.isii.com/ui_design.html


Tutorial Style:

http://www.microsoft.com/Accessdev/articles/bapp97/toc.ht m

Microsoft Access 2000: Building Applications with Forms and Reports
http://tinyurl.com/2szmm

http://www.dur.ac.uk/its/training/select/? selectCourse=IT47&campus=durham
(Sample practice file for download as well)

http://www.geekgirls.com/databasics_01.htm

http://mis.bus.sfu.ca/tutorials/MSAccess/tutorials.html

http://www.microsoft.com/office/previous/xp/columns/colum n06.asp
ss/accessall.html#sec_intro

http://ddmara.tripod.com/access/index.html


Sample Database Models/Table Designs:

http://www.databaseanswers.com/data_models/index.htm


Download Samples:

http://rogersaccesslibrary.com/TableOfContents3.asp

http://www.invisibleinc.com/divFiles.cfm?divDivID=4

http://www.candace-tripp.com/access_downloads.htm

http://www.datastrat.com/DataStrat2.html


The mighty Sensei Leban's site for all things magical:
(Please bow in reverence on your way in.)

http://www.lebans.com/


Advanced Topics:

http://www.trigeminal.com/utility.asp

http://www.mentalis.org/index2.shtml


Misc: Downloads/Samples/Helpful Articles

http://www.granite.ab.ca/access/accesslinks.htm

http://allenbrowne.com/tips.html

http://www.viescas.com

http://www.daiglenet.com/msaccess.htm

http://www.users.bigpond.com/papwalker/

http://www.applecore99.com/index.asp

http://www.helenfeddema.com/access.htm

http://www.dbases.net/knowledge_base/

http://ourworld.compuserve.com/homepages/attac-cg/

http://www.aadconsulting.com/index.html

http://accdevel.tripod.com/

http://ffdba.com/downloads.htm

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.ht ml

http://www.mvps.org/btmtz/


Helpful Articles/Code Samples:

http://www.pacificdb.com.au/MVP/MVPCode.htm

http://members.rogers.com/douglas.j.steele/AccessIndex.ht ml

http://www.winsoft.sk/daofaq.htm

http://www.calvinsmithsoftware.com/HardToFindTips.htm

http://www.mvps.org/vbnet/

http://www.master-office.com/developers.htm

http://www.trevor.easynet.co.uk/AccFAQ/


A massive list of other Access links:

http://www.geocities.com/waddly/accory.html

http://dmoz.org/Computers/Software/Databases/MS_Access/


Add-Ins/Utilities:

http://mphillipson.users.btopenworld.com/

http://www.fmsinc.com/

http://www.moshannon.com/

http://www.rickworld.com

http://www.peterssoftware.com/ss.htm

http://www.dbi-tech.com/default.asp

http://www.zada.com.au/accessaddins.htm

http://www.mztools.com


Live Access chats every Tuesday and Thursday with St. Vinson:

http://go.compuserve.com/msdevapps?loc=us&access=public


Access User-Level Security:

Security FAQ (the Security Bible):
http://support.microsoft.com/?kbid=207793

Jack Macdonald's Security Document:
http://www.geocities.com/jacksonmacd/AccessSecurity.html

Lynn Trapp's Ten Security Steps:
http://www.ltcomputerdesigns.com/Security.htm

Joan Wild's Tips:
http://www.jmwild.com/security02.htm


Creating menu bars and tool bars:

http://www.microsoft.com/Accessdev/articles/bapp97/chapte rs/ba01_6.htm


Book Recommendations:

http://www.developershandbook.com/
(A VERY good book to have)

http://www.viescas.com/Info/books.htm

http://www.fmsinc.com/toplevel/books.htm


Some of the MVP web sites:

http://www.mvps.org/links.html


Database Recovery:

http://www.pksolutions.com/


Search Google archives on Access newsgroup posts:

http://tinyurl.com/ctj2




Yes, What I'm trying to accomplish is something very
similar to Outlook has. Time on the left and dates across
the top.

Any ideas on how can I do this?

Thanks in Advance.

Manny


-----Original Message-----
Hi there,

I don't know if what I'm trying to do here is quite
complicated or not, but I have no idea where to start.

I trying to build a kind of schedule on a form. what I
want to accomplish is this;

Display Dates like 25-May-04 - 26-may-04 .... as headers
on a subform and then being able to record stuff on
those
columns. In other words, I want to be able to see a
schedule of each manager on a form.

Let's say,

Joe Blow

May-25-04 - May-26-04 - May-27-04 ....
Doing some stuff doing more stuff and doing more stuf
Doing more stuff

I don't know if I'm explainnig things good. Let me know
if you don't understand what I'm trying to accomplish
here.

Any inputs on this one anybody??

Thanks very much in advance.

Manny



.


.
 
Hi Manny:

You need to have one form with 6 attached subforms.The Parent form will
have, say, today's date. On the Parent form place 7 unbound fields, each
from, say, Date() to Date()+6. Now bind the various subforms to these
fields! Tonight I'm going to place on my Yahoo download site my scheduling
applet that I use in my medical office that covers all of the various
"tips". The URL is: http://f1.pg.briefcase.yahoo.com/bc/alborgmd . Tonight
I'll download this file and call it "Access Scheduler".

Regards,
Al

tina said:
ok, sorry for the misunderstanding. good luck! :)


Manny said:
Yes Tina, I know what you're saying. even though I've
developing Access Databases for some years now, I just
don't know where to start here on this specific need.

I'm NOT asking anyone to help me start my database from
the ground up, I'm just asking for some advince where or
how to start or some hints how to structure this specific
need. This scheduler that I'm trying to build is just a
part of a much larger system that I'm builing.

Sorry to the group If anybody thought that I was trying
anyone to help me build my entire system.

Thanks,

Manny

-----Original Message-----
Manny, you didn't answer my questions. folks here mostly help solve specific
issues and answer specific questions, with specific solutions. i doubt that
anyone is going to instruct you on how to build a database from the ground
up. that's like asking somebody to tell you how to build a house, as opposed
to asking how to square a window frame or wire an outlet.
you need to start by learning the basics of relational databases, and the
basics of how to use the software. here's a list of resources (blatantly
copied from a Jeff Conrad post dated 5/26/04 <bows to Jeff>):

Number One on your start list:

http://www.mvps.org/access/
(A definite must!)

Microsoft Knowledge Base for searching:
http://support.microsoft.com/?scid=fh;[ln];kbhowto


Getting Started:

http://www.mvps.org/access/tencommandments.htm

Naming Conventions:
http://www.xoc.net/standards/rvbanc.asp

http://www.eade.com/AccessSIG/downloads.htm
(See the last download titled "Understanding Normalization")

http://support.microsoft.com/?id=234208
ACC2000: "Understanding Relational Database Design"

http://www.datatexcg.com/Downloads/DatabaseDesignTips1997 .pdf

Interface Design topics:
http://www.isii.com/ui_design.html


Tutorial Style:

http://www.microsoft.com/Accessdev/articles/bapp97/toc.ht m

Microsoft Access 2000: Building Applications with Forms and Reports
http://tinyurl.com/2szmm

http://www.dur.ac.uk/its/training/select/? selectCourse=IT47&campus=durham
(Sample practice file for download as well)

http://www.geekgirls.com/databasics_01.htm

http://mis.bus.sfu.ca/tutorials/MSAccess/tutorials.html

http://www.microsoft.com/office/previous/xp/columns/colum n06.asp
ss/accessall.html#sec_intro

http://ddmara.tripod.com/access/index.html


Sample Database Models/Table Designs:

http://www.databaseanswers.com/data_models/index.htm


Download Samples:

http://rogersaccesslibrary.com/TableOfContents3.asp

http://www.invisibleinc.com/divFiles.cfm?divDivID=4

http://www.candace-tripp.com/access_downloads.htm

http://www.datastrat.com/DataStrat2.html


The mighty Sensei Leban's site for all things magical:
(Please bow in reverence on your way in.)

http://www.lebans.com/


Advanced Topics:

http://www.trigeminal.com/utility.asp

http://www.mentalis.org/index2.shtml


Misc: Downloads/Samples/Helpful Articles

http://www.granite.ab.ca/access/accesslinks.htm

http://allenbrowne.com/tips.html

http://www.viescas.com

http://www.daiglenet.com/msaccess.htm

http://www.users.bigpond.com/papwalker/

http://www.applecore99.com/index.asp

http://www.helenfeddema.com/access.htm

http://www.dbases.net/knowledge_base/

http://ourworld.compuserve.com/homepages/attac-cg/

http://www.aadconsulting.com/index.html

http://accdevel.tripod.com/

http://ffdba.com/downloads.htm

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.ht ml

http://www.mvps.org/btmtz/


Helpful Articles/Code Samples:

http://www.pacificdb.com.au/MVP/MVPCode.htm

http://members.rogers.com/douglas.j.steele/AccessIndex.ht ml

http://www.winsoft.sk/daofaq.htm

http://www.calvinsmithsoftware.com/HardToFindTips.htm

http://www.mvps.org/vbnet/

http://www.master-office.com/developers.htm

http://www.trevor.easynet.co.uk/AccFAQ/


A massive list of other Access links:

http://www.geocities.com/waddly/accory.html

http://dmoz.org/Computers/Software/Databases/MS_Access/


Add-Ins/Utilities:

http://mphillipson.users.btopenworld.com/

http://www.fmsinc.com/

http://www.moshannon.com/

http://www.rickworld.com

http://www.peterssoftware.com/ss.htm

http://www.dbi-tech.com/default.asp

http://www.zada.com.au/accessaddins.htm

http://www.mztools.com


Live Access chats every Tuesday and Thursday with St. Vinson:

http://go.compuserve.com/msdevapps?loc=us&access=public


Access User-Level Security:

Security FAQ (the Security Bible):
http://support.microsoft.com/?kbid=207793

Jack Macdonald's Security Document:
http://www.geocities.com/jacksonmacd/AccessSecurity.html

Lynn Trapp's Ten Security Steps:
http://www.ltcomputerdesigns.com/Security.htm

Joan Wild's Tips:
http://www.jmwild.com/security02.htm


Creating menu bars and tool bars:

http://www.microsoft.com/Accessdev/articles/bapp97/chapte rs/ba01_6.htm


Book Recommendations:

http://www.developershandbook.com/
(A VERY good book to have)

http://www.viescas.com/Info/books.htm

http://www.fmsinc.com/toplevel/books.htm


Some of the MVP web sites:

http://www.mvps.org/links.html


Database Recovery:

http://www.pksolutions.com/


Search Google archives on Access newsgroup posts:

http://tinyurl.com/ctj2




Yes, What I'm trying to accomplish is something very
similar to Outlook has. Time on the left and dates across
the top.

Any ideas on how can I do this?

Thanks in Advance.

Manny


-----Original Message-----
Hi there,

I don't know if what I'm trying to do here is quite
complicated or not, but I have no idea where to start.

I trying to build a kind of schedule on a form. what I
want to accomplish is this;

Display Dates like 25-May-04 - 26-may-04 .... as headers
on a subform and then being able to record stuff on
those
columns. In other words, I want to be able to see a
schedule of each manager on a form.

Let's say,

Joe Blow

May-25-04 - May-26-04 - May-27-04 ....
Doing some stuff doing more stuff and doing more stuf
Doing more stuff

I don't know if I'm explainnig things good. Let me know
if you don't understand what I'm trying to accomplish
here.

Any inputs on this one anybody??

Thanks very much in advance.

Manny



.



.
 
Back
Top