Recent content by p595659

Hi FireStrike, that method wouldn't work, the SQL is taking 9 parameters from the form and it stops before the variables are swapped in. Just to summerize so far: MyQry.Parameters("PAdviser_ID") = [Forms]![frm_MainMenu]![CurrentReport] MyQry.Parameters("PAdviser_ID") - this part is saying...

Hi Steevie, thanks for your reply. I've changed the order of the code as you have suggusted, and now I'm getting a different error: Run-time error '3265' Item not found in this collection I've attached my stored procedure also in case its anything in there. Here's my updated code: Dim MyDb...

Hi Guys, I'm trying to make a pass through query which connects to a postgresql server. However, When I try running it by clicking on a button, I get: "Run-time error '3306': Query must have at least one destination field I have tried debugging it and all the values in the parameters are being...

Hi, I'm trying to create a pass through query after looking at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/adocreateq.asp. I'm using Access 2000 trying to connect to a backend to retrieve the data. Here's my code: Sub CreatePassThroughQry(strDBPath As String, _...

Hi, I have a combo box, which the first and last name of an employee is combined using trim. Does anybody know of a way to seperate both fields as these would be used an a query so I would need them seen as 2 fields otherwise there won't be any matches. Cheers, Ben

Hi, I have a postgresql database setup (tables have been imported and relationships setup as well). I would like to link the access database frontend to the postgreSQL backend. Does anyone know how to do this? Cheers, Ben

my high school best friend Alexi was autistic(sp?), and we got each other through high school when we had our problems. I still keep in contact with him online because he now travels alot since he is a golf pro. My current best friend is Gary, who was in the same course as me in my first year...

what about Tom Tom? My housemate has a PDA and he uses that. It shows where you are on the road and updates very quick. :)

Hi, I'm making a form where the contents of a field is determined on the contents of another field in another form. I thought an IIF function would work, but when I tried it the contents says #NAME. I put it in the control source...

Ops, forgot to include qryPipelineAndCommission in the file. Here is the SQL view of the query. SELECT Trim([tblEmployee.Employee_First_Name] & " " & [tblEmployee.Employee_Surname]) AS Advisor, tblNewBusiness.NewBusiness_Date_Issued AS [Date Issued], Trim([Client_First_Name] & " " &...

Alright, after some modification of actual data I'm allowing people to have a look at it to try and work out the query solution. The query in question is qryPipelineAndCommission. Apologies for the file size, but it was alot bigger. It was alot larger with 5K records. Currently the file is 6.3...

well I ain't heard anything about that. MCR is the covering band for the Muse concert in Edinborugh on 24th August which is where I'll be. :)

Now there are no results when the query is run. I would send you the actual database Ken, but the problem is that the data stored is for actual customers so would have a problem with data protection. Ben

I tried the nz function but when I run the query all the advisors are getting listed, not just one of them. Here's my code: Like (nz([forms]![frm_ReportSelect]![Advisor_ID],"*")) Any ideas? Cheers, Ben

but the 2 controls where I get the criteria from are 2 combo boxes. :(