Search results

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]...

Thanks Galaxiom thats a very cool function i did not know of. Greets Loki

Hi There, Just clicked together some Sample Database. Only VBA that is involved is to refresh the Listboxes when you change the Combobox for Employee/Project Its not nice looking just to help you understand how it works. As i say i am new to access too but maybe it helps you to get your thing...

Hi Immortal, Im still a beginner in Excel too but i think i can help you with this. 1. Never use Calculated Fields in a table that is just causing problems from all i read so far. So you have to do the Calculation in a query 2. if you already have a 3rd table with employee id and Project id...

I did not look at the solution of sparklyprincess but you can achieve the wanted result buy using an IIF statement to define the Category. I will post an example later when im back at the Computer And here is the SQL Code: SELECT IIf(Jobs.SquareFootage <=50,"0-50",IIf(Jobs.SquareFootage >50...

I am not an expert in access but i think you need to do it in this order 1. Do movelast 2. Do recordcount and save it to a var 3. Do movefirst 4. Compare absoluteposition to your var. I will post the code when im back from lunch if needed Edit: Private Sub Command2_Click()...