Search results for query: *

I've been tasked with modifying someones Access 2003 database. I have a form with a bunch of comboboxes and a button that launches a query through its onclick event procedure. I can run this and pass the selected form values to the query without any problems. What I need to do is catch a...

Hi, We have a Windows application that lets a user click on a hyperlink which opens a .net web page, passes it an address reference (in a querystring) which is then converted to map coordinates. This page then redirects to another web page running our GIS passing the new map coordinates to it...

Hi, I have created a query in access that pulls out a random selection of data using the SQL: ORDER BY Rnd([ID]); This works fine, each time you click on the query the data is random as expected. However when you close the database and reopen it, then run the query again it still shows the...

Hi, I just wondered if anyone had any ideas why I'm getting the following problem. I have a web service and a seperate web application that talks to the web service. It all works perfectly on my development machine but as soon as I put the service onto a seperate web server, update the web...

Hi, I have recently created several web applications that require write access to folders on the web server (e.g. one program creates pdf's from user entered data, the other creates log files). These both work well on my development machine but as soon as I publish to our web server (Windows...

Hi, I know there are loads of entries on here about converting text fields to date fields in access sql. My problem is I have a text column that may contain either a date or a text string but I only want to query dates. e.g. the column issued_date could contain: 01/02/2009 or "Date tba" Is...

Hi, I have some code that uses a pop up calendar to select a date. Once the date is selected it passes back to the specified text box on the form. This works fine on all my pages except when I use it in the editItem part of a Gridview. All I want to know is what I need to add to the following...

Hi, First of all, apologies if this would be best suited to a Javascript forum. I have some code that uses a pop up calendar to select a date. Once the date is selected it passes back to the specified text box on the form. This works fine on all my pages except when I use it in the editItem...

Hi, I have an sql database table containing contract information. In it there is a Bit column called "Terminated" which is either True or False. On my aspx page I have a dropdown which has the values Terminated and Current which will send either a true or false value to the database. I would...

Hi, I have 3 textboxes within a Details View, Unit Cost, VAT and Total. All I want to do is, after a user has entered a figure into the Unit Cost to automatically calculate the VAT (unit cost * 17.5%) then populate the unit cost + VAT in the Total textbox. Is this possible without doing a...

Hi, Is it possible to bind a TextBox in an InsertItemTemplate to the results of an SQL Query? All I want to do is insert a new record into a database (using DetailsView) but I want the first textbox (FleetNo) to automatically be populated with the result of another sql query (all it does is a...

Hi, I have 2 sql tables, one called tbl_orders and one called tbl_stock. When a user places an order, the details of that order go into the tbl_orders table. The order then comes to us to process. A status field in this table is set to "ordered" When the item comes in I would like to update...

Hi, I've just started trying to get to grips with asp.net and i'm not really understanding how Windows Role Based Security works. I am working on multiple intranet applications that I would like to control who can access to update and view. For example I have a phone list that I would like all...

Hi, Is there a way to seperate each digit in a string containing a number. Say for example I had: 123456789012, i'd like each number in a variable so: num1 = 1 num2 = 2 ... num12 = 2 The number will always be 12 digits long but the 12th character may sometimes be an "X". Thanks.

Hi, I have set up our MD's PA to have Send As access to the MD's mailbox. Is there a way to get sent items sent as the MD to appear in his sent items rather than the PA's?

Hi, I am new to VBScripting so don't know if this is possible but I have a script that copies some program files and folders to PC's on the domain by reading in a text file containing PC names. The copy part seems to works fine but I need the script to then run a batch file on the remote...

Hi, Is there an easy way I can change the items shown in a dropdown list by clicking on another dropdown list. i.e. Category then Sub Category. Both drop downs need to be created dynamically from tables in a sql db. I have trawled through various internet articles but the only real relevant...

Hi. I have been asked to query the amount of sickness for our company over the last 12 months. I have created a query to do this which seems to be working. However I also need to display user details for those that have not had any sickness in the last 12 months (but prior to this they may...

Hi, I have an asp web page with one form on it but two Submit buttons (each posting the data to a different page. The first Submit button has the following JavaScript code: <input type=&quot;submit&quot; name=&quot;submit1&quot; value=&quot;Submit&quot...

Hi, We are having a problem where our NT4 (SP6a) Workstations are contacting our domain controller every 21 minutes but we do not want this to happen. After checking the Microsoft Knowledge base we have discovered that a hotfix was released for this some time ago containing a revised MUP.SYS...