Search results

What should i put in the then statement to make it go to next loop

Hey Guys, I'm running a code that imports a few .txt files as linked tables in my access, but i needed to create a IF, THEN, ELSE statement with the condition that follows: File Name is already defined and is the name for each text file which is also the same name of each table. I still dont...

Sorry again. I hate being that noob. But im working hard to get better. Well let me try it again to see if it is better explained: What I meant about the 39 is: The resoult of the query will be a table in which every column will have only a zero or a one, because this binary code is connected to...

Oh ok. Sorry about that. Im attaching the database now. About the INNER JOIN, I've tried it before getting 39 at all the columns that should be 1 and 10 in the BalancedAllocation colulmn. The thing is that i need to use this resolut on another query afterwards, and that is why i need 0 and 1...

Ok, no prob. In this link ive upped the excel and access file: http://www.access-programmers.co.uk/forums/showthread.php?t=111002 By the way thanks a lot for the help :) Ill try to reformulate the question to see if it helps: Well, I have a database table that "in terms of excel" has 9...

Ok. Its all renamed as attachment. Sorry btw. I know u guys are doing me a favor. Sorry if i was unpatient. And thanks for the help

Ill try to reformulate the question to see if it helps: Well, I have a database table that "in terms of excel" has 9 columns and 39 rows. 1st I needed to create one form that would allow me to include new data to the tabel. I made it ok. So far so good. The part of queries is a bit more...

I kinda thought that. But the thing is that in excel the procedure on updating all the stuff and making the forms is very suitable for many mistakes. And i have many reports linked to that excel that i posted. I can work pretty good in excel, but i thought that if i did in access i could...

Ok. It works like this: I have an excel file that has a main table. Basically this table has 9 columns and 39 row. What i need to do from this table is: Calculate an index called BalancedAllocation with the following excel formula: =(0.05*O5+0.45*P5+0.5*V5). Then I need to calculate a binary...

Well the thing is that i need this IF formula to the whole table. Not only to balanced allocation. Thanks for the help :)

That was awesome. Thanks for the tip. It is all i needed. Btw, if you could help me out one the queries i'd be more than gratefull to you. My brain is almost stopping now. Ive tried so hard to find out this things and havent came to any conclusions. Thanks 4 all the help Banana. You really...

Man im so noob. Can you tell me please the step by step way to make it? Thanks again!!!!!!!!! :D

Well The thing is that i have to make this excel table in access. I attached both files here: http://www.access-programmers.co.uk/forums/showthread.php?t=111006 And im confused wheter to make it with sql or vba. And by the IF thing i mean the formula. Thanks a lot for the help!!!

Oh Sorry rural guy. Just saw your attachment now. It works perfect!!!!!!!!!!! Many thanks!!!!!!!! By the way, what did you do to make it like that? Thanks a lot for all the help guys :)

Hey Rural guy. the attachment does not work like that. It starts at the 1st of 39. SO when i want to add another valeu i vale to go one by one or press the>*. What i wanted was instead of it that the form would appear already in the 40th observation Kind Regards

OK. I upped the zip. Please take a look. I also have a few query questions that have been killing me for the past few weeks. MAybe you can help me out. Please check those links: http://www.access-programmers.co.uk/forums/showthread.php?t=111002...

Hey People, im kinda giving up hope on ACCESS. Ive been killing myself tring to figure out a few thing for several weeks and still havent came to any conclusions. This is a desperate call for HELP. SO PLEASE HELP ME OUT GUYS, cuz im almost loosing hope here. Ok Guys so here it goes :confused...

WOW!!!!!!!!!!!!!! Damn Ruralguy.........you ROCK!!!!!!!!!!!!!!!!!!!!!! Thanks a lot :D Just one more thing. How can i make my form apear on the after the last data i have, in the new additions screen, and also how to make it accept my changes with a pop up screen asking accept addition "yes"...

Ok. I solved this: SELECT Max(Indices.Month) AS MaxOfMonth, Min(Indices.Month) AS MinOfMonth FROM Indices; BUT i still couldnt make Q1 Work And The JOIN thingy does not work too :( Anyone

Oh cool. In the Locked part right. Is there anyway i can lock all my sheets at once? Thanks a lot for all the help Rural guy :)