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?
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...
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...
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'...
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...
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...
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...
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 < &rt instead of the tags.
Any ideas??
<xsl:text...
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 < 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...
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
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
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 &...
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...
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...
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...
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 -...
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...
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...
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"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.