Recent content by studentapprentice

Well, i´ve checked it double-time and also my supervisor checked on the code and he could find any clue ( and the pseudocode nearly rly represents the real code ;) ) Now i do it with a Query, sort it by Parameter, Year and Result and save it again into a Table ready for Export. Complicated but...

Hi guys! I got a Problem which i CANNOT solve at all. It´s :banghead: IMPOSSIBLE that it is working like that. My code goes like this: (Pseudo) For every Test For Every Parameter Insert Into Table Values (AVG + Deviation) for Each Supplier Next Parameter Next Test So... when i am...

i just did see before compromising my database, it had 18 mb... after just 2 mb could it be that i missed to delete/close something that takes that much performance?

Well, the import of the excelsheet into Access is nearly instant. Its the split into the tables. But now i just succeeded to have a dynamic Table, which is ready to export but it also takes so much time. Are Recordssets slow? my just exported file hast 232 records with 19 fields, but the hard...

Hi guys! Hope you could help me out here a little bit and give me some advice. I am importing an Excel-File and assign the values to 4 tables. I am checking if it is possible to import the file (e.g. the product names are named as they are in the database, also the suppliers etc.) But the...

thx for the advice, that worked for me! but is there any way to "skip" the aggregation? the database is working with the correct values, but i dont want to sum up etc. the values, just want the values to the according suppliers is there a way to do that? i tried to handle it in the...

Hi there! I got the following problem: I need to combine the results from 3 querys in a specific way to export it to Excel. 1 query contains suppliers, 1 the products and the last the regions. The Fields of the product & region query will be allways the same so i could name the fields easily...

To get the next column you have to go one step further in your recordset via rs_tmp.MoveNext well i just called it like that, cause i you have to assign your values from your 7 tables an your own. i guess you will have at least 7 variables, each for every recordset. so that you can allways...

hi! sorry was occupied :( well how did you add it? did you use like i said in the first post rs_mastertable.AddNew rs_mastertable!field1 = valuefromOthertable1 ? you can add all your values to the fields of your mastertable (because you know its names) just do rs_mastertable!field2 =...

well, at least i guess it should not be an issue. they are at least once the same or not? perhaps it is killing a bit of performance, but i am also not experienced, just learned VBA myself last week :D the assignment is there for comparing the fieldnames, not caring on which position it is. If...

Oh i think i know where´s the problem :D i missed to tell ya to declare db Dim db As DAO.Database Set db = CurrentDb that should do it just set it at the beginning. You can also write CurrentDb instead of db at db.OpenRecordset...

For a table to work on i use code like this: 'this creates me a query on which i can operate with a recordset Dim strSQL As String Dim qdf As QueryDef strSQL = "SELECT * FROM yourTable1-7;" For Each qdf In CurrentDb.QueryDefs If qdf.Name = "tmp" Then DoCmd.Close acQuery, "tmp"...

I am currently working on a similiar problem just the other way round. I have one imported table and i want to seperate it for the database :D But this worked good for me like you set, iterate through every table. I am using recordsets in order to get my information and then you could put your...