Search results

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.

Hi Rich, Thats exactly what I did in order to get the correct syntax for the where clause. I have included the were clause in every select statement in my union query. As I said in my first post, the query runs and returns data fine, I only get the error message when I create a report from...

Hi Bob, As the query is a UNION ALL query, taking the form: SELECT * FROM Table1 WHERE etc UNION ALL SELECT * FROM Table2 WHERE etc UNION ALL SELECT...... Access 2007 will not let me use the parameters function. The parameters button on the toolbar is greyed out. It will also not let me...

Hi all, I have a report based on a UNION ALL query. One of the criteria in the query is as follows: (tblClosure.close_date>=[Date From (dd/mm/yyyy)] And tblClosure.close_date<=[Date To (dd/mm/yyyy)]) This query works fine if I run it in its own right, the user is pormpted to enter a date...

Hi, Tried this and its still prompting me for the parameter, its really baffling me why its not working!

Nah it's still prompting me for the parameter ????