Newbie: Need Help! Access 2002 Web Page on LAN how to get data

  • Thread starter Thread starter BigMan
  • Start date Start date
B

BigMan

Can anyone help me.

We will be working on Migrating PCs to Windows XP and need to have a
schedule that someone can go to and enter their name and pick a date to have
their PC migrated. We have a set number of PC that can be done on each of
those days. Ex. 9 PCs can be migrated on Wednesday and only 5 on Thursday.
They will be done on a first come first serve basis. I created a simple DB
in Outlook 2002 it only has 1 table:
UserID,First_Name,Last_Name,Date_Sched,Comments.
When they enter their date no one else can use their slot and when it
reaches 9 then that day can hold no more so they would pick another day
until the shedules are filled. I know this is a bit
much but don't know how get the database to stop at the 9th record on
Wednesday and allow only 5 on Thursday etc.. I was thinking I could write a
script on the web page that will scan the database but don't know how to get
the script to read into the Database. When I tried it shows the variable as
an [object]. I don't have much experience with Access just enough to get
into trouble :-) I appreciate any feed back and all help. Thanks in
advanced.
 
Access is a file server database, so all the business logic must take place
before the data gets to the tables. If you are using Outlook as an
interface, you'll need to write your rules in the Outlook form. My own
experience is that Outlook is extremely limited in what it can do, but I
suggest you post your question on one of the Outlook newsgroups for a better
answer.

If you can use an Access form, you can write a VBA procedure in the
BeforeUpdate event. Try something like (aircode)

Sub txtMyDate_BeforeUpdate(Cancel As Integer)
Dim i As Integer

Select Case WeekDay(Me.txtMyDate)

Case vbWednesday
i = DCount("DateField", "MyTable", "DateField = #" & Me.txtMyDate &
"#")
If i >= 9 Then
MsgBox "Too many, pick another date"
Cancel = True
End If

Case vbThursday
i = DCount("DateField", "MyTable", "DateField = #" & Me.txtMyDate &
"#")
If i >= 5 Then
MsgBox "Too many, pick another date"
Cancel = True
End If

Case Else

End Select

End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

BigMan said:
Can anyone help me.

We will be working on Migrating PCs to Windows XP and need to have a
schedule that someone can go to and enter their name and pick a date to have
their PC migrated. We have a set number of PC that can be done on each of
those days. Ex. 9 PCs can be migrated on Wednesday and only 5 on Thursday.
They will be done on a first come first serve basis. I created a simple DB
in Outlook 2002 it only has 1 table:
UserID,First_Name,Last_Name,Date_Sched,Comments.
When they enter their date no one else can use their slot and when it
reaches 9 then that day can hold no more so they would pick another day
until the shedules are filled. I know this is a bit
much but don't know how get the database to stop at the 9th record on
Wednesday and allow only 5 on Thursday etc.. I was thinking I could write a
script on the web page that will scan the database but don't know how to get
the script to read into the Database. When I tried it shows the variable as
an [object]. I don't have much experience with Access just enough to get
into trouble :-) I appreciate any feed back and all help. Thanks in
advanced.
Click to expand...
 
Sorry about that, I meant I created a simple database in Access2002. The
thing is that I would like people to access the Webpage that I created in
Access. It allows me to put the DB file in a shared folder and let everyone
add their name via a web page. (Excel is too messy and only 1 person can
update it at a time and can erase peoples name etc.) Can I somehow use this
in the web page that Access creates? Again thank you for your help.
Arvin Meyer said:
Access is a file server database, so all the business logic must take place
before the data gets to the tables. If you are using Outlook as an
interface, you'll need to write your rules in the Outlook form. My own
experience is that Outlook is extremely limited in what it can do, but I
suggest you post your question on one of the Outlook newsgroups for a better
answer.

If you can use an Access form, you can write a VBA procedure in the
BeforeUpdate event. Try something like (aircode)

Sub txtMyDate_BeforeUpdate(Cancel As Integer)
Dim i As Integer

Select Case WeekDay(Me.txtMyDate)

Case vbWednesday
i = DCount("DateField", "MyTable", "DateField = #" & Me.txtMyDate &
"#")
If i >= 9 Then
MsgBox "Too many, pick another date"
Cancel = True
End If

Case vbThursday
i = DCount("DateField", "MyTable", "DateField = #" & Me.txtMyDate &
"#")
If i >= 5 Then
MsgBox "Too many, pick another date"
Cancel = True
End If

Case Else

End Select

End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

BigMan said:
Can anyone help me.

We will be working on Migrating PCs to Windows XP and need to have a
schedule that someone can go to and enter their name and pick a date to have
their PC migrated. We have a set number of PC that can be done on each of
those days. Ex. 9 PCs can be migrated on Wednesday and only 5 on Thursday.
They will be done on a first come first serve basis. I created a simple DB
in Outlook 2002 it only has 1 table:
UserID,First_Name,Last_Name,Date_Sched,Comments.
When they enter their date no one else can use their slot and when it
reaches 9 then that day can hold no more so they would pick another day
until the shedules are filled. I know this is a bit
much but don't know how get the database to stop at the 9th record on
Wednesday and allow only 5 on Thursday etc.. I was thinking I could
Click to expand...
write
a
script on the web page that will scan the database but don't know how to get
the script to read into the Database. When I tried it shows the
Click to expand...
variable
as
an [object]. I don't have much experience with Access just enough to get
into trouble :-) I appreciate any feed back and all help. Thanks in
advanced.
Click to expand...
Click to expand...
 
If your database is running locally (on an intranet, not the Internet), you
can use Data Access Pages and put the business logic in Access forms. If it
is not running on an intranet, you'll need to use either ASP pages or
ColdFusion to access and update the database. The data will not be bound to
the underlying tables. And you'll need to use VBScript or JavaScript to run
your buisness logic.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

BigMan said:
Sorry about that, I meant I created a simple database in Access2002. The
thing is that I would like people to access the Webpage that I created in
Access. It allows me to put the DB file in a shared folder and let everyone
add their name via a web page. (Excel is too messy and only 1 person can
update it at a time and can erase peoples name etc.) Can I somehow use this
in the web page that Access creates? Again thank you for your help.
Arvin Meyer said:
Access is a file server database, so all the business logic must take place
before the data gets to the tables. If you are using Outlook as an
interface, you'll need to write your rules in the Outlook form. My own
experience is that Outlook is extremely limited in what it can do, but I
suggest you post your question on one of the Outlook newsgroups for a better
answer.

If you can use an Access form, you can write a VBA procedure in the
BeforeUpdate event. Try something like (aircode)

Sub txtMyDate_BeforeUpdate(Cancel As Integer)
Dim i As Integer

Select Case WeekDay(Me.txtMyDate)

Case vbWednesday
i = DCount("DateField", "MyTable", "DateField = #" &
Click to expand...
Me.txtMyDate
&
"#")
If i >= 9 Then
MsgBox "Too many, pick another date"
Cancel = True
End If

Case vbThursday
i = DCount("DateField", "MyTable", "DateField = #" &
Click to expand...
Me.txtMyDate
&
"#")
If i >= 5 Then
MsgBox "Too many, pick another date"
Cancel = True
End If

Case Else

End Select

End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

to
have
Click to expand...
each
of
those days. Ex. 9 PCs can be migrated on Wednesday and only 5 on Thursday.
They will be done on a first come first serve basis. I created a
Click to expand...
simple
DB
in Outlook 2002 it only has 1 table:
UserID,First_Name,Last_Name,Date_Sched,Comments.
When they enter their date no one else can use their slot and when it
reaches 9 then that day can hold no more so they would pick another day
until the shedules are filled. I know this is a bit
much but don't know how get the database to stop at the 9th record on
Wednesday and allow only 5 on Thursday etc.. I was thinking I could
Click to expand...
write
a
script on the web page that will scan the database but don't know how
Click to expand...
to
get
the script to read into the Database. When I tried it shows the
Click to expand...
variable
as
an [object]. I don't have much experience with Access just enough to get
into trouble :-) I appreciate any feed back and all help. Thanks in
advanced.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top