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

oh yes........even better. Thanks for the tip

Many thx for the reply Im using this one now Its finally working great :)

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

I guess i could do something like this Sub a() Dim db As DAO.Database Dim FileName As String Dim i As Integer Set db = CurrentDb() For i = 0 To db.TableDefs.Count - 1 FileName = db.TableDefs(i).Name If (Left(FileName, 4)) = "~TMP" Then GoTo here If...

oh ok. It seems to work but has one problem so far. I got a lot of temp (TMPCLP) and MSys files with this code. This can bug my formula. DO you know how i can take that off. I think this is all i need from the code. Sub a() Dim db As DAO.Database Dim FileName As String Dim i As Integer...

should it be something like this: Dim nFiles As Integer Dim FileName As String ReDim Files(1 To 10) As String FileName = CurrentDb.TableDefs().Name Do While (Len(FileName) > 0) nFiles = nFiles + 1 ' If array is full... If nFiles = UBound(Files) Then...

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

problem solved thx everyone

ok.......i solved this one :D

This is the code Im using now Its returning only one value. I cannot figure out why. The value it returns is only from the last name on the array.

Thanks for the Reply Gemma. Actually what im trying to do is that instead of creating a query for every table I have i wanted to creat one query with them all, because to build a dinamic query I must have one think in mind, The final query should be exactly the same as if I typed it. So i was...

so far my code looks like this

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

yes, i guess its DoCmd.DeleteObject acForm, formname Formname can be an array with all the forms names. Then you loop it. It might exist an easier way, but that is all i know

Also after putting them in the same table i wanted to traspose the values. I got this function But i still dont know how to call it in my code :( Actually i think this code is to traspose tables. Ill have to fix it for query. But 1st i need to group all the other queries in one. Ive been...

Now i'm trying to make a loop with an array as table. I wanted to get all of them in the same query The data is being passed correctly. I checked with the MsgBox So far i can loop and create a query for each individual table. I just couldt manage to create one for them all together. Can i add...

actually the dates are being passed as: 11.07.2003 and 11.06.2003 And the Table is being passed too The error seems to be on the date. I changed the code to And it works. The problem seems to be after the Between Ok. I found it out. It seems to be a problem with regional settings. I changed...

ok...let me try it..... EDIT: I get the maxdate and mindate fine, but table is blank..............very odd

Yes there is a field called value. The strange is that the static statement works fine And the dynamic is acting strange :( Ill try your code......... EDIT: With your code i got a Run-time error '3131' Syntax error in FROM clause