Calendar Events Spanning Table Cells
I've decided after several failed attempts this is too difficult to do
on my own. I know it's been done before and a tutorial or code must
by lying around somewhere.
I have a Weekly Calendar
It's in a table with 7 columns and 22 rows
Across the top I have Monday thru Sunday
Down the side I have half-hour time increments - 8:00am - 10:00pm
I would like to display my events on the table, corresponding to their
day and time. If it spans several hours I would like the event to
span several rows.
Basically look like an Outlook Calendar.
I've tried this myself with five dozen if/then statments and embedded
loops but it's a huge mess.
I'd like to find out how to simply do this in asp (not ready for .net yet), any
ideas?
View Replies
ADVERTISEMENT
I know I have seen some free ASP calendars before, and even did a search of
this NG, but couldn't find any references to any. I went to 4guysfromrolla
and asp101, but they only .NET calendars as far as I could see.
I'm specifically looking for something that's free and has a page for
editing or adding events.
View Replies
View Related
I have added a calendar into my site, I have a new table in my access database called: Cal
I want to ADD AN EVENT
The records I have in that table are:
eventID
eventTitle
eventDesc
eventDate
so I designed my ADD NEW EVENT form
my problem is:
what do I put in the form for eventDate (3 select form fields? Day/Month/Year?) it doesn't work??!
View Replies
View Related
does anyone know how to create an events calendar with a database?? or has a tutorial for this??
View Replies
View Related
Depending on a value in a recordset, is it possible to write the table cell background colour. for example:
If "win" is the value, bkgrd will be "green"
If "draw" is the value bkgrd will be "yellow"
If "lose" is the value bkgrd will be "red"
View Replies
View Related
I have created a table that I want to fill with calculated values. I have given ID's to each cell. This must NOT be the way since I can't address these ID's. How do I store values in table cells from my PostBack?
View Replies
View Related
I have an interesting problem and am looking for some advice. I am
hoping to build an asp whereby records are pulled from SQL Server. These
records will be merely file locations for thumbnail images I hope to display
in a grid.
Rather than having a grid be constructed row-to-row, I was
wondering if it is at all possible to dynamically construct this grid as a
table of thumbnails whereby each cell (perhaps 5-6 columns across)
represents one record? I have no idea how one would construct this loop that
spans columns AND rows rather than just rows.
View Replies
View Related
I can trigger these events successfully if table only has one row:
Sub InputField_OnChange()
......
End Sub
But, these events cannot be fired if table has more than one row, why?
View Replies
View Related
I have the tables set up in Access, viewing in column format on ASP pages but now the company wants the schedule reports to be in a wall-calendar type format. I've searched and found calendar scripts but I need one that's creates a table resizable to a report size format. Using the existing MS Access db I've written is also a plus.
Any suggestions on where to start?
View Replies
View Related
I am not sure where to post my question on Crystal Reports, hope I am in the right place...
I am printing a report with many columns such that they won't fit into 1 page landscape.. I was just wondering if there is a way in crystal report to print the other columns (not fit into 1st page) into the next page?
View Replies
View Related
I would like to dulicate a selected record. Sounds easy enough like performing another INSERT operation. However, that solution only works if the datasource is only one table.
I have 4 different tables all linked to the main table through a unique primary key (auto number). When a user clicks a button to clone a record, all related records from the other tables must also be duplicated using the newly assigned ID that matches the one from the main table.
Hopefully I didn't confuse you. Consider it like a multi-step process of filling out different web-based forms but using the same unique id.
I don't know the first place to start on creating duplicate entries based on existing records. If you can start me with the code, I could probably follow the logic. THe difficult part for me to conceptualize is how to carry this new ID to all the other tables.
View Replies
View Related
I need to sum the values in different cells of an excel sheet which im getting from data base and which is in a loop and the number of entries depends on the user.
i m adding the code please check it out:...
View Replies
View Related
I've seen lots of posts on this and other boards, but nothing seems to work for me. I need to import data from an Excel spreadsheet using ASP. None of the ranges in the spreadsheet are named. I'm using this code:Code:
<%
Set ExcelConn = Server.CreateObject("ADODB.Connection")
Set ExcelRS = Server.CreateObject("ADODB.Recordset")
ExcelConn.Provider = "Microsoft.Jet.OLEDB.4.0"
ExcelConn.Properties("Extended Properties").Value = "Excel 8.0"
ExcelConn.Open "c:inetpubwwwrootaspcalendar est.xls"
set ExcelRS = ExcelConn.Execute ("SELECT * FROM [Sheet1$]")
Response.Write(ExcelRS($A$1))
%>
I've tried every variation on "ExcelRS($A$1)" that I can think of - I've seen "ExcelRS(1,1)" used, but that doesn't work... What is the syntax for accessing Excel data by cell coordinates?
View Replies
View Related
I get data out of a database and the user can save this data on his disk in Excel format.
Some cells has a large lenght of numbers (eg. 20060512000000). If I open the excel file, the cell where that number is in shows the following : 2.00605E+13.
I have to go into Format Cell and convert this to 'Number' and no decimal places. Is there a way in ASP to define the cells ?
View Replies
View Related
if i have an standard excel file and i have data in there in specific cells. Is it possible to have some upload facility that will be able to paste it to specific asp form textboxes?
e.g if the data in the excel file was in cell c4, i would want to paste it into textbox4. Is that possible.
OR
Is it possible to upload an excel file and to put specifc data from different cells directly into an access database.
e.g excel file -c4 i would want to paste it to rs("test4")
View Replies
View Related
I have an ASP page that loops through a SQL Server 2000 table, then
downloads an Excel sheet the users can save, etc. Works fine, except, I see
that in one particular "comments" field the Excel sheet returns a #VALUE!
error in the cell when there is a large amount of text. I've looked through
the MSKB, MSDN and many ng posts to see if there is a workaround or solution
to this, inclduing looking at the xlWorksheet properties (I've tried
'xlWorksheet.Cells(iRow, 11).WrapText = True), played with Orientation, etc.
But to no avail.
View Replies
View Related
I'm exportin a datagrid to excel, but Excel file is without format colors cells border...
Do you know how format it? Code:
View Replies
View Related
I need to come up with an if statement that will basically take a large list of records and place each one into its own table cell, and when the cells reach a max of 5 in a row, start a new row and repeat. How can I go about this?
View Replies
View Related
I am developing an application which uses data represented using color codes, in an MS-Excel worksheet. The application has to assign values based on the backgroundcolor of a cell. Like, Black = 0, Red=1, Green=2.
How to determine the background of the cell in ASP?
View Replies
View Related
is there a way of calling an already existing excel document and populating certain cells
View Replies
View Related
One of my programmers is using Office Web Components in classic ASP to create, fill and format an Excel spreadsheet. Everything is fine except when he creates Merged cells the performance drops dramatically. He has investigated the 'Center Across Cells' alternative but cannot get it working
using Office Web Comonents.
Has anyone come across this problem or even better has a solution?
View Replies
View Related
Is there a command within ASP similar to the Do Events command in VB6. The
problem I have is that an asp page that I have written outputs many lines
after extracting data from WMI. In total there are about 1000 lines
generated which are displayed within the browser and saved to a database.
The browser displays the correct results and they are saved into the
database. But the browser only displays the results after it has completed
the entire script. Is it possible to get it to output lines before
continuing with the rest of the script so I can display a section at a time.
View Replies
View Related
I have ASP which uses a stored Query in a Access 2000 database mdb to update a table. I am only adding records. No changing information in the records of the database. Just adding records. I also have a form that looks like this form:
http://support.microsoft.com/?scid=kb;en-us;198466
So I have my Query and I have my form. All the necessary information for the form comes from the ASP page. What I need to do is provide the information from ASP to the form so that it's code can populate the table. Any suggestions how this might be accomplished with the above example? Events? Or a discussion somewhere on the Net to bind a form to data submitted from an ASP?
View Replies
View Related
I'm listing events held on an Access database displaying the forthcoming events using a For Next loop (is there any easier way?).
Some of the events are considered important and to be listed if they have a value of "y" against them in a field called "important".
How would I list say the forthcoming 4 events plus ALL of those where important = "y"?
View Replies
View Related
I build a ATL object that is used in an ASP page.
Can I insert events inside this ATL object?
ATL is builded in C++
View Replies
View Related
I have a list box that has a list of names, and i want when the user selects the name to bring some information from the database and put it below the drop down box. I think i need to use an onchase event but how do i get the page to refresh to show the new data, suggestions or examples woudl be great.
View Replies
View Related
I am downloading a stream which contains XML in my ASP page. I want to have MSXML XMLDocument load this in async mode, and call events as it would in VB. I am new to ASP, is there a way of hooking into the events using ASP? Code:
View Replies
View Related
beeing from swedeni´ve the text in swedish. But I hope u understand.
I´ve a calendar
http://www45.brinkster.com/ovaasp/cal.asp
Now I want to list events, so each event gets to the correct date (i.e in the correct
table-cel)
I´ve managed to list in the wat I want
http://www45.brinkster.com/ovaasp/list.asp
But when I trying to put the events in the calendar, I can´t get the repeating events
correct . U can see for yourselfs http://www45.brinkster.com/ovaasp/error_jun.asp
if you check next month + button "forward"
Eken Cup, i Solna should be writen to 3 - 7th jun
View Replies
View Related
The project i am working on just now requires me to provide users with a link to download articles stored on the sites FTP server.This is not a problem to do, however, i also need to keep a record of who downloads what and when. I therefore have a downloads tablein my DB for storingthis info. The problem is, when the user clicks on the download link i need the document to be downloaded, AND a query to be executed to record the info into the DB table. I effectivley need the link to action these 2 eventssimultaneously!! Not sure if this is possible.
View Replies
View Related
How to disable DHTML events in HTML/JavaScript. I am using one DIV tag. THis is displaying one menu. I wanted to diable the menu for some time.
View Replies
View Related
I recently had to build an FTP server for all of our clients to send us files. I am now asked to do something I have never done, I need to be able to alert via email any other useable method everytime new files are ftp'd into client folders on the ftp server. Can this be done?
View Replies
View Related
This page is going to be a menu system and is dynamic so that the user can add items to their own menu.
I have it working but would like it not to show sub menu until the main item has been clicked by the user?? Code:
View Replies
View Related
Trying to implement a list of online users in my application. I have SQL Server database, table Users with a column called Status, that is set to 1 if the user is online or to 0 if the user is offline.
I wrote a VBScript sub for database update, but the problem is when I try to execute it on page onLoad event or onUnload event, the onUnload event overwrites the onLoad one right away. I suspect it has something to do with server-side vs. client-side scripting.
This is the BODY tag: Code:
View Replies
View Related