Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: locutis
  • Content: Threads
  • Order by date
  1. locutis

    Revision - Send CDO.Message to Blackberry

    Right now I'm creating the e-mail server object then sending it to the outgoing SMTP server. I just need to be able to send this to the Blackberry as well. Thanks and sorry for the previous mis-post. Thanks, Jean-Luc
  2. locutis

    Display ASP pages in Blackberry

    Hello, I have a trouble-ticketing system I wanted to have the web pages and e-mail output to the Blackberry. Can someone please explain how to do this? Thanks in advance, Jean Luc
  3. locutis

    ASP.NET Mobile Web App vs. Mobile Internet Toolkit

    Hello, I have been taked with taking a Classic ASP application and outputting the web pages to a Blackberry device. After some research it seems that my best bet is to convert the Classic ASP application to an ASP.NET Mobile Web Application and go from there. However, I've also seen a lot of...
  4. locutis

    ASP.NET form won't submit

    Hello, I'm using ASP 1.1.4322 framework. I have an e-mail send form in ASP.NET/C# code behind. It was working, then I added some form fields, made sure to build again, now I can't get the form to submit. I tried setting breakpoints, Console.WriteLine statements throughout, it seems that the...
  5. locutis

    MS Query Data Source Not Found Problem

    I have this MS Query I've been using for some time with many users, no problem. In my data sheet I added another new database query via the MS Query tool (not the wizard) like i'd done before, but now other machines get and [ODBC Driver Manager] [Data Source Name Not Found And No Default Driver...
  6. locutis

    MDX query newbie question please

    Hello, I am just getting into writing these queries and am trying to test with a simple MDX query against a Sales cube that I've been working with through the SQL Server 2000 Analysis Services tutorial: SELECT Measures.MEMBERS ON COLUMNS, {[Store].[Store State].[CA], [Store].[Store...
  7. locutis

    XL 2000: MS Query reference to multiple cells

    Hello and Happy New Year! Here's what I have: 3 display sheets, 1 data sheet with MS Queries pointing to SQL Server 2000 db. First query on data sheet takes the input parameter value from cell on Sheet1(=Sheet1!$B$2) which other queries key off of, works fine. I only need this same data sheet...
  8. locutis

    MS Query not returning results

    Hello, It seems that there is some latency with MS Query? I add a value into our SQL Server database, but my sheet that uses MS Query doesn't return the value right away, but I know it's in the database because I see it in the table. Then after awhile, I can query and display the new data in...
  9. locutis

    XL 2000: Data Source Name not found

    Hello, I've installed an Excel 2000 workbook on several machines (some 2000 some XP)with the following set-up and config: MSQuery (using XLQuery.xla) System DSN/ODBC to SQL Server 2000 MDAC 2.5 and later (up to 2.8) Data sheet where I reference my queries/data Display sheet where I display the...
  10. locutis

    SQL Server 2000 SP3a Analysis Services Installation Problem

    Hello, The SP3a install went fine, but when trying to install the Analysis Services I get the following error winow: Severe: An error occurred during the move data process: -145. I have been researching similar errors to the one I'm getting (I see '-132' is common) which is due to services...
  11. locutis

    XL 2000: System DSN/ODBC problem

    Hello, I have several users who are running Office 2000 SR-1 on Windows 2000 and I have no problem setting up their System DSN/ODBC with an Excel sheet that uses external data from MSQuery. Now I have a user that has Office 2000 sp3 running on Windows XP and the System DSN/ODBC doens't "stick"...
  12. locutis

    XL2000: Prevent clearing cell with spacebar

    OK, here's one for you guys. How can you prevent a user from clearing a cell value with the spacebar? Is there a way to trap the event and throw an alert or simply disable the spacebar for that cell? Thanks in advance, Jean Luc
  13. locutis

    XL2000: Macro doesn't show on another computer

    Hello, I have a workbook that uses a macro, which opens on my machine fine. but when I open the workbook from another machine, the macro doesn't even appear. Then, when I try to add the macro it won't run. Can someone tell me what's up? Thanks in advance, Jean Luc
  14. locutis

    XL2000: Edit cell with existing sheet reference

    OK, here's another one for your Excel experts. Can someone tell me how to set-up a cell so that the user can override the original cell reference (='Sheet1'!B2) with a manual input number, yet still leave the original cell reference intact when they leave the cell. I don't want to protect the...
  15. locutis

    XL2000: Refresh Data for Active Sheet Only

    Hello, I now I can do a macro to refresh the workbook: ActiveWorkbook.RefreshAll But it is very slow. Is there a way to refresh only the active sheet? Or can someone offer another solution to speed this up? I tried several things and researched but was unable to find a solution. Thought maybe...
  16. locutis

    Distributing Excel 2000 (with MS Query) template

    Hello, I have an Excel 2000 template that uses MS Query to pull data from several SQL Server 2000 views into a lookup sheet. The cells on this sheet are references on the display sheet. There will be several users accessing this template. My questions are: Is there any way to avoid having to...
  17. locutis

    IIS/PHP Config Nightmare

    Hello, I'm trying to get a simply phpinfo.php to run on my local IIS 5.0, using php5.2.0. I've configured the php.ini, set all the PATH and PHPRC environmental variables and so forth according to the help files. When I try to run the phpinfo.php from my wwwroot directory...
  18. locutis

    XL2000: Show/Hide Columns Problem

    Hello, I have the following sub which works fine with consecutive columns: Sub ShowColumns() Dim r As Range, rng As Range With Sheets(1) For Each r In .Range(.[A1], .[A1].End(xlDown)) With Sheets(2) For Each rng In .Range(.[A1], .[A9].End(xlToRight)) If rng.Value = r.Value...
  19. locutis

    XL2000: Check Macro for Missing Cell Value

    Hello Excel gurus, I have a lookup sheet with a particular value that is populated from a database via MS Query. This value is used by a display sheet. Works fine, but if the value is empty, I would like to be able to alert the user with a msgbox, then return false. I've been looking at a few...
  20. locutis

    XL2000: Check Macro for missing cell value

    Hello Excel gurus, I have a lookup sheet with a particular value that is populated from a database via MS Query. This value is used by a display sheet. Works fine, but if the value is empty, I would like to be able to alert the user with a msgbox, then return false. I've been looking at a few...

Part and Inventory Search

Back
Top