klaul
Last Activity: Jan 20 '09, 06:38 PM
Joined: Mar 13 '08
Location:
-
Thank you very much - orangecat, your solution worked pretty much as you described. Thanks! -
Export Delimited files removes DateTime formatting?
I'm hoping that this is going to be an easy one to solve, but I've been trawling google and have had no luck at all!
I'm using Access 2003, and am trying to export the contents of a table into a pipe delimited text file using a macro with a pre-set export specification.
The file exports fine, but one of my columns is a date column. The formatting in the table is dd-mmm-yy, but when I export it becomes dd/mm/yy 00:00:00.
I'm... -
That works fantastically - thank you very much!Leave a comment:
-
Syntax on View/Cross tab join
Hoping someone can help me here!
I'm having some problems trying to get the right syntax for a view, and am wondering if someone could point me in the right
direction!
My code is currently:
...Code:SELECT DISTINCT a.Department, a.Section, SUM(CASE b.Type WHEN 'T' THEN b.LYAmt ELSE 0 END) AS TLYAmt, SUM(CASE b.Type WHEN 'I' THEN b.LYAmt ELSE 0 END) AS ILYAmt, SUM(CASE -
Populating Multiple DropDownLists
I've been trying to do this for a day and a half now, and am clearly getting nowhere!
The database I'm using is used to keep a log of service calls to various companies. When the user inserts data, they choose the company from a static list, but the reference number is user-supplied. The data is brought back using a GridView.
I am trying to create two linked dropdownlists so that I can search the gridview (so that the items... -
Postback issue - ASP.NET
Hi there. I'm having an issue with autopostback, in that it doesn't seem to be working!
The webform I am using pulls the data from an AccessDataSourc e to populate the gridview, which has Edit and Delete functions. I have also configured it so that I can insert into the gridview using the footer row.
What I am now trying to do is create two searchable dropdowns in the header of the first two columns (company and reference) that would...Last edited by jhardman; Apr 8 '08, 03:30 PM. Reason: split up excessively long code into sections so it will display, move to .NET forum (ASP forum is for "classic" ASP)
No activity results to display
Leave a comment: