Search results for query: *

Hi Guys, Thanks for these replies cheers Dan

Thanks to you both!

Hi All, I have a table that records information on jobs that my business customers need completing. There are several fields of varying types in the table, including a memo field. I am using a multicolumn list box on a form to display a number of these fields from each record - the intention...

Hello Again! I assumed (and we all know what happens when you assume!), that when I substitued your code: SELECT TOP 1 Comment FROM MyTable WHERE EnhanceID=1234 ORDER BY ID DESC; with: SELECT TOP 1 comment FROM mytable WHERE enhancementID= myreport.enhancementID ORDER BY ID DESC; it would...

Thanks HarleyQuinn, worked like a charm! Based on what I've seen on the forum learning to use SQL more effectivley will save me a fair few lines of code, and save what little hair I have left! Cheers Dan

Hi All, I have a table (mytable) that has the following columns: ID EnhanceID Comment ID is a numeric primary key EnhanceID is numeric Comment is text I have a simple report ('myreport') that returns all of the comments for an 'EnhanceID' and the corresponding 'ID' value (each...

Hi All, I have come across a bit of a problem. I am creating the site at www.ozbound.net, if I go to this homepage on any PC other than the one I did the creation of the graphics and html on then I can seee the page fine, it has a side bar menu, a frame for the inclusion of my blog and a...

spot on - thanks Nick

Hi All I have a query that should be a normal 'select' query but keeps askinig me for a parameter. This is the query: SELECT tbltransactionsbycatthismonth.key, (SELECT Sum([tbltransactionsbycatthismonth].[value]) AS Total FROM [tbltransactionsbycatthismonth] WHERE...

Jo, I gave method 1 a try as it seems an elegant solution but can't get it to produce a running total. Any chance of an example as suggested using Northwind ? Many thanks Dan

Jo, Thanks for those solutions, I shall give them a go and see where it takes me ! Regards Dan

Hi Jo, I've checked out the Northwind dbase and can't find what I need. I've included a short example date value c. Tot 3/4/02 10 10 4/4/02 7 17 6/4/02 5 22 7/4/02 11 33 The date and value info I have the c. Tot info I wish to calculate...

Hi I have a table containing transaction data entered from a form. For each record there is a 'value' field. I need to filter the records by catagory, order by date (both of which I can do) and then include a column that carries a running total of the value. I could push it all out to excel...

Jay, At the risk of over simplifying it. In the properties box for the control there is a 'source' field, nect to this field is a drop down arrow as well as the ... for the expression builder. When you click the drop down you should get all the possibles you can link to. Does this work ? Dan

Jo, Thanks for the help. I gave it a go and it seems to work most of the time but occasionally I have to open and close one of the other tables on the tab to get it to refresh. Any ideas ? Thanks again. Dan

Hi all, I am using the folowing code within a do..while loop to create tables named tblreport1monthago to tblreport6monthago. The problem is that when I run the code stepwise to debug it the new tables don't show up on the database 'tables' tab. If I run the code a second time I get error...

Hi, Not exactly but I had a similar problem recently by naming something 'Date'. It appears that you have named one of the controls on the form as Date, I changed mine to myDate and it was OK. Also I had problems refering to 'Date()' in the forms class module, it kept comming up as null. I...

JHall, Much oblidged, now why didn't I spot that ! I appreciate the help Regards Dan

Hi All, I have a form on which (among many other controls!) there is a frame of 4 'option buttons' (Radio Buttons) which are mutually exclusive and refer to Friday, Saturday, Sunday and Today. There is also a text box labeled 'Date'. The default for 'date' is Date(), I would like this to...

Hi Knutjo, I'm afraid I haven't solved the problem. However I ran the following code: Sub AppendSheet() For i = 1 To 100 Worksheets("ANLEGG-Utstyrstype MASTER").Copy after:=Worksheets(Worksheets.Count) Next i End Sub and it worked fine, I'm using excel 97 on a win...