Search results for query: *

Phil, That has sorted it and now works perfectly. Thank you very much!

I am trying to query a mysql database using PHP. I have a function in a seperate PHP (PHP File A) file which I call to connect to the database in PHP File B: PHP File A: =========== function RS_Connect() { // Database Connection Settings $RS_Server = "RSDB"; $RS_Settings =...

I think the Distinct counts were causing the problem. When you set CR to use Default Values, what is the default value for a date? Thanks again for your help, Mav3000 :)

Please ignore the above - I believe I've sorted the problem. It was to do with other Report Options and not those mentioned above.

Hi LB, When I enable the above two settings in Report Options, it seems to prevent me from filtering the Records using the Select Expert. I wish to filter the Reports to show all records where: IsNull({dtblDMC2163Options.D_Access_Obtained_A}) However, this formula in the Select Expert...

Hi LB, When I set the 'Convert Database NULL Values to Default' and 'Convert Other NULL Values to Default' to Null, the formula works! Does this have any negative effect in keeping these Report Options checked? Thanks for your help in solving this problem for me so quickly :)

Hi LB, The date fields are sometimes populated independently, sometimes together. e.g. some records have a Forecast only, others have Forecast and Actual. The formula works fine for records which have both a Forecast and an Actual (and the 'N/A' check works for these). It's only where there...

To explain further, this works: dim DateForecast as date DateForecast = DateValue({dtblDMC2163Options.D_MSV_F}) formula = DateForecast However this does not work: dim DateForecast as date dim DateActual as date DateActual = DateValue({dtblDMC2163Options.D_MSV_A}) DateForecast =...

Hi all, I've the following formula which compares two date fields: ' Evalulate Forecast & Actual Dates dim DateForecast as date dim DateActual as date dim Result as string ' Comparision DateActual = DateValue({dtblDMC2163Options.D_MSV_A}) DateForecast =...

Hi Hugh, I didn't see that article, despite Googling for the answer and reading several other pages. Thanks for link that explains the work around really well.

Hi All, I've a function that opens an Excel Object and worksheet, and then attempts to put a variable's content into a cell. When the variable (which is a String) has more than 256 characters in it, Excel refuses to insert it into the cell and gives a Error 1004 Application-defined or...

Sorry guys, it's an SQL database, connecting via ADO. I'm unsure of the exact field types as I can't access the DB directly - only via ADO and Excel. At the moment I have my function pulling the fields into a worksheet, then removing duplicates and sorting the remainder, then loading them into...

Thanks Skip, That is the approach I am trying at the moment. I'm putting the recordset onto a worksheet and using an advanced filter to filter the cells specifying unique records only. I'll then sort it, and set it as the row source on the combo box.

Hi All, I've an Excel application which queries a database table, and uses the results to populate a combo box. However, the table has lots of duplicate values in it - I'd like one of each to appear only, hence a SELECT DISTINCT requirement. I'd also like to sort them in ascending order, so an...

All sorted - the function I was calling on the KeyCode = 13 was invalid, however Excel was telling me that KeyCode itself was the problem.

Hi All, I have a form with a textbox which I monitor for the user pressing 'Enter' on their keyboard. My function looks like this: Private Sub tbxPassword_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer) ' Attempt login If Enter Is Pressed If KeyCode = 13 Then...

Thanks Skip, I'll investigate further and report back if needed. I've also changed a couple of bits based on your connection function, so will see how that goes too. Cheers, Mav3000

Thanks for the reply Skip, My OPEN Statement (including the initial bit left off from my post above, goes like this... Function OpenDatabase() sDatabasePath = "\backdoor.mdb" sConnection = "Provider=MSDASQL.1;" & _ "Password=password; " & _ "Persist Security Info=True; " & _...

Hi All, I query an SQL Database via VBA and wish to return results from the recordset into variables. The problem is that some of the fields, although populated on the Database, don't show values in VBA, or, they show values, but then mysteriously change to 'Null' when I try to do anything...

Thanks Andy that's exectly what I needed. I didn't name the fields - I'm the person that has to use them! so from now on I'll be using a lot of aliases. A new concept for me. Thanks again - and for such a quick reply. Mav3000 :)