A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Calendar and time sheet



 
 
Thread Tools Display Modes
  #1  
Old December 2nd, 2005, 09:41 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Calendar and time sheet

Does anyone know how to make this possible ad updatable in MS Access?

Description - 12/1 - 12/2 - 12/3...... 12/31
Sample1 - 2 - - 5 .....etc
Sample2 - 6 - 8 - 3 .....etc
:
:
etc.


Thanks.
  #2  
Old December 3rd, 2005, 02:05 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Calendar and time sheet

I can put your sample results in a calendar form and calendar report for you
for a reasonable fee. If you are interested, contact me at my email address
below,


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

Over 1000 Access users have come to me for help. My fees are very
reasonable.


"Fehn" wrote in message
...
Does anyone know how to make this possible ad updatable in MS Access?

Description - 12/1 - 12/2 - 12/3...... 12/31
Sample1 - 2 - - 5 .....etc
Sample2 - 6 - 8 - 3 .....etc
:
:
etc.


Thanks.



  #3  
Old December 3rd, 2005, 02:16 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Calendar and time sheet


"PC Datasheet" schreef in bericht link.net...
I can put your sample results in a calendar form and calendar report for you
for a reasonable fee. If you are interested, contact me at my email address
below,


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

Over 1000 Access users have come to me for help. My fees are very
reasonable.



--
To the OP:

Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html (updated)

Arno R
  #4  
Old December 3rd, 2005, 03:23 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Calendar and time sheet

Fehn,

Consider what another responder said about this obnoxious character and then
decide if you want my help. I can put your sample results in a calendar form
and calendar report for you for a reasonable fee. Over 1000 users have come
from the newsgroups requesting help and trusting me.

"If you have anything to contribute to the group, contribute. Your war
with Datasheet is simply ****ing and moaning in the wind for the sake of
nothing. Grow up and get a life."

Salad

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

Over 1000 Access users have come to me for help. My fees are very
reasonable.




"StopThisAdvertising" StopThisAdvertising@Data**** wrote in message
. ..

"PC Datasheet" schreef in bericht
link.net...
I can put your sample results in a calendar form and calendar report for
you
for a reasonable fee. If you are interested, contact me at my email
address
below,


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

Over 1000 Access users have come to me for help. My fees are very
reasonable.



--
To the OP:

Most people here have a common belief that the newsgroups are for *free
exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell
his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html (updated)

Arno R


  #5  
Old December 3rd, 2005, 04:52 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default PCD is soliciting again

"PC Datasheet" wrote in message
link.net...
I can put your sample results in a calendar form and calendar report for
you for a reasonable fee. If you are interested, contact me at my email
address below,


These newsgroups are for free peer to peer support, not a for preying on the
users for profit.

John... Visio MVP


  #6  
Old December 3rd, 2005, 04:57 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Another PCD Rant

"PC Datasheet" wrote in message
nk.net...
Fehn,

Consider what another responder said about this obnoxious character and
then decide if you want my help.


More personal insults? Is that in line with the code of conduct for these
newsgroups?

I can put your sample results in a calendar form and calendar report for
you for a reasonable fee.


Your overpriced. The standard fee for help in these newsgroups is free.

John... Visio MVP


  #7  
Old December 3rd, 2005, 05:17 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Calendar and time sheet

Sorry PC Datasheet! But the reason I posted in this newsgroup is because I
know that this is a "friendly" exchange of ideas and knowledge! Not for
advertising!

I am not getting paid to do this database, I am doing this for my own
knowlege gain. So if no one in this group doesn't know or wasn't able to
help, then so be it! i will just have to do it in my own.

Thank you for reading my post, but also understand that Arno R. is just
protecting the users of this newsgroup and if what you say in you advertising
is true "Over 1000 Access users have come to me for help", then you woudn't
need to reply to anybody's questions with your advertising.

Thanks again.

"PC Datasheet" wrote:

Fehn,

Consider what another responder said about this obnoxious character and then
decide if you want my help. I can put your sample results in a calendar form
and calendar report for you for a reasonable fee. Over 1000 users have come
from the newsgroups requesting help and trusting me.

"If you have anything to contribute to the group, contribute. Your war
with Datasheet is simply ****ing and moaning in the wind for the sake of
nothing. Grow up and get a life."

Salad

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

Over 1000 Access users have come to me for help. My fees are very
reasonable.




"StopThisAdvertising" StopThisAdvertising@Data**** wrote in message
. ..

"PC Datasheet" schreef in bericht
link.net...
I can put your sample results in a calendar form and calendar report for
you
for a reasonable fee. If you are interested, contact me at my email
address
below,


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

Over 1000 Access users have come to me for help. My fees are very
reasonable.



--
To the OP:

Most people here have a common belief that the newsgroups are for *free
exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell
his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html (updated)

Arno R



  #8  
Old December 3rd, 2005, 05:59 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Calendar and time sheet

Use a table with ____ fields.
1 - SampleResultID
2 - SampleID
3 - Year
4 - Month
5 - 36 Day1 to Day31
Store sample results in fields 5 to 36.

In your form use some Date math in the OnCurrentEvent to determine whether
to display fields Day29 to Day31.

Sorry for the previous post! Thought you might just like to see your sample
results in a calendar format.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

Over 1050 users have come from the newsgroups trusting me and requesting
help.
My fees are very reasonable.



"Fehn" wrote in message
...
Sorry PC Datasheet! But the reason I posted in this newsgroup is because I
know that this is a "friendly" exchange of ideas and knowledge! Not for
advertising!

I am not getting paid to do this database, I am doing this for my own
knowlege gain. So if no one in this group doesn't know or wasn't able to
help, then so be it! i will just have to do it in my own.

Thank you for reading my post, but also understand that Arno R. is just
protecting the users of this newsgroup and if what you say in you
advertising
is true "Over 1000 Access users have come to me for help", then you
woudn't
need to reply to anybody's questions with your advertising.

Thanks again.

"PC Datasheet" wrote:

Fehn,

Consider what another responder said about this obnoxious character and
then
decide if you want my help. I can put your sample results in a calendar
form
and calendar report for you for a reasonable fee. Over 1000 users have
come
from the newsgroups requesting help and trusting me.

"If you have anything to contribute to the group, contribute. Your war
with Datasheet is simply ****ing and moaning in the wind for the sake of
nothing. Grow up and get a life."

Salad

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

Over 1000 Access users have come to me for help. My fees are very
reasonable.




"StopThisAdvertising" StopThisAdvertising@Data**** wrote in message
. ..

"PC Datasheet" schreef in bericht
link.net...
I can put your sample results in a calendar form and calendar report for
you
for a reasonable fee. If you are interested, contact me at my email
address
below,


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

Over 1000 Access users have come to me for help. My fees are very
reasonable.



--
To the OP:

Most people here have a common belief that the newsgroups are for *free
exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to
sell
his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html (updated)

Arno R





  #9  
Old December 3rd, 2005, 08:31 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Calendar and time sheet

I would keep all the data in normalized tables (and ignore or verbally abuse
PC Datasheet).

tblSamples
================
SampleID Autonumber primary key
SampleTypeID link to table containing descriptions
SampleDate
SampleValue

If you really need a form like this, consider
-writing code that loads your data into a "flat" table for editing
more code would be needed to normalize after editing
-create an unbound form like a grid of text boxes.
use code to fill the grid with data and then to
save the data to your normalized table

I wrote some code for another poster a while back the filled a bunch of text
boxes with customer names and order dates from Northwind. One of the keys
was to use a scheme for naming the text boxes as below:

txtCust1 txtOrdDate1_1 txtOrdDate1_2 ...etc...
txtCust2 txtOrdDate2_1 txtOrdDate2_2 ...etc...
txtCust3 txtOrdDate3_1 txtOrdDate3_2 ...etc...
...etc... ...etc... ...etc... ...etc...

The code to fill the text boxes with customers and order dates:
Private Sub cmdPullOrderDates_Click()
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim strSQL As String
Dim intCustomer As Integer
Dim strCustomer As String
Dim intOrder As Integer
strSQL = "SELECT CompanyName, OrderDate " & _
"FROM Customers INNER JOIN " & _
"Orders ON Customers.CustomerID = Orders.CustomerID " & _
"ORDER BY CompanyName, OrderDate"
Set db = CurrentDb
Set rs = db.OpenRecordset(strSQL)
rs.MoveFirst
With rs
intCustomer = 0
Do Until .EOF Or intCustomer 2
strCustomer = .Fields("CompanyName")
intCustomer = intCustomer + 1
Me("txtCust" & intCustomer) = strCustomer
intOrder = 0
Do Until strCustomer .Fields("CompanyName") Or intOrder 4
intOrder = intOrder + 1
Me("txtOrdDate" & intCustomer & "_" & intOrder) =
..Fields("OrderDate")
.MoveNext
Loop
Loop
.Close
End With
Set rs = Nothing
Set db = Nothing
End Sub

--
Duane Hookom
MS Access MVP


"Fehn" wrote in message
...
Does anyone know how to make this possible ad updatable in MS Access?

Description - 12/1 - 12/2 - 12/3...... 12/31
Sample1 - 2 - - 5 .....etc
Sample2 - 6 - 8 - 3 .....etc
:
:
etc.


Thanks.



  #10  
Old December 3rd, 2005, 11:15 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Calendar and time sheet

Your example looks a lot like a pivot table; some grouping at the top and
left with some data in the center of the table.
You just might be able to get to where you want to be using a clever query
and then displaying it in a pivot table.

Ed Warren.

"Fehn" wrote in message
...
Does anyone know how to make this possible ad updatable in MS Access?

Description - 12/1 - 12/2 - 12/3...... 12/31
Sample1 - 2 - - 5 .....etc
Sample2 - 6 - 8 - 3 .....etc
:
:
etc.


Thanks.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I fill a time sheet from a calendar PeterM General Discussion 6 November 29th, 2005 10:24 PM
Time Zone suggestions for Outlook Calendar Ben Knox Calendar 2 October 20th, 2005 03:42 PM
Calendar Time Linn Allen Calendar 1 September 20th, 2005 10:04 PM
Calendar should allow scheduling appointments in any time zone Art H Calendar 1 August 19th, 2005 11:25 PM
Access Calendar lost General Discussion 2 July 7th, 2004 04:58 AM


All times are GMT +1. The time now is 11:06 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.