Search results for query: *

Great thank you, that looks like a much cleaner way of doing what I want to achieve.

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...

Thanks for the feedback. I had a feeling it wasn't something that was straightforward to do. The problem is I have no control over the desktop or GIS applications, the GIS application is written in such a way that it keeps a session open to the server until the web browser is closed or until 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...

I think I've fixed it, the random thing was always using the same sequence of numbers which is why it reset back to the beginning each time I closed the database. I've changed the Order By bit of the query to create a Random seed from the current date and time: ORDER BY RND(INT(NOW*ID)-NOW*ID)...

Thanks for the post. All I am doing is selecting 50 random records from a database by ordering by a random number using the primary key of the table as a seed. The query is working perfectly, every time I run it I get the 50 random records as expected, different every time. What fails is if...

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 guys, thanks for the feedback. Remou - no i'm afraid I still get the data mismatch error with that. MajP - Yeah I know it's not ideal, it's a very old asp and access solution that I will be rewriting with .net and sql eventually but for now I need a quick fix. I've no problem adding...

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...

John, I should have mentioned before that I've also tried SELECT SUSER_SNAME() and I get exactly the same issue. Returns my Active Directory logon in a standard query but the database logon in a trigger statement. I realise that this is what should be happening as the trigger is fired by the...

Is it possible to do this within a SQL Trigger statement? If I run a straight query using SELECT SYSTEM_USER I get my AD logon which is fine, however if I use this same statement in my trigger I get the database logon (dbo). Is there some way to pass the AD username to the trigger statement...

But isn't the ClientID different depending on which row is being edited? i.e. GridView1_ctl03_txtEndDate for row 3 or GridView1_ctl04_txtEndDate for row 4. Is there something like GridView1_SelectedRow_txtEndDate I can use?

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...

Great, works a treat. Thanks.

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 blar9, Yes thats pretty much what I was looking for. Using a combination of: Page.ClientScript.RegisterClientScriptBlock and CType(DetailsView1.FindControl("TextBox4"), TextBox).Attributes.Add("onblur", "return Calc();") I have achieved what I wanted. Many thanks.

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...