Search results

Hi there, I have various invoice numbers ABC111111 DE9999999 FG7777777 etc and I would like to remove all the text from tem so I am only left with the numbers. Any help appreciated Thanks Geoff

thank you very much, I wasn't expecting such a indeph solution Geoff

I have the following value V:\Neil\B4014_1.csv And I need to strip out the part between the Last "\" and the ".", So I am left with B4014_1 Any help much appreciated Thanks Geoff

Hi there, I am trying to use "Daveswanton77" code as shown above, but get the following error as the following lines "User-defined type not defined" Dim fs As FileSearch Dim fso As Scripting.FileSystemObject Dim myfile As Scripting.TextStream Any ideas appreciated Thanks Geoff

I have the following calculation =IIf(DLookUp("[PresDD]","[qryEnergy_Report_Data_(Table_10)]","[Name] = 'Main Campus' And [Utility] = 'Heating'") > DLookUp("[PrevDD]","[qryEnergy_Report_Data_(Table_10)]","[Name] = 'Main Campus' And [Utility] = 'Heating'"),"An increase in consumption of " &...

sorry don't get what you mean

Thanks, I was trying to get away from having a stored query as this will soon be converted to VB6. There is nothing I can do about the table it is backend of a .exe Is there a way I can do this with out having a stored query Thanks Geoff

Thanks for helping, it is appreciated I am getting the error at QD1.Parameters![Forms]![Report_Criteria_Selection]![Start_Date] = [Forms]![Report_Criteria_Selection]![Start_Date] I have attached a stripped down copy of my db, which I hope will help Thanks Geoff

Thanks, I did see the other thread but it just went over my head. I am very new at this. I have adapted my code as follows Option Compare Database Option Explicit Private Sub Create_30_Min_Data() Dim dbs As DAO.Database Dim QD1 As DAO.QueryDef Dim rst1 As DAO.Recordset, rst2 As...

Too Few Parameters Hi there, I have the following code Option Compare Database Option Explicit Private Sub Create_30_Min_Data() Dim dbs As DAO.Database Dim rst1 As DAO.Recordset, rst2 As DAO.Recordset Dim i As Integer, timevar As Variant Dim strSQL As String strSQL =...

just one other thing how can I specify a particular dataset and or time frame thanks geoff

Thank you both, this works a treat only a few lines of code to do something that seems so difficult

Thanks for your help the other day with my subquery problem. it worked great. the problem I have now is that I need the same thing but need to be able to specify the start date of the year ie 01/06/02 to 31/05/03. also there may be more than one rate for each month, and I need to how the average...

I have created tbl2 by hand just to give you an example of what I need. tbl1 is actual data which I need to convert into the format as shown in tbl2 thanks geoff

I think you have misunderstood me I don't have the data in xl it is in an a2k table, I have attached a db with 2 tables tbl1 is the data I currently have tbl2 is how I want the data to look. Thanks Geoff

I currently have a table in access show as "change from this", which i need to change "to this". I showed it in xl as that was the easiest way thanks geoff

Here's a sample of what I require, should make sense now thanks geoff

instead of having the value in the each of the 48 time columns, the table would have one column for the date and time and a second for the value of the time column

I have a table of data with a column for the date followed by 48 colums for the half hour intervals for the day. what I need to do is to place this in a new table with only 2 columns 1 for the date and time and the second for the value. any ideas anyone thanks geoff

This is great Jon, if I could only pinch your brain for a week all my access problems would be over