Form Programming Question...

G

Guest

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
 
T

tina

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
 
M

Manny

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


.
 
T

tina

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



.


.
 
A

Al Borges

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



.



.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top