From: Matt Matt on 14 May 2010 03:58 I'm trying to create a website for our intranet which can be used to send data to an excel spreadsheet. It's for our goods-in dept. We can only receive 25 pallets per day, so i want the website to ask questions like when/how many pallets/ and where is the delivery coming from, but then link into the excel spreadsheet which will allow or not the receipts. If for example we already have 25 pallets booked in on Wednesday 6th June 2010, and someone tries (via the website) to book in another pallet, i want it to come back and say something like "day full, please choose another day" or something like that! Is this possible? If so could you please direct me on how to do it? Many thanks
From: Stefan B Rusynko on 14 May 2010 04:35 While you can use Excel as a datasource See http://support.microsoft.com/default.aspx?scid=268948 - it is not recommended, since Excel is a single user product Recommend you use Access for the Database Yes you can do what you are asking for But none of the wizards will do what you are asking You will need to write custom server side code to query the database after the form submission - or better still in the form to block days that are 'full" -- _____________________________________________ SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ] "Warning - Using the F1 Key will not break anything!" (-; _____________________________________________ "Matt" <Matt @discussions.microsoft.com> wrote in message news:347F53C7-B981-4CED-AC33-3D2227B21AD8(a)microsoft.com... I'm trying to create a website for our intranet which can be used to send data to an excel spreadsheet. It's for our goods-in dept. We can only receive 25 pallets per day, so i want the website to ask questions like when/how many pallets/ and where is the delivery coming from, but then link into the excel spreadsheet which will allow or not the receipts. If for example we already have 25 pallets booked in on Wednesday 6th June 2010, and someone tries (via the website) to book in another pallet, i want it to come back and say something like "day full, please choose another day" or something like that! Is this possible? If so could you please direct me on how to do it? Many thanks
|
Pages: 1 Prev: Not sure what I need... Next: how do i retrieve deleted documents on ms frontpage |