Search results

That is very clear, I thought the double negative might be the case. Many many thanks for your help Brian:D

Hi Brian Your a genius mate? This has worked fine. Just a question, why do we use a negative in that when True we have N and False Y? It works well but the logic seems strange?

I have beeing trying both Lookup and VLookup for this and have it partially working. Strange though that it will find 1 key but not another and will not not validate the Chooser field for all possibilities. Have attached sheet to show function entered in col L

Hi Brian Sorry for the confusion. The data is on 1 sheet and I am simply trying to find whether a chosen piece of data is contained within the main listing each unique key. I have a cut/past sheet containing some data which probaly better explains. On this sheet the main data is in the range...

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

Thanks, had not noticed the comma

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

Thanks Rural I changed the square brackets to "" and it worked.......Thanks for that

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

Thanks for response. I found the problem. I had cut and pasted wrong coding

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

Manged to get it working by updating 1 field at a time. It is on 1 line and would appreciate advice on how to make it multiple lines using the & _. Wotking Code is strSQL = "UPDATE [patient] " & _ "SET [Current_Med] = '" & MyMed & "', [SType1_Desc] = '" & Me.SType_1 & "', [SType2_Desc]...

Thanks Rat1 I agree about the 1 line coding as I always get confused trying to code over multiple lines. It does look cleaner however and more readable. I have cut and pasted your suggestion but now get and error on the Docmd.RunSQL(strSQL)

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 can live with it as it is Bob, I was just interested as to why it was occuring. I only need the data to do my calculations for the graphs. In hindsight I would have been better putting the functions on a different tab, but I was using quite complex formulas and didnt want the added problen of...

Hi Bob, Have carried out the recommended fixes and the function now works fine. I must admit, I would never have thought of deleting the Import Tab on the spreadsheet. I new it was some problem with the export but, given that the Import tab was cleared before export I would not have thaought it...

Hi Bob, Many thanks for looking at this. Very strange isnt it. The reason I have an Import Tab on the workbook is to have a page to export the form to. I then transfer the data to a Table Data tab where I have the formulas for counting etc. I then clear the import tab so that the export can...

Bob, As an aid to looking. Your function is located in the Functions Module and it is called by the Button on the frmseizure_event Form. The spreadsheet is included but you will need to change the path in the event sub. From the Access Menu choose the show siezures and pick Camille Hindle from...