Recent content by jakobal

Hi vbaInet, I don't get ghudson's example to work. I keep getting this message: "2391 - Field 'F1' doesn't exist in destination table 'tImport'" I've changed the table tImport so that it now has the structure of my excel files, but I keep getting the same message. Any clue on why? Thanks!

Hi Rkay, Yes they are. There is no difference in structure or format between the files from different weeks, only the number of records varies. Jakob

Forgot to say that I am quite new with coding.. I have a form in access where users can choose different options in drop-downs and then create different reports by pushing different buttons. Two times a week, I extract data from another program. The data is extracted as an excel-file and...

Hi, I'm trying to create a command button which clears data in an existing table and then lets me choose an excel file to import new data. The first row on the excel-file I import consists of the headings. Is this possible to do in Access? Any help is very appreciated! Thanks! Jakob

Hi Taruz and thanks again, I just tried out the code and now it is returning values. I am getting one column with the month and one with the what I think is the aggregated value for the month and the previous months. It however seems to be one record for each record in the previous table...

Thanks again Taruz, I'm not really making it work. I get the message: "The Microssoft Office Access database engine cannot find the input table or query 'aatrz'. Make sure it exists and that its name is spelled correctly" Do you know what I am doing wrong? Thanks! Jakob

Hi Taruz, Thanks for you answer. I still tough have the problem of not aggregating the months together month after month. With the code you wrote, if going back to the example I wrote before, I get: Jul 13 Aug 12 Sep 3 Instead of Jul 13 Aug 25 Sep 28 Any idea of how to do this...

Hello everyone, I only have some basic knowledge in Access so I guess this is a simple problem, but any help will be much appritiated! I have a list with records that include two columns, dates and numeric values. What I would like to do is to from the 1 st of July each year start to...

Hi! I'm trying to define the SourceObject of a Subform in my Report as the SourceObject of a subform i my Mainform. I want this to be defined when I open the report. I thought this would be enough: On the reports event "On open" i've have this code: Me.Subform.SourceObject =...

Thanks Brian! That worked perfectly!

I don't really follow you...?

Thanks for the help, but it still doesn't work. When I do that, then I get the results sumed up by day, displaying in my first column which week it is. So since I have results from 5 days/week, I get my weeks devided into 5 results, the daily results. My final goal is actually to show this in...

Order by date seems to give the same result? Maybe I should explain a little more how I'm doing this... In my table I have one column with dates and one with testresults. If the test failed it will have the value zero, if it's passed it will have the value 1. For each day I have a lot of...

Hi everyone! I have two columns. In one of them I have daily dates and in the other I have some numbers. What I'm trying to do is to sum the numbers weekly by entering this in the field of a query: Week: Format([Date];"yyyy\ ww") The problem is that when I go to datasheet view, it is sorted...