I am trying to create a unique type of registration form for my job
upcoming Holiday Christmas
Party. There will be 60 tables for seatings with 10 people max at
table.
How can I write some codes to support this? I need to be able to see
the number of
people who are seating and any available seats at a given table. How
can I set my database
and pull the information to give what I want.
Oct 31 '06
17  1477 
I'm sure Access will suffice. And intranet-based registration sounds good.
What are you stuck on? Have you made ASP apps before?
Ray at work
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******** *************@e 64g2000cwd.goog legroups.com...
Ok, I am trying to develop a web registration form for my Command
Military Christmas Party.
There will be 60 seating tables each table handling a max seating of
10 personnel at the party. The form needs to be able interact with a
database that will permit the following capabilities: To register for
seating, To see current names of people who have already registered(
this will let them know where their buddies are siting), annd allot a
certain number of seats for registering per table(10). Is this
possible to write codes to do this?
Should I just do this in ACCESS and have everybody to register via our
intranet? What is the easy and quickest way to do this? I got 2wks to
knock this out. Please help..
Ray Costanzo [MVP] wrote:
>Can you be a little more specific? Need help with what?
Ray at work
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******* *************** @f16g2000cwb.go oglegroups.com. ..
>I tried the table setup in ACCESS and I couldn't get it to work. Need
Help......:>
Ray Costanzo [MVP] wrote:
No, it won't work in Access, but you can manually create the tables in
the
same way. You'll have to write your queries a little different, I
believe.
It seems Jet likes to use no fewer than 18,000 parentheses in any
query
that
uses more than one table. ;]
If you struggle with writing the queries in Jet format, post back.
Ray at work
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******* *************** @m73g2000cwd.go oglegroups.com. ..
I will be using microsoft access as my database. Will these code
work
with access.
Bob Barrows [MVP] wrote:
IC1(SW/AW) wrote:
I am trying to create a unique type of registration form for my
job
upcoming Holiday Christmas
Party. There will be 60 tables for seatings with 10 people max
at
table.
How can I write some codes to support this? I need to be able to
see
the number of
people who are seating and any available seats at a given table.
How
can I set my database
and pull the information to give what I want.
If Ray's DDL generates errors when you try it, you should tell us
what
database you are using. He provided Transact-SQL code for SQL
Server.
it
won't work for other types of databases.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will
get a
quicker response by posting to the newsgroup.
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******** **************@ f16g2000cwb.goo glegroups.com.. .
>I tried the table setup in ACCESS and I couldn't get it to work. Need
Help......:>
Make 2 tables
the first should represent a party table, make sure you give it a primary
key ID field.
The second table should represent your guests, it should field for the table
number they are sitting at. In your relation ship page make a link from the
primary key of the first table to the table number field of the second table
>
Ray Costanzo [MVP] wrote:
>No, it won't work in Access, but you can manually create the tables in
the
same way. You'll have to write your queries a little different, I
believe.
It seems Jet likes to use no fewer than 18,000 parentheses in any query
that
uses more than one table. ;]
If you struggle with writing the queries in Jet format, post back.
Ray at work
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******* *************** @m73g2000cwd.go oglegroups.com. ..
>
I will be using microsoft access as my database. Will these code work
with access.
Bob Barrows [MVP] wrote:
IC1(SW/AW) wrote:
I am trying to create a unique type of registration form for my job
upcoming Holiday Christmas
Party. There will be 60 tables for seatings with 10 people max at
table.
How can I write some codes to support this? I need to be able to see
the number of
people who are seating and any available seats at a given table. How
can I set my database
and pull the information to give what I want.
If Ray's DDL generates errors when you try it, you should tell us what
database you are using. He provided Transact-SQL code for SQL Server.
it
won't work for other types of databases.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
I think I will go with the ACCESS method, as far as ASP page, I am a
newbie with it.
Ray Costanzo [MVP] wrote:
I'm sure Access will suffice. And intranet-based registration sounds good.
What are you stuck on? Have you made ASP apps before?
Ray at work
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******** *************@e 64g2000cwd.goog legroups.com...
Ok, I am trying to develop a web registration form for my Command
Military Christmas Party.
There will be 60 seating tables each table handling a max seating of
10 personnel at the party. The form needs to be able interact with a
database that will permit the following capabilities: To register for
seating, To see current names of people who have already registered(
this will let them know where their buddies are siting), annd allot a
certain number of seats for registering per table(10). Is this
possible to write codes to do this?
Should I just do this in ACCESS and have everybody to register via our
intranet? What is the easy and quickest way to do this? I got 2wks to
knock this out. Please help..
Ray Costanzo [MVP] wrote:
Can you be a little more specific? Need help with what?
Ray at work
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******** **************@ f16g2000cwb.goo glegroups.com.. .
I tried the table setup in ACCESS and I couldn't get it to work. Need
Help......:>
Ray Costanzo [MVP] wrote:
No, it won't work in Access, but you can manually create the tables in
the
same way. You'll have to write your queries a little different, I
believe.
It seems Jet likes to use no fewer than 18,000 parentheses in any
query
that
uses more than one table. ;]
If you struggle with writing the queries in Jet format, post back.
Ray at work
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******** **************@ m73g2000cwd.goo glegroups.com.. .
I will be using microsoft access as my database. Will these code
work
with access.
Bob Barrows [MVP] wrote:
IC1(SW/AW) wrote:
I am trying to create a unique type of registration form for my
job
upcoming Holiday Christmas
Party. There will be 60 tables for seatings with 10 people max
at
table.
How can I write some codes to support this? I need to be able to
see
the number of
people who are seating and any available seats at a given table.
How
can I set my database
and pull the information to give what I want.
If Ray's DDL generates errors when you try it, you should tell us
what
database you are using. He provided Transact-SQL code for SQL
Server.
it
won't work for other types of databases.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will
get a
quicker response by posting to the newsgroup.
Are you saying that I should make 2 tables with a one-to-one relation(
partytable id to guesttable id)? Will this work? How will I set it up
to allow to see who is sitting where? and allot only 10 seats per table
limit? Sound like a lot but I appreciate you guys in here for helping
THanks
Slim wrote:
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******** **************@ f16g2000cwb.goo glegroups.com.. .
I tried the table setup in ACCESS and I couldn't get it to work. Need
Help......:>
Make 2 tables
the first should represent a party table, make sure you give it a primary
key ID field.
The second table should represent your guests, it should field for the table
number they are sitting at. In your relation ship page make a link from the
primary key of the first table to the table number field of the second table
Ray Costanzo [MVP] wrote:
No, it won't work in Access, but you can manually create the tables in
the
same way. You'll have to write your queries a little different, I
believe.
It seems Jet likes to use no fewer than 18,000 parentheses in any query
that
uses more than one table. ;]
If you struggle with writing the queries in Jet format, post back.
Ray at work
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******** **************@ m73g2000cwd.goo glegroups.com.. .
I will be using microsoft access as my database. Will these code work
with access.
Bob Barrows [MVP] wrote:
IC1(SW/AW) wrote:
I am trying to create a unique type of registration form for my job
upcoming Holiday Christmas
Party. There will be 60 tables for seatings with 10 people max at
table.
How can I write some codes to support this? I need to be able to see
the number of
people who are seating and any available seats at a given table. How
can I set my database
and pull the information to give what I want.
If Ray's DDL generates errors when you try it, you should tell us what
database you are using. He provided Transact-SQL code for SQL Server.
it
won't work for other types of databases.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
You better get to reading then if you only have two weeks! When you get
stuck on individual blocks of code, post here, but as far as architecting
the application, that's where you come in. Do you have the basic
essentials? Do yo have a server running IIS? Do you know how to create an
HTML form? Do you know how to read data posted from an HTML form? Do you
know how to read data from a database, write to it? Validate user input?
Ray at work
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******** **************@ h48g2000cwc.goo glegroups.com.. .
>I think I will go with the ACCESS method, as far as ASP page, I am a
newbie with it.
Ray Costanzo [MVP] wrote:
>I'm sure Access will suffice. And intranet-based registration sounds
good.
What are you stuck on? Have you made ASP apps before?
Ray at work
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******* **************@ e64g2000cwd.goo glegroups.com.. .
Ok, I am trying to develop a web registration form for my Command
Military Christmas Party.
There will be 60 seating tables each table handling a max seating of
10 personnel at the party. The form needs to be able interact with a
database that will permit the following capabilities: To register for
seating, To see current names of people who have already registered(
this will let them know where their buddies are siting), annd allot a
certain number of seats for registering per table(10). Is this
possible to write codes to do this?
Should I just do this in ACCESS and have everybody to register via our
intranet? What is the easy and quickest way to do this? I got 2wks to
knock this out. Please help..
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******** **************@ h48g2000cwc.goo glegroups.com.. .
>
Are you saying that I should make 2 tables with a one-to-one relation(
partytable id to guesttable id)?
one to many
one table can have many guests
Will this work? How will I set it up
to allow to see who is sitting where? and allot only 10 seats per table
limit? Sound like a lot but I appreciate you guys in here for helping
THanks
First get your tables set up
then with asp, we can check how many guests in the guests table are sitting
at each party table before allowing any more guests on that table.
>
Slim wrote:
>"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******* *************** @f16g2000cwb.go oglegroups.com. ..
>I tried the table setup in ACCESS and I couldn't get it to work. Need
Help......:>
Make 2 tables
the first should represent a party table, make sure you give it a primary
key ID field.
The second table should represent your guests, it should field for the
table
number they are sitting at. In your relation ship page make a link from
the
primary key of the first table to the table number field of the second
table
>
Ray Costanzo [MVP] wrote:
No, it won't work in Access, but you can manually create the tables in
the
same way. You'll have to write your queries a little different, I
believe.
It seems Jet likes to use no fewer than 18,000 parentheses in any
query
that
uses more than one table. ;]
If you struggle with writing the queries in Jet format, post back.
Ray at work
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******* *************** @m73g2000cwd.go oglegroups.com. ..
I will be using microsoft access as my database. Will these code
work
with access.
Bob Barrows [MVP] wrote:
IC1(SW/AW) wrote:
I am trying to create a unique type of registration form for my
job
upcoming Holiday Christmas
Party. There will be 60 tables for seatings with 10 people max
at
table.
How can I write some codes to support this? I need to be able to
see
the number of
people who are seating and any available seats at a given table.
How
can I set my database
and pull the information to give what I want.
If Ray's DDL generates errors when you try it, you should tell us
what
database you are using. He provided Transact-SQL code for SQL
Server.
it
won't work for other types of databases.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will
get a
quicker response by posting to the newsgroup.
Yes, I can perform these things. I just dont know how to pull it from
the database to do what I want it to do. (i.e) show tables with the
names and available slot.
Ray Costanzo [MVP] wrote:
You better get to reading then if you only have two weeks! When you get
stuck on individual blocks of code, post here, but as far as architecting
the application, that's where you come in. Do you have the basic
essentials? Do yo have a server running IIS? Do you know how to create an
HTML form? Do you know how to read data posted from an HTML form? Do you
know how to read data from a database, write to it? Validate user input?
Ray at work
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******** **************@ h48g2000cwc.goo glegroups.com.. .
I think I will go with the ACCESS method, as far as ASP page, I am a
newbie with it.
Ray Costanzo [MVP] wrote:
I'm sure Access will suffice. And intranet-based registration sounds
good.
What are you stuck on? Have you made ASP apps before?
Ray at work
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******** *************@e 64g2000cwd.goog legroups.com...
Ok, I am trying to develop a web registration form for my Command
Military Christmas Party.
There will be 60 seating tables each table handling a max seating of
10 personnel at the party. The form needs to be able interact with a
database that will permit the following capabilities: To register for
seating, To see current names of people who have already registered(
this will let them know where their buddies are siting), annd allot a
certain number of seats for registering per table(10). Is this
possible to write codes to do this?
Should I just do this in ACCESS and have everybody to register via our
intranet? What is the easy and quickest way to do this? I got 2wks to
knock this out. Please help..
Which part are you stuck on though? The query? The page design? The html?
You should try to be specific and focus on individual tasks when you post
here. http://www.aspfaq.com/show.asp?id=2081
Ray at work
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******** **************@ k70g2000cwa.goo glegroups.com.. .
Yes, I can perform these things. I just dont know how to pull it from
the database to do what I want it to do. (i.e) show tables with the
names and available slot.
Ray Costanzo [MVP] wrote:
>You better get to reading then if you only have two weeks! When you get
stuck on individual blocks of code, post here, but as far as architecting
the application, that's where you come in. Do you have the basic
essentials? Do yo have a server running IIS? Do you know how to create
an
HTML form? Do you know how to read data posted from an HTML form? Do
you
know how to read data from a database, write to it? Validate user input?
Ray at work
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******* *************** @h48g2000cwc.go oglegroups.com. ..
>I think I will go with the ACCESS method, as far as ASP page, I am a
newbie with it.
Ray Costanzo [MVP] wrote:
I'm sure Access will suffice. And intranet-based registration sounds
good.
What are you stuck on? Have you made ASP apps before?
Ray at work
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******* **************@ e64g2000cwd.goo glegroups.com.. .
Ok, I am trying to develop a web registration form for my Command
Military Christmas Party.
There will be 60 seating tables each table handling a max seating of
10 personnel at the party. The form needs to be able interact with a
database that will permit the following capabilities: To register
for
seating, To see current names of people who have already registered(
this will let them know where their buddies are siting), annd allot
a
certain number of seats for registering per table(10). Is this
possible to write codes to do this?
Should I just do this in ACCESS and have everybody to register via
our
intranet? What is the easy and quickest way to do this? I got 2wks
to
knock this out. Please help..
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Sarah Tanembaum |
last post by:
I was wondering if it is possible to create a secure database system
using RDBMS(MySQL, Oracle, SQL*Server, PostgreSQL etc) and web
scripting/programming language(Perl, PHP, Ruby, Java, ASP, etc) combination?
I have the following in mind:
I wanted to store all my( and my brothers and sisters) important
document
information such as birth certificate, SSN, passport number, travel
documents, insurance(car, home, etc) document, and other...
|
by: cooldv |
last post by:
i am running a website on Windows 2000 server with ASP 3 webpages and
Access 2000 database. (with a hosting company)
traffic is slow at this time but expect to grow. lately i have been
reading about sql database and sql server, specially this article:
http://www.aspfaq.com/show.asp?id=2195
will someone help me understand:
1. with *SQL Server*, do i keep my current Access 2000 database and
ASP pages?
|
by: MHenry |
last post by:
Hi,
We were going merrily along for 6 years using this database to record
all client checks that came into our office, including information
about what the checks were for.
Suddenly, network computers cannot access the database.
The message is...
|
by: premmehrotra |
last post by:
I currently have a multi-user access database which is put on a shared
drive L: on a Windows Servers. Entire database is one file premdb.mdb.
Users access this database from their laptops. Following problems
occur:
1. Access is way too slow in WAN environment. Server is located in New
Jersey and users are in California and Puerto Rico.
2. Database often becomes corrupt
3. When one user updates some data in the database, other users...
|
by: John Baker |
last post by:
Hi:
I am URGENTLY in need of some book or web site OR tool that will help me integrate a
relatively simple access application into a web page or pages. This is a time recording
system (by project), and I would be more than wiling to pull the updated database down
from the Host using FTP on a monthly basis. Its just that I need to understand how to set
it up on the web site itself. The Host supports SQL.
Any direction you can give would...
| | |
by: Claus Haslauer |
last post by:
Hi,
firstly, I am new to access03 and server03
Originally, I had written an access 2002 database.
Then, we transferred (for another reason) to server 2003.
Then, we got access 2003.
Then I wanted to setup the system in the following way:
The database (now in access2003) sits in a shared folder on the
server2003 machine. Anybody else who has access to that server and the
folder can open the database form that folder, add data, write
|
by: philip |
last post by:
On a form, I have a datagridview.
This datagridview is constructed on a dataset filled by a tableadapter.
The table adapter do very well what it must do when filling dataset.
Insertions, modifications and deletions functions very well in the dataset.
But impossible to transmit modifications in ACCESS database. Impossible to
WRITE in database.
Here is the code for data transmission from tableadapter to Access database
:
|
by: Allison |
last post by:
Hi -- we are a small manufacturing looking for a multi-user database to
take customer orders (nothing too complicated, with 3 users total). We
think we should be using Access, but are wondering what alternatives
there are. It has been recommended to us to use ASP.net and SQL
instead, with the reasoning that:
1) Access is likely to go obsolete at some point
2) It will be more stable
Does anybody have any thoughts on this?
|
by: surfrat_ |
last post by:
Hi,
I am having the following problems in getting Microsoft Visual Studio
2005 Professional to link to an Access .mdb
database. Please help me to sort this out.
Problem 1:
The Microsoft page "How to: Connect to Data in an Access Database"
|
by: nihad.nasim |
last post by:
Hi there,
I have a database in Access that I need on the web. The web page
should connect to the database and write records for certain tables
and view records for others. I want to know a reliable way of
connecting Access to a server. I am willing to switch to any version
of Access which might solve the problem. Which server would you
recommend and what are the advanatages and disadvantatges of the
server you propose? Please also inlcude...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
