RJMac
Last Activity: May 31 '07, 01:56 PM
Joined: Mar 16 '07
Location:
-
DevonKnows - thanks for the recycle bin information, it's very much appreciated!! -
How wide is a string?
Is there any way to measure the width of a string of text in pixels? I know how many characters there are in the string, but i's and w's are different widths and the problem gets worse when you add in factors like italic or bold and as for different fonts... Basically what I want is a command that when suplied a text string and font name, etc. it returns the screen width in pixels.
Any method that works in VB6 would be appreciated.... -
One little question - will Kill send the file to the re-cycle bin, or just get rid of it, as I would find it would be useful to be able to send files to the re-cycle bin...Leave a comment:
-
Hi there,
I’m sorry about the confusion, but the data is displayed directly on screen using a DataGrid, so there is very little code involved other than the SQL of the queries themselves.
The SQL for the final queries is held in a table with the appropriate one being selected by a combo box. subUpdateRecord s is then fired off. rstmTextQuery is a module level recordset on the form which also holds the DataGrid so that...Leave a comment:
-
Hi there,
I'm using a single Access database with a number of tables and built in queries. For the problem I'm having at the moment, only 4 of those tables and one built in query is important, the tables are listed below with some of their fields (All fields relevant to the query in question):-
tblAccountsEtc: UsageID, NameID, ItemName, OpeningBal, SortOrder, DateOpened, Colour, Group
tblAccountUsage : UsageID,...Leave a comment:
-
The query held in sSQL (shown below) is one of the queries I am using to pull data out of qryJoinBalanceD ata, all of the queries work fine in Access, it’s only in VB where the answers come out wrong, e.g. one row of data which should sum to around –19,000 actually sums to +533,000 in VB.
Code:SELECT ItemName, Sum(Amount) AS SumOfAmount FROM qryJoinBalanceData GROUP BY ItemName, SortOrder ORDER BY SortOrder;
Leave a comment:
-
Hi there,
The variable sSQL is normally populated from data in a table as there are a number of different queries which can be run using qryJoinBalanceD ata as their datasource, but they are all suffering from the same problem as the one shown below.
...Code:Dim rstTextQuery As New ADODB.Recordset Dim sSQL As String sSQL = "SELECT ItemName, Sum(Amount) AS SumOfAmount FROM qryJoinBalanceData
Leave a comment:
-
The form you are using needs to be bound to the Table holding the fields you mentioned, and you need to have Microsoft DAO set in Tools/References on the tool bar. If both of the above are true, then the following should work:
You need to have 2 events set up - One for the Form - the on Current event, and one for the txtFileNumber text box - the AfterUpdate event. I'm assuming that your data table is called tblTable1, and your File...Leave a comment:
-
VB6 ADO 2.6 miscalculating sums in an Access Union Query
I’m using ADO 2.6 in VB6 to read in data from a Union query (qryJoinBalance Data) in Access 2000. The Union query contains 3 sub-queries, each of which joins several tables, but they all generate exactly the same fields containing the same type of data.
I’m using qryJoinBalanceD ata as the source for a Group By and Sum query which compresses 4600 rows of data to 73. When this query is run in Access, it works perfectly, however when run...
No activity results to display
Leave a comment: