Search results for query: *

Hi all, I hope you'll be able to help me. I've got a data set that is added to each day and I need to dynamically be able to calculate an average over a specific time period eg: 11/05/2009 10.0 12/05/2009 10.0 13/05/2009 10.0 14/05/2009 10.0 16/05/2009 10.0 18/05/2009 5.0 19/05/2009 5.0...

Hey Y'all! I've set up a sub as below: Private Sub UpdateQRMMaster(Updatedate As Date) DoCmd.RunSQL "INSERT INTO QRM_MASTER ( Product, UpdateDate, Mat_Date, Bal ) " & _ "SELECT temp.Product, " & Updatedate & " AS UpdateDate, temp.Mat_Date, temp.Bal " & _ "FROM temp;" End Sub Variable...

Hi all, I'm having to use linked excel tables as the inputs for my database and am then trying to normalise the data so that I can perform the necessary calculations etc. It wasn't too bad when it was all stored on my local machine, but now it's on the server, it's soooooo slow (around 30...

I've managed to normalise most of my tables, but there is on that is causing me problems! It kind of contains 2 set of data and looks like: 01/01/08 01/02/08 etc base 5 5.5 Product...

Hi All, I'm sure this has a really simple answer, but my brain just doesn't seem to be in gear today! I have normalised my data to show: Prod Date Value A 1/1/8 4.5 A 1/2/8 5 A 1/3/8 5 B 1/1/8 6 B 1/2/8 5.75 B 1.3.8 5.5 What I need to do is...

Hi All, I'm still trying to get my data normalisation to work correctly! history is I'm using excel linked files that are set up as: prod id Jan 08 Feb 08 Mar 08 etc A 10 20 30 B 10 20 30 which I'm converting to: Prod ID Date Value A...

Hi all, I'm sure I've not dreamt this, but I thought that if you linked a table from MS Excel to MS Access and you opened the linked table in Access, providing you had exclusive use of the table you could amend and update it. I've tried opening one of my linked tables and it won't let me...

I'm trying to normalise a dataset that is currently linked in excel. I have created the following which I think should work based on research that I've carried out on here Function MyData() Dim rs As DAO.Recordset Dim x As Integer Dim sql As String Set rs =...

Hi all, I'm sure I'm missing something really simple here, but it's absolutely foxing me. I'm trying to pass a couple of values to a function to give me the option of looping. It works fine if I pass one string using the following: Private Function SendMsg(msg As String) MsgBox msg End...

Ok, so I appreciate that my header isn't that great, but what I'm trying to achieve is quite difficult to explain succinctly! I have a table called tbl-balances, which has it's first column (Jan 08) populated. I then need to use this number to calculate the next column worth of data (Feb 08)...

I have 4 tables set up Sales: SaleID YearID MonthID ProdID SaleValue Year: YearID Year Month: MOnthID LongMonth ShortMonth Prod: ProdID ProdName and have a subform set up with it's source as: SELECT [tbl-Year].Year, [tbl-Month].shortMth, [tbl-Sales].SaleValue, [tbl-Sales].ProdID...

I know this has a really simple solution, but my brain just seems to have gone on holiday this afternoon. I've built a form which, through the use of combo boxes, builds up a product code. Before I add this new product to the list I would like to check if it already exists. I've set up a...

I think I need to set up a database to which I can add extra columns and extra rows and then be able to manipulate this data. Basically I have a current list of products and am looking at forecasting sales for the next x years but if i set the years up as columns, how do I view the data...

Hi folks, just a quick question. I've got a workbook that contains hundreds of named ranges that refer to other workbooks, which are not linked in any way to the current data (refers to sheets for 2001 etc!). Just want to check that I'm ok to delete them and that the named ranges would still...

I'm not sure if this is possible, but hope you lovely people will be able to help. I need to be able to run a linear regression analysis to test the fit of a line to the data points. I've tried recording a macro to capture the code that I need to run the regression, but helpfully only get...

Hi All, I hope you'll be able to help me. I'm running MS Access 2000 and want to be able to achieve the following: Customer to be able to select 'product' Customer to be able to select x and y variables (these variables will be the same for all 'products') Customer to be able to select 'view...

I hope there will be someone out there to help me! I'm trying to use a concatenate function to populate a cell, but I need to have a hard return (ALT + ENTER) in between the data (don't ask why, it's one that someone else has built in their infinite wisdom) I can't seem to get it to go in, any...

Hi all, I'm not sure if this is possible, but I've had a user ask if it would be possible to show the end of a textbox field on the lost focus event, rather than it automatically defaulting to the beginning of the text. Is this possible?! Vix

Hi all, Hope you can help me. I've been asked to produce a form to show items that require actioning today and items that require action tomorrow (they want to be able to see it on a nice form view rather than a report) what is required is: due today due...

Hi all, I have a continuous form (form 2) which lists updates, the very top of the form shows linked information from another form (form 1) as form 2 is a pop up form which opens on a button click from form 1. This all works tickety boo. However, I am trying to get rid of the spare row at the...