Search results for query: *

Hi! I'm running a query in Excel from an Access Database. The table in Access has a date column and a price column, and contains about 3000 records. I want to limit the query in Excel to the 200 most recent records. Any ideas out there?! Thanks, VC

Hi! I'm running a query in Excel from an Access Database. The table in Access has a date column and a price column, and contains about 3000 records. I want to limit the query in Excel to the 200 most recent records. Any ideas out there?! Thanks, VC

Hi! I have an access table with a date and price column. I want to do a rolling 15 day sum of the prices in a query of the table, i.e. for every day, sum the previous fifteen days prices. I think the DSUM function in the Expression Builder is what I want, but I'm unsure how to actually build...

Hi Having problem with a pivot table Data looks like this Column1 Project Code Column 2 Category Column 3 Description Column 4 Location Column 5-16 Sept, Oct Nov etc There are $ amounts under each of the months On the PIVOT table I have Location as a Page field, Project, category and...

Hi, I'm not even sure if I'm in the correct forum, but here goes! I want my PC to be connected 24/7 to a datafeed that is received over the internet - will this damage my PC or slow it up? Is it bad for the PC never to log it off? Any help at all would be greatly appreciated! Thanks VC

Hi! I have an access database table with daily data. How do I create a query (if I even have to create one!) to summarise this data on a monthly basis? Thanks!

Hi! I want a sub to be triggered if an excel cell has a certain value. The cell is linked via a dde link that constantly updates. I want it to run overnight too, so it rules out just using command buttons. Any ideas? Thanks!

Hi! I've got a report that requires different headers for different chapters, all on the one document. For instance, pages one to 20, I want 'Chapter One' as the header, pages 21 to 40 'Chapter Two', etc. is this possible? Thanks!

Hi, I have a VBA form containing a Combo Box that reads in dates from cells in an Excel Spreadsheet. When I click the drop-down button, the dates are shown, but when I select one, its integer value appears in the box, how do I fix this so the date format appears and not the integer? Also, how...

Hi, I know you can link Spin buttons to a cell in a spreadsheet and change the value of that cell up or down, but it only seems to work for integer values - is it possible to change the value of a double? I.e. Use the spin button to change a value from 116.86 to 116.87, etc. Thanks a lot!

Hi! Can anyone tell me what the following means: "Run-Time error '6': Overflow" I'm running an application over a fairly large number of worksheets, could that have something to do with it? Thanks!

Hi! I'm trying to use a COUNTIF statment within an array, but it keeps returning an error. I have an excel table with about 5 categories (A:E) in column A. There are 57 different rows in the table, with the values I'm concerned with in column K. I want to create an array formula that will tell...

Hi! I want to use a Control Button to run a simple formula in Microsoft Excel. The problem is that VBA won't recognise the text portion of the formula. I'm sure there's a simple answer, but I can't figure it out! The code is as follows: Private Sub cmdCheck_Click()...

Hi! I'm attempting to write some simple RecordSet code to identify the latest record of a table (determined by a Date field). The table is a linked table to an Excel worksheet that contains hundreds of records. However, everytime I use a RecordCount, it returns "1". Does it have...

Hi! Okay, I know that its easy to import a whole Excel file to Access, but what I'm looking for is a little different. I want to be able to copy three cells from an Excel file and insert them as a record into an Access file. Basically, I want to copy a row, not the whole Excel file, and...

Hi! I realise this is probably a simple question, but I cant get to grips with it! I have a table containing two fields - price and data. I wish to run a query that will contain the two fields mentioned and a field that will calculate the average price for the previous 15 days, up-to and...