Search results for query: *

Same error message even with that. Cheers anyway though.

thanks Boris I tried that with forward or backslashes and that didn't work either. I appreciate what you are saying. I can only think the best way would be to first to upload data from excel into an asp or php page etc and then update sql database dynamically from there.

Hello I would like to make a connection to an excel database on an external server from sql server via a stored procedure and import the data from it. I have tried importing data from the excel database sitting on the local harddrive of the sql server and that works, however I will need to...

I have sorted it. It wasnt working because I put http:// in my domain name http:// Thanks anyway chopstik.

When you say how to GET THE TABLE? do you mean print it in HTML?

Yes, I can view the cookie from the original page, and if i traverse pages from the initial setting of the cookie. But the cookie is not there, when opening a new window. I have even tried setting the cookie with Now + 5 and the cookie is still not there when opening a new window.

Surely you can just use the window.open attributes to set the attributes of the window. window.open('somepage.htm','','titlebar') By specifying one attribute all the other attributes like scrollbars, resizable will automatically be locked. And since titlebar always shows, you can just use that.

<!-- You can do this with CSS. COPY AND PASTE THIS CODE INTO YOUR BODY. Just change the height and width accordingly --> <style type="text/css"><!-- #someLayer{ overflow:auto; height:100px; width:30px; } --> </style> <div id="someLayer"> some content with a scroll bar</div>

Whats the code in your function?

PAGE 1 Response.Cookies("loggedin")="true" Response.Cookies("loggedin").Expires = Date + 1 Response.Cookies("loggedin").Domain = strMyDomain PAGE 2 Response.Write wrapLine("START COOKIES LOOP") for each itemName in Request.Cookies Response.Write wrapLine(itemName & "=" &...

Try CONVERT(smalldatetime, '24/12/2004', 103) This will switch the date around from UK to US style.

Your problem could be ASP or Javascript related. Consider breaking it down and testing one or the other first.

Hello Chopstick, and thanks for your response. I understnd that about the session, so I have created a cookie instead. Hence, im wondering why its not even recognising the cookie?

Sorry - that should be FormatNumber(str,2) NOT ZERO

strEventCategory = parseInt("" & rs("Event_Category")) function parseInt(str) if isNumeric(str) then parseInt = FormatNumber(str,0) else parseInt = 0 end if end function

Hello 1) PAGE 1 - I have created either Session("loggedin")="true" OR Response.Cookies("loggedin")="true" 2) PAGE 2 - LOOPS and writes ALL Sessions and cookies (This works fine) START SESSION LOOP loggedin=true END SESSION LOOP START COOKIES LOOP loggedin=true END COOKIES LOOP 3) I...

BLORF you are a GENIUS. Thankyou so much. HA HAHAHA. Yes, i dont believe it. You have solved the problem of the decade. The reason probably most people dont use access to generate reports, because of its clunkyness, and limited file format support. But Acrobat Distiller is king. I have never...

Hello I am struggling to export my report with images to word. I have exported to snapshot viewer which is fine, but isnt going to work multi platforms like UNIX or Mac. So I want to export into word. When I export as RTF it keeps the layout in tact, which is fine. But its not including the...

Currently it seems that access reports only have 5 options of exporting, and only saves the whole repot including the background image embedded - snapshot. But I cant seem to get snapshot to work in any other program except snapshot viewer. This could be a problem if i want to send my report to...

Thanks Trendsetter I dont know exactly how to do this Report_Format I can create a text box in the REPORT FOOTER which is the sum of all the jobs in DETAILS. Then hide this from being printed. With the label ReportSum I can then create a text box in the PAGE FOOTER, but I dont know how to...