Recent content by cyd44

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)