Recent content by foxy

That's perfect, exactly what I needed. Thanks very much!

Thanks very much for that, but sorry, I should have explained more, this is an Unbound text box. I also don't want everything to be in Lower case, I want it to remain as the user types it. How do I take the automatic proper case of of an unbound text box? Which property is it? Cheers, Foxy

Hi, I have a text box on a form. When anyone types into it, it changes what they have typed into proper case. Is there any way I can stop this? The data that they are entering does not lend itself to proper case. There is no vba attached to the text box so the text box is definitely doing this...

Hi, I have a form (continuous) that shows several records, each in an individual detail row. Depending on a value in each of the detail rows, I want to display a specific label and hide others. This needs to evaluate for each separate detail row. This is the code I have. Private Sub...

Get in! That works. Thanks very much. Just needed a fresh set of eyes on it. Cheers, Foxy

Hi All, I am trying to implement a user login by using a dlookup against a table called tblUser. The concept is that if the password entered into the text box matches the password in the table WHERE the username matches the username in the table and the active yes/no field is true then it...

Hi everyone. I have a number field in my table that contains numbers 1, 2, 3, 4, and also blanks. I am writing a query from the table as I dont want to see the rows that have a value of '1' in that field. When I write the following selection criteria... WHERE [table].[field] <> 1 The...

The exact error message is... Run-time error '3075': Syntax error (missing operator) in query expression 'tblClosure.summ_par_score_a_then IS NOT NULL OR tblClosure.summ_par_score_b_then IS NOT NULL OR tblClosure.summ_par_score_c_then IS NOT NULL OR tblClosure.summ_par_score_d_then IS NOT...

I've got rid of all the line continuations now and am still getting the syntax error. Is there an error in the SQL that I'm missing?... Dim MySQL As String MySQL = "" MySQL = MySQL & "INSERT INTO tblTemp_CloseSummScores_Parent (caf_id, close_date, question, improvement) " MySQL = MySQL &...

Oh ok, is it a case of having to remove all the line continuations? I just thought the aim was to get below the limit... Apologies. I'll get rid of them all and try again.

Right... I've now got my query as below, to avoid using too many line continuations in one go. I'm still getting the runtime error message. The error message seems to say that the error is something around the WHERE clause, but I cant see anything wrong with it... Dim MySQL As String...

James - Yea I still get the same error if I use that approach. namilam - I didnt realise there was a limit on line continuations, do you know what it is? Foxy

Hi James, Yea that is what is supposed to be happening. either side of the "-" are two different fields. I am subtracting one from the other and the result is going into the 'improvement' field. The query seems to work if I take the bottom half off, but errors when I make it a UNION ALL...

Hi All, I am trying to use the UNION ALL syntax in a vba DoCmd.RunSQL function. The following syntax works fine if I use it in a query design window, but I need the code to be in vba. When I run the following code I get an error that says "Syntax error (missing operator) in query...

I have tried exactly that approach as well. I enter the dates on the form, click a run command button. If I code the command button to open the query its fine, but if I create a report from the query and code the button to open the report, I then get the db engine error message.