Search results

I am having a problem trying to find and use the correct formula to do the following. I have a sheet where some of the data can be repeated in multiple rows. I want to search all rows to find if a row contains the value of two seperate columns:- Master data is Fld 1 Fld 2 Fld 3 Fld 4 Fld 5...

I have an update statement in Access VBA as follows:- Dim strSQL As String strSQL = " UPDATE [siezure_event]" & _ " SET [Seizure_Class] = '" & gC1Desc & "'," & _ " WHERE ([Patient_UID] = '" & gName & "' AND [Siezure_Type]=1)" Debug.Print strSQL DoCmd.RunSQL strSQL My...

I have a problem using an ODBC Connection linking an Access Database to a remote ISP Database. Firstly, let me say the connection runs fine on a laptop running Vista but when I try on a laptop running Windows 7 I get an error. The ODBC Connector created in Access works OK on both machines, and...

Could anyone advise me on a curious problem. I have set up ODBC connection from my Access database to a remote MySQL database. This works fine and I have linked the tables OK. However, when I close Access and then reopen and try to view a form query, the ODBC Connector form appears and...

I am trying to test for a duplicate value entered on a form and have the following code:- If IsNull(DLookup([ID], [Patient_Detail], [Web_UID] & "='" & Me.Web_UID & "'")) Then Tester = True Else GoTo DupErr End If When I run the form I get the 2465 error and yet the values of ID, Web_UID...

Could anyone please help on the above error. I am trying to update a table using VBA aand am using the following code strSQL = " UPDATE [patient]" & _ " SET [Current_Med] = '" & Me.MyMed & "'," & _ " [SType1] = '" & Me.SType_1 & "'," & _ " [SType2] = '" & Me.SType2 &...

Could some please help with a syntax error in my VBA Sql code as follows:- strSQL = "UPDATE [patient] " _ & "SET [Current_Med] = '" & MyMed & "', _ & [SType1_Desc] = '" & Me.SType_1 & "', _ & [SType2_Desc] = '" & Me.SType2 & "', _ & [SType3_Desc] = '" &...

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

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

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

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

I have 6 tables in an sqlserver database. All except 1 table shows the Key as PK_tablename (in SQl Server manager). However, I have one table that shows the key as aaaatblename_PK. I have no idea why this is and what the consequence might be. I would greatle appreciate some advice on this.

I have developd 3 new php pages for my web which work perfectly on my local machine. I have now put these scripts onto my isp server after uploading the database. I have changed the connection string to reflect what i have on the remote machine, the string is as follows:- $link =...

Please excuse my ignorance but I dont know how to use a front end form on access adp to create a new record on the sqlserver. I have made a connection via odbc and can see the tables on access and view them. However when I create a new record on the form and use DoCmd to save the record it...

I have access 2010 and want to create an adp project application. The only template avaiablle is one for projects web database. However, if I choose the template or if I choose blank database I cannot save either as an .adp. The only option is not available Am I missing something in the...