Recent content by LordLoki

hi Minty, Thanks for the Quick reply. Good to hear that cause my initial planning was based on Rows but i started to doubt it and wanted to have a second opinion. And thanks for pointing out that its the normalised way that key word gave me something to google for and i got some pretty good...

Hi together, I hope the Title is not to shabby. i need to store a lot of Values for a tool that generates statistics for outbound Campaings and i am not sure if it is better to store my different Values in a Column or Row based structure. To give you a better understanding here is an...

Hi Namliam, Thanks for your input, still struggling with the right terms. in the last 4 weeks i was reading a bit about the whole Query things and found that a join like in your example is much more efficient. I will rebuild my querys step by step and surely come back here soon when i get the...

Was long time not online just wanna let you know that i put indexes in and got a much better result. Thanks for that tip :)

Hi Friends, I am Back with a possible Problem, and hope you can help me to get a better Result. I have a Table with some Information (how obvious :D ) The Relevant Data is this Table: ShareData Service --> Name of a Queue Intervall --> Time Intervall like 8,9,10,11,12....22 Sprache -->...

Yes i will post sth when im home

Hi there, i hope someone here can give me a clue in the right direction cause i dont know if what i want to do is possible or not. I have to tables that contain Data that i need to create a new view. First Table is like this Year Weeknumber Queue Value Second Table is like this...

Hi Immortal, It should work with this: "DELETE [MemberProjectT.*] FROM MemberProjectT WHERE MemberID = " & Y & " And ProjectName = " & List23.Column(0, List23.ListIndex) & " " Where the 0 in "List23.Column(0, List23.ListIndex)" is the column number of the Projectname The list23.listindex...

Its not size cause we are writing the same data we deleted just with the new intervall. The problem is not only getting the latest data and write the newest that would be easy to do. We would also need to check if the latest existing data is the same as in the new source sheet. But i think that...

Hi Gina, Thanks for that link read it and its very nice. Will try to follow that rules and make my work more readable for others. There are some questions popping up but i will google a bit before i come back to you for them. One i have to ask now cause we are building a small access table at...

Ah Gina just see that i missed yout Post with suggestions. And yes you are right i should force myself to better naming of variables and tables. Point is i can look at even 3 year old code i wrote and identify everything cause thats how my mind works. Problem is coming at work where sometimes...

Good i was hopong its not too bad :)

Uups! Fixed that! I think i did not have enough Coffee Yesterday :D

Thats the best thing if you can learn by helping each other and have guidance from an experienced User :D Cause i was lazy for writing and got confused by my own explenation i just show how i did it in small vid tutorial. i was not 100% Focused so the was a little mistake in the beginning that...

Hi Immortal, I am with you my friend but i will be posting some information later cause i am on the way to work now. For the time check out this video about Queries i found it helpful: Creating Queries with Microsoft Access 2010: http://youtu.be/n2LWqnN-yCY The [Forms]![Projects]![CB_Pname]...