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 Chriss Miller 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: scriggs
  • Content: Threads
  • Order by date
  1. scriggs

    #error in query

    Hi I have a query which is left joined so some fields have no data. Also some fields have a zero in them. I am trying to perform a calculation like a/b and if a or b is missing then I get an #error. I have tried iif(isnull(a),0,a/b) and nz(a,0) but still get errors. Any ideas?
  2. scriggs

    Get next week number when year end

    I have a table which shows holds data stored with week no and year, i.e. Week Year 3 2007 2 2007 1 2007 52 2006 51 2006 50 2006 49 2006 .. 3 2006 2 2006 1 2006 53 2005 52 2005 51 2005 50 2005 I need to select a week and then pick...
  3. scriggs

    Normalize tabled data in Excel

    Hi I have been provided some data in Excel which I want to normalize and put into Access. The data comes in like Weeks and department across here Sales Sales Sales Sales Ops Ops Ops Name 1 2 3 4 1 2 3...
  4. scriggs

    Trap error when index field not completed on a record

    I have a form to add new entries to a table. The table has index fields linked to other tables. If a user does not fill in all the fields, or clicks into the next row, etc. then Access gives an error message: "The Microsoft Jet database engine cannot find a record in the table 'tblStockStatus'...
  5. scriggs

    Password for hyperlink/image rollover

    Hi I have a webpage with thumbnail images which are previewed when you click on them using HTML <img src="files/plan5small.jpg" alt="Plan5" width="100" onmouseover="plan.src='files/plan5.jpg';" onmouseout="plan.src='files/plan5.jpg';"> I am trying to password protect the preview function...
  6. scriggs

    Crosstab Query - Add more than 1 column heading

    I have a cross tab query which shows week dates as column headings, like: Name 30/10/06 06/11/06 -------- -------- -------- Mark 10 15 John 15 20 I need to show the week number as well as the date, how can I add that as a second column header, or similar. Name...
  7. scriggs

    Importing databases - test if database file is valid to avoid error

    I have a routine which is importing 000's of Microsoft Access databases into a large Access Database. Some of the files appear to be corrupt and when the routine tries to open them I get the error: "The database xxx needs to be repaired or isn't a database file. You or another user may have...
  8. scriggs

    disable-output-escaping does not work

    I am using phpreports which I downloaded of the net. I am running apache, php5 on windows server. The system works great except it is programmed to use disable-output-escaping but it does not seem to work. It shows up &lt &rt instead of the tags. Any ideas?? <xsl:text...
  9. scriggs

    Using phpreports which is based on XML and get &amp;lt;

    I am using PHP reports which is based on XML. When the script runs it produces a HTML page but all the tags are coded with &lt; and &rt; instead of < and >. This means that the tags are printed in the browser rather than interpreted. Is this an XML issue, any ideas how I can solve? Is there...
  10. scriggs

    Route Add to connect to different IP range

    I have a server setup as 192.168.1.1 255.255.255.000 I want to use an existing router setup as 192.168.3.1 255.255.255.128 How can I make this work. From googling I have come across route add but do not know how to make it work? Thanks
  11. scriggs

    Connect to internet using different subnet ... route add?

    I have a server setup as 192.168.1.1 255.255.255.000 I want to use an existing router setup as 192.168.3.1 255.255.255.128 How can I make this work. From googling I have come across route add but do not know how to make it work? Thanks
  12. scriggs

    FTP access does not work with spaces

    I am using some VBA coding to connect and download over FTP. The code does not work when the path has a 'space' in it. Any ideas how to get round the issue? I think its this line which goes wrong as the FTP software gets confused by the space which is inside sFLD Print #iFile, "dir " & sFLD &...
  13. scriggs

    Import microsoft access data to MYSQL

    I am receiving data in Microsoft Access MDB files. Is there a way to import some tables into MYSQL?
  14. scriggs

    Connect to FTP, list folders and download contents to server

    I have data which is uploaded to an FTP server. I need to logon to server and present a list of folders available. Then let a user choose a folder and download the folder and contents to the server. Any one any pointers? I have seen many scripts which connect and upload/download, but nothing...
  15. scriggs

    VPN site to site - what do I actually get with routers?

    I am looking to setup a VPN to create a permanent connection between 2 remote sites. I have the servers networked on seperate subnets (192.168.3.100 and 192.168.4.100) next to each other using a switch. I plan to create a VPN using 2 VPN routers (planning Draytek Vigors). What I am unsure of is...
  16. scriggs

    Setup 2 W2K3 servers over VPN, how to setup DNS

    I have 2 W2K3 servers which are configured to network to each other. Server1 192.168.3.100 / 255.255.255.128 Server2 192.168.4.100 / 255.255.255.128 On each server I have set ROUTE so that the servers network OK. I plan to setup a VPN and connect the computers over the VPN. Each server will...
  17. scriggs

    Connecting two DCs together

    I am going to setup 2 servers which I plan to connect together over a VPN. What do I need to setup the servers as they are in remote locations: I guess a different IP range, how would I map that so the connection is transparent? Or am I heading the wrong way altogher? Server1 -...
  18. scriggs

    HQ and remote site - how to configure exchange

    I am looking to setup a fairly permanent connection between two sites. The sites will be connected over a VPN. We use Exchange at HQ and want access from the remote site: - can I access exchange over VPN or do I need to setup Exchange on the remote server? - is there a benefit to setting up a...
  19. scriggs

    Permanent VPN over leased line and SDSL using routers

    I am looking to setup a fairly permanent VPN connection between two sites. The purpose is to share an application and allow IP phones. At HQ we have a 2mb leased line connecting to internet (20 users). At remote we have a 2mb SDSL line connecting to internet (4 users). I propose to use a...
  20. scriggs

    XHTML on phpreports on windows shows &amp;lt; and &amp;gt;

    I have installed phpreports onto my windows box running PHP5. The basics of phpreports runs fine. However when it parses the XHTML onto the screen it shows all the HTML tags instead of interpreting them, so my output looks like this on the screen: <a HREF="http://www.whatisacity.com"...

Part and Inventory Search

Back
Top