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!

Register Log in
  • Congratulations TouchToneTommy 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: Zac5
  • Content: Threads
  • Order by date
  1. Zac5

    Query Studio - Filter for records older than a month based on current date whenever report is run

    Can I incorporate a current date function in query studio, are there functions I can use in query studio or do I need either report or analysis studio to achieve this? Thanks
  2. Zac5

    Can send mail but unable to receive mail

    I have set up an email account in Outlook 2007. I can send email but am not receiving email. If I test the account settings/connection it comes back as successful. I am completely lost! If I use a web client provided by the ISP to check emails they're there. Any ideas please? Thanks
  3. Zac5

    installed php on windows but php code not interpreted?

    Hi, I have just installed PHP version 5 on my Windows XP machine. It was installed to C:\php. I added the simple page below in C:\Inetpub\wwwroot <HTML><HEAD><TITLE>Today's Date</TITLE></HEAD><BODY><P>Today's Date (according to this Web server) is<?php echo( date("l, F dS Y.") )...
    • Zac5
    • Thread
    • Replies: 18
    • Forum: PHP
  4. Zac5

    Problem executing a macro in another open Workbook

    I want to execute a macro called "Main" held in second workbook from macro in current workbook current workbook snippet is as follows: Dim second_wb As Workbook Set second_wb = ActiveWorkbook Application.Run (second_wb!Main) Above line fails, I think I have the syntax wrong, any ideas...
  5. Zac5

    Why is this small piece of code failing?

    Dear All, The following fails at line "Master_wb.Activate": Dim Master_wb As Workbook Workbooks.Open Filename:=ws.Cells(rrng, 1) Set Master_wb = ActiveWorkbook Workbooks.Open Filename:=ws.Cells(rrng, 2) Master_wb.Activate Sheets("Expenses").Select What am I doing wrong please?
  6. Zac5

    Open a CSV file from string given in cell of active workbook

    Dear All, 1. My cell refernce (1,1) contains a string e.g. myfilename (without the extension e.g. myfilename.csv) I want my macro in the active workbook to open myfilename. Workbooks.Open Filename:=Range(1, 1) does not work because its a csv. How can I open it, I don't want to have to convert...
  7. Zac5

    Could not load file or assembly and Failed to grant minimum permission

    Hi, I have the same asp.net web application installed on three seperate windows 2003 servers. In one instance the application works perfectly however on the other 2 instances the application works intermittently, but when it fails I need to restart IIS for it to work again. There doesn't seem...
  8. Zac5

    Could not load file or assembly and Failed to grant minimum permission

    Hi, I have the same asp.net web application installed on three seperate windows 2003 servers. In one instance the application works perfectly however on the other 2 instances the application works intermittently, but when it fails I need to restart IIS for it to work again. There doesn't seem...
  9. Zac5

    Versions of ASP

    Hi, I am new to ASP.NET and have become very confused with versioning between IIS, .NET Framework on a client, .NET Version on the server and version of ASP code. I have the following questions: *How are these things related and what are the impacts of differences in versions? *What are the...
  10. Zac5

    Certain websites not loading

    Hi, Just recently certain websites have stopped loading on my laptop, I have plugged another laptop into my router and everything loads just fine on it. Two websites that do not load on my laptop are http://www.xe.com/ and http://www.chase.com/. I have tried different browsers and experience...
  11. Zac5

    Datatype format conversion error?

    The following works in my query analyzer without any problems: select convert(datetime,'28-5-2006') however gives an error on query analyzer installed on another machine. I have checked regional settings for both PCs and they are the same English(United Kingdom). Any suggestions please?
  12. Zac5

    Update query question

    Hi, How can I write this correctly in order to achieve this: update dbo.table1 set B.table1field1=A.table1field1 from dbo.table1 as A,dbo.table1 as B where A.table1field2=10 and B.table1field2=10 and A.table1field3=1 and B.table1field3=2 currently I get the following error: Server: Msg 1032...
  13. Zac5

    select ids that begin with 5

    Hi, I have a table with a range of id codes and I want to extract those that begin with 5. If this were a text field type I could do a select * from x where id like '5*' but since it's an integer is there a simple statement? I cannot use e.g. > 499 as there could be id codes in the tens...
  14. Zac5

    Disable form Button object if Checkbox not checked

    I have added a form Button object to a worksheet and want it disabled or dimmed until a form Checkbox object also within the worksheet is checked. Please can someone assist with the vba for this. I am guessing the vba to disable the button object would be something like -...
  15. Zac5

    Disable/dim form button object

    I would like to disable a simple form object button I have in my worksheet, I would expect it to be something along the lines of Worksheets("sheet 1").???.Enabled = False Can someone put me in the right direction please thanks, Zac
  16. Zac5

    Table height adjust to content then browser

    Hi, I have a html table with the last row containing my footer text. If I dont specify a height the footer appears halfway up the page with whitespace underneath. If I specify height="100%" it goes too far down such that I have to scroll to see the footer. Any suggestions please?
  17. Zac5

    Linux gateway frequently freezing for minute or so

    Hi all, I am a linux beginner and I am having a strange problem. I am using a linux server as a gateway and it frequently freezes for a minute or so hence the other machines connected to the network also lose connection to the outside world. I am noticing the following in log file: kernel...
  18. Zac5

    Getting mouseevents to work the way I want

    Hi all, I am dynamically generating a variable number of tables containing statistics. As the page loads the tables are hidden using the getElementById('xx').style.display='none' feature. Each table is within a pair of <div> tags with a unique ID. On another part of a page I have dynamically...
  19. Zac5

    Not appending but instead replacing

    Hi, simple experiment where array stores a name of a colour in each element. I want to print colours to error log as blackbluewhiteredyellow on the same line, but this doesnt work correctly, i only see the last colour in the array, it does seem to be writing the other items too but instead of...
    • Zac5
    • Thread
    • Replies: 7
    • Forum: Perl
  20. Zac5

    How to do ORDER BY and LIMIT to part of a select statement?

    I want to perform 'order by' and 'limit' to part of my select statement, that is, only the part that meets the first condition, so i want to achieve following: select * from page where (type=6 order by edate limit 1) or (date > (UNIX_TIMESTAMP-8400)); However this is not accepted - any...
    • Zac5
    • Thread
    • Replies: 5
    • Forum: MySQL

Part and Inventory Search

Back
Top