Search results for query: *

Thanks never thought of mousedown. That's sorted my issue. Cheers Andy

Hi I'm using a flexgrid and the number of columns goes past the visible area of the grid. In the grid's Click event I have a subroutine that selects data from the column clicked on by using .mousecol. When clicking on the last visible column, which is wider than the remaining visible area for...

Brilliant. Many thanks. I was almost there but was using WHERE ugm.UserID = @UserID instead of AND ugm.UserID = @UserID

Hi I'd like to know if what I'm trying to achieve is possible. I have 2 tables A user group table consisting of... UserGroupID Description and a user group members table consisting of... UserGroupID (as above) UserID Want I want returned is a list of all the UserGroups with a flag to...

So, why do you want to close RSContactNames?" I was trying to match the code to our existing wy of doing things which means setting up classes to hold all the dat to be used by forms. We also have routines to handle the connection and set up of database calls. I'm told the returned recordsets...

HI I have added some code to a class module to get an ADO recordset which I want to return to the calling module. After this line of code... Set GetContactNameRecordset = rsContactNames ...both recordsets are populated but as soon as I close RSContactNames, GetContactNameRecordset also...

Thanks all, using FORMAT worked, see below SELECT FORMAT(TIMEVALUE([Time label]),"Short Time") AS [Time slot], COUNT(TIMEVALUE([Time label])) AS [Number of] FROM Slot WHERE TIMEVALUE([Time label]) BETWEEN #08:00:00# AND #20:00:00# AND [Time label] GROUP BY TIMEVALUE([Time label]) ORDER BY...

There are valid dates in the field as well as time and everything works OK in Access. I'm thinking that as the SQL is built up within VB that the type of the data is being changed perhaps? I will look at formatting it though, so thanks for that

Hi I'm running the following SQL Query in VB6... SELECT TimeValue([Time label]) AS [Time slot], COUNT(TimeValue([Time label])) AS [Number of] FROM Slot WHERE TimeValue([Time label]) BETWEEN #08:00:00# AND # 20:00:00# AND [Time label] BETWEEN #03/01/2007 00:00:00# AND #03/07/2007 23:59:59#...

A good point. I did consider it but it's unlikely that any of our customers have that many clients. And as it's for an Aged Debt report, that many clients owing them money and I doubt they'd still be in business. :o)

I've added the Excel formula into the text file (saved as a ".csv") and it gets converted when Excel opens it. The code I used follows, in case it helps anyone.... I wanted to make this routine generic but I can't guarantee, as in this case, that the recordset fields are in the right order...

I'm having to add Excel functions to total up at the end i.e. =SUM(G4:G205), because the totalling is done by the datareport and I can't retrieve it to use to create the relevant fields in the .csv. Using the Excel object in VB6 might help but they don't like using too many references here.

Using the recordset bound to the report is OK but I have SUM functions that are added to the report designer and so not in the recordset. To get those I will have to add fields in the .csv file which will be Excel functions. When I used Crystal you had access to each line of data as the report...

Hi I've been asked to convert one of our datareports to a .csv file so users can open it in Excel. Is there a better way than just reading through the data environment and building the .csv from that? That would mean having to add the formulae/functions for horizontal and vertical totalling...

Hi I have a Brother printer on my network. It works fine initially but eventually when I try to print something the output just sits in the print queue. The printer is still showing in my printer list as the default. To get round it I have to remove the printer from the printer list, re-add...

What I really want is a list of clients broken up by client dept. so that on change of client Dept there's a group header saying what the dept is. i.e. Dept: 1 Client 1 Client 2 Dept: 2 Client 3 etc I have written an report already, which is an Aged Debt report sorting either...

Hi I'm hoping this can be answered quickly, if possible. Is it possible to add Grouping to a DataReport without using MSDataShape, or setting up a child command? I'm using an ADO with Access databases but there's a lot of processing and comparing to other recordsets. Thanks in advance

OK, thanks I will try those things

I'm pretty sure I have tried the 2 512Mb sticks and they both worked. But again - I've tried swapping the 2 1Gb sticks around in the slots and only ever 1Gb

The laptop is an Acer 5612Z. It came with 2 512Mb memory sticks. I bought 2 1Gb sticks from Crucial. Which they later replaced after the laptop came back from Acer, so I assume they are a matched pair like the first. As you say Deenap, both modules work in either slot so I'm thinking Acer's...