Search results

If Me.SelectProg.Column(8) <> Me.SelectAW.ItemData(0) THEN Try that where it's bolded

In the afterupdate event of the second combobox imo

Hi Nam, hope you're well. He is insistant. I might do this - clear the excel workbook each run and link it to the master spreadsheet.

Hi guys, I have a form. On this form I generate some table contects etc. The user insists they want to be able to open the tables to copy the contents to excel. Anyway, is there a way to just click a button on the form and copy the contents of the table to clipboadr so you can paste it into...

:bumponetime

Hi guys, I know it's a Sunday and all :p A mate of mine has recently been building a website. For this site he plans to run a prediction tournament for his subscribers. I'd like to think I was reasonably well versed on normalisation but this is pretty complicated from what I can gather. We...

That is sooooooo sick. Literally, exactly exactly what I was trying to do. And it's so quick. Thanks Mailman, I owe you (another!) one. :p

Ah we seem to be working :) Just a question if I may. Will the initial pt query bring everything back locally first or will the date filter set in the VBA filter the data on the Oracle server? I ask because we removed the dates from our pt query so they can be set in the code.

Ya the SQL I posted in post #26 works fine. It breaks on the to_date stating: "Undefined function <name> in expression. (Error 3085) You entered an SQL expression that includes a Function procedure name that cannot be recognized. Make sure the function exists, that it can be used in SQL...

Morning Mailman :) I've tried the below method and got an error in the FROM clause: pt query: SELECT SETTLEMENT_DATE, CONSUMPTION01 AS P1, CONSUMPTION02 AS P2 FROM FSD_SETTLEMENT_DETAILS Manipulation of INSERT INTO query: CurrentDb.Execute "INSERT INTO tblFinalVolumes SELECT *...

Ah that makes sense. I assume I need to remove the date fields from my pass through query then build the statement in a similar fashion to before...

Hi Mailman, I feel like an idiot but... I worked through your steps...but it didn't return any records and thus wouldn't append to the table. Using this: "CurrentDb.Execute "INSERT INTO tblFinalVolumes SELECT * FROM rsFinalVolumes"" works fine, but I'm still not sure on how to pass a...

Hi Mailman, I just have this at the minute: "CurrentDb.Execute "INSERT INTO tblInitialVolumes SELECT * FROM rsFinalVolumes"" When I went to change the PT query to an append query it cleared the entire SQL/Design viwe grid of my query. Can it be built from there or not? Still not sure...

Thanks guys. This: "CurrentDb.Execute "INSERT INTO tblInitialVolumes SELECT * FROM rsFinalVolumes" works fine but only with the prefixed dates. So I'd need to pass parameters from a form to this statement or use the QueryDefs doofer. Essentially I'm pulling stuff using a PT query in a big...

So this will pass the SQL in my working passthrough query in Access to the strSQL, right? "DoCmd.OpenQuery "rsFinalVolumes"" works but it just opens the query in query view.

Ha they're not real, no. I'm not that daft :) LP, "Presumably you've already done this - in a passthrough itself perhaps?" Yes, that's right. I built in Access and wanted to allow variables to be inserted from a form so I thought it's be easy enough to build it in VBA passing date ranges...

Hi Nam, I think I've set a connection to the relevant database. Below is the entire code. This is the first time I've ever done something like this :/ Thanks for helping. Private Sub cmdImportVolumes_Click() Dim adoConnectRDPS As ADODB.Connection Dim dtDateFrom As Date Dim dtDateTo As...

Hi Mailman. Solid advice :) will def remember that in the future. It's now saying that it can't find the input table FSD_SETTLEMENT_DETAILS and breaks on the RunSQL. INSERT INTO tblInitialVolumes(SETTLEMENT_DATE, CONSUMPTION01, CONSUMPTION02)SELECT FSD_SETTLEMENT_DETAILS.SETTLEMENT_DATE...

Hi guys, I'm looking to run this pass through query and update a table with the values. strSQL = "INSERT INTO tblInitialVolumes(SETTLEMENT_DATE, CONSUMPTION01, CONSUMPTION02)" strSQL = strSQL & "SELECT FSD_SETTLEMENT_DETAILS.SETTLEMENT_DATE, FSD_SETTLEMENT_DETAILS.CONSUMPTION01...

Didn't this get solved in an epic thread the other week? Is this the same OP?