Search results

Thanks a lot Bob. The database contains fictitious data as this is purely an academic project I have been set at Uni. I will await your reply eagerly.

Ok Bob I have attached a copy of the database (cut down version) and a copy of the spreadsheet. I appreaciate you looking at this

Thanks for this but I am unsure of how to go about this. I need to show the form results to the user (results are based upon a seleted combo box and fiters accordingly via a query using Forms!Form!ComboBox). If I am to use the output to syntax how do I need to open the query first? and how can...

I have a form which contains filtered information from a query. My form shows 157 records. I have placed a button on the form which calls a function to export the form data to a macro enabled workbook. The export takes place and poulates the specified worksheet with 157 records. However, the...

I have a function to export the results of a query into am XL spreadsheet but am getting strange results. The export appears to take each row in the recordset (up to row 148) and then omits the remaining 10 rows? Instead, it duplicates the first few rows. I end up with the correct number of...

I am a complete novice to php and have a select query wich will return a single row. I want to assign the results of 3 fields within this row to 3 $_SESSION varaiables so that they can be used by another page. The query code I have at the moment is:- $qry = "SELECT SType1_Desc , SType2_Desc...

Excel 2010. Am getting some very strange results from this and also when using macros but this is another matter I will deal with once I have solved this particular problem

I am using SUMPRODUCT Function and have a strange error which suggests I am pointing to an empty cell (the empty cell pointed to does actually contain data though). I am using the following function:- =SUMPRODUCT(--$C$1:$C$500>=X46)--($C$1:$C$500<=Y46)--($A$1:$A$500=$R$61) Where...

Sorry Bob, Yes I do mean Excel!

Hi, I have a worksheet with a column holding types for each record. I want to get a list of unique values from this column and am using the formula =INDEX($A$1:$A$478,MATCH(0,COUNTIF($S$1:S1,$A$1:$A$478),0)) I am getting no error message from the formula but the cell just contains #N/A...

Thanks to both of you. Bob, I put in the Activate Code as suggested and it worked fine. Without the Range constuct Access was putting Feld headings on different worksheets (dont know why but your code solved this). For clarity should anyone want to use this going forward I enclose the full...

Hi there, Thats an interesting point. Being a newbie, I am just using an example function recomended and the range selection was included? I I take out the range, will it atomatically copy and paste at A1 cell?

Hi Bob, Am back awake now (but still frustrated). I have cut and paste an example from the link you gave me and it worked the first time I used it but am now getting a 1004 error (Select Method of Range Class Failed ). Here is the full code used for the function Public Function...

Have reached the point of getting very tired and will make more stupid mistakes if I carry on tonight. Just to let you know, the form I am using gets the records from a table based upon a query that selects based upon a form variable (IE Forms!Form!Var). I am thinging that this might be the...

Thanks Again, I have trued your posted function above and am calling this from an eveny sub on a form buttom. Unfortunitely I am still gett the 3061 error too few parameters expected 1. I have cut and pasted the Public Function SendTQ2ExcelSheet(strTQName As String, strSheetName As String)...

HI Bob, The string value is showing the name of the access qry IE qryChoose_Patient_Diary. I can also open the qry itself and does show 147 rows of data? I will take another look to be sure but I am confident it is right. If I find it is wrong I will come straight back

I am trying to copy the data from an access query into excel and am using DAO.Recordset to capture the data but am getting a 3061 error. I am a newbie to recordsets and am unsure waht the problem is. I am calling a fuction called exportdata and the first lines of this are:- Private Function...

I am trying to update a password field in a MySql Databse from a php web page. My code is as follows:- $qry = "UPDATE patient SET password= '".md5($_POST['password'])."'" WHERE UID = ".$MyName.""; $result = @mysql_query($qry); I am getting a parse error message which points to the $qry line...

Hi Again, I really struggle with the syntax using SQL in VBA and need help yet again. I simply wish to insert unbound form variables into an SQL Server table and have the following code:- MyName = Me.Cust_Name (this is text) MyAdd = Me.Address (this is text) MyNum = Me.Contact_Number...

I have a strange problem with a parameter driven report. I have a form with 2 combo boxes (unbound) to select a report using the combo box values as a parameter. I also have a button to run the report without any parameter (to show all records). The code used to run the report on combo box...