April 20th, 2006, 01:40 PM
posted to microsoft.public.access.gettingstarted
|
|
|
Calendar and time sheet
One other thing......is the only word you know 'dimwit'...just wondering
"PC Datasheet" wrote:
Duane,
Just take a cue from the people who are class acts and quit supporting and
promoting Arno R and his band of dimwits. It's that simple. It's not
complicated. It's not difficult.
You are not impressing anyone siding with Arno R and his band of dimwits.
You don't see these class act people siding with Arno R. They adhere to
common netiquette rules. Whatever their feelings are, they stick to helping
people in the newsgroups.
There's an old saying, "birds of a feather flock together". Everyone is
seeing that you are just like Arno R and his band of dimwits.
--
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.
"Duane Hookom" wrote in message
...
Steve,
Just start behaving like everyone else. It's that simple. It's not
complicated. It's not difficult.
Everyone else understands this. Everyone else is very good at complying.
Everyone else sticks fairly close to common netiquette rules.
--
Duane Hookom
MS Access MVP
--
"PC Datasheet" wrote in message
ink.net...
Duane,
You continue to demonstrate that you are not even in the league with
class acts like Allen Browne, Ken Snell, Pieter Linden, Albert Kallal,
Fred G, Graham Mandello, Chuck Grimsby, MG Foster, and others.
--
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.
"Duane Hookom" wrote in message
...
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.
|