Search results

I'm currently running a SQL statement with a few subqueris. Basically i divided my SQL in 2 major groups: G3 and G4. When i run them seperatly they work fine as follows: THIS IS G3 SELECT G3.Name, G3.Average AS AUM, G3.Currency, G3.VAT, G3.mngmt_fee, G3.retrocession FROM (SELECT...

Hey guys. Im a little noob when it comes to forms. So i was wondering if any of you can help me. I wanted to make 4 Option buttons, each one being one quarter. Q1 - 01 jan to 31 march Q2 - 01 april to 30 June Q3 - 01 July to 30 Sept Q4 - 01 Oct to 31 Dec Basically I wanted that all Option...

Hey guys. Me again :D Im currently using a array of files from a esternal folder as follows Dim nFiles As Integer Dim FileName As String ReDim Files(1 To 10) As String Const Path As String = "G:\xTemp\txt.NET\" FileName = Dir(Path & "*.*") Do While (Len(FileName) > 0) nFiles =...

Hey guys, I was wondering how could i replace this statement: By this one: I still think im missing a few details on the second code. the vbcrlf is a is a constant defined in vb.NET that represents the carriage return and the linefeed. I think i need to change this to access too........Im so...

Hey Guys. I was wondering if any of you know how to make a Query that would get all the tables names. Thanks in advance :)

Hey guys, Ive been enjoying a lot being part of this community. 1st of all i want to thank all the memebers who replyed for my previous doubts. I guess i still have one last one. My database (tables) are being automatically updated by a module. So its not unusuall that i have at least one new...

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

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

Hey Guys, Well i have a table with 39 observations. I made a form that updates the data of thid table. So the next values would be the observation number 40. What i wanted to do i that my form only showed the field that is not filled up, in this case would be the 40. Its like the form shows the...

Hey guys, I'm a newby here. Im programing an Access as follows: I have 1 table called indices with the fields Month,DRS, 3-Month Treasury, Lehman Bros Agg Bd Index, Lehman Bros 1-3Y US Treas, Lehman Bros 7-10Y US Treas, Lehman Bros. 20+Y US Treas, JPMorgan EMBI+, SP 500 Index. Each filed has...