Recent content by Jim54

  1. J

    How to Change the Colour of the Active Window

    I didn't apply any theme when I created the DB, but the wizards that I used may have. I'll see if I can backtrack the steps....
  2. J

    How to Change the Colour of the Active Window

    At the moment, the database (which records the history of some Lancaster squadrons 1939-45) has a screen that looks like this: You can see the active field is highlighted in a dark green colour; He would like the active field to be highlighted in a paler colour, like pale yellow, or not even...
  3. J

    How to Change the Colour of the Active Window

    Greetings, I wrote a simple Access database for a friend, using the tools and wizards that removed the need for any Visual Basic or cleverness on my part. Simple but safe! However, now he has asked if it is possible to change the colour of the active window. he wants to be able to stop it...
  4. J

    Programming a button on a Form

    It's a very good point you make, my only defence being that I wrote this DB originally back in the mid '90s, and was (badly) teaching myself Access at the time; best practices were abandoned in favour of anything that worked...I didn't expect the DB to still be operational this far on, and I'm...
  5. J

    Programming a button on a Form

    @Gasman ....Oh, good grief! You have nailed it. The field name in design view is "Complete", but I was referring to it as "Complete?" You will read this tomorrow, as you have gone to bed, but your parting action was to fix the problem! Sleep well, you deserve it. I changed the original query to...
  6. J

    Programming a button on a Form

    They are different, but I've used "Completed?" throughout...unles you have seen somewhere I haven't
  7. J

    Programming a button on a Form

    @Gasman : Yes, the field is called "Completed?", as you can see from the table headings : But now I'm concerned that I don't know the difference between field name and caption. There is a chance that I'm wrong (always a chance!) but the field "Completed" works in other reports, etc, so I hope...
  8. J

    Programming a button on a Form

    @theDBguy : I did as you suggested, and the result looked like the screenshot below, so I gave it "0" for "Completed?" and got the output below, which looks reasonable, showing all 'Frame numbers with a "Completed?" value of 0. However, I had to tell the query the status of "Completed?", it...
  9. J

    Programming a button on a Form

    OK, something sensible here...I did as @Gasman suggested, and this is what I got back: So although there is a "Completed?" field in the "Airframe" table, the query apparently can't find it, despite having the right "Airframe Number", so asks for the value. As far as I can make out, the...
  10. J

    Programming a button on a Form

    OK, I did as suggested in post #17 and this is what I got: Something odd going on here: The statement starts "UPDATE", but the error is that the statement doesn't start with "UPDATE"....Huh??? The syntax is apparently right, as I don't get a "compile error".... @Gasman, in answer to your...
  11. J

    Programming a button on a Form

    OK, my thanks for the flurry of replies and help. I shall try to reply fully to each of you: @Gasman I did as you suggested, and the code nd the "Immediate" window is shown below: so given that the airframe selection was actually for DV155, that looks like its at least got that bit right...
  12. J

    Programming a button on a Form

    I tried the Cntl G as suggested an all I got was an alarm chime. So I then removed the execute line so the button code looked like this: Private Sub Select_Click() On Error GoTo Err_Select_Click Dim strSQL As String strSQL = "UPDATE Aircraft SET [Completed?]= Not [Completed?] WHERE...
  13. J

    Programming a button on a Form

    I chaged the code to what you suggested, but the output on clicking the button was not changed, and there was no additional output. This is the form window before clicking the button: This is the full code behind the "Change Status" button: and this is what appears after clicking the...
  14. J

    Programming a button on a Form

    Hi Gasman, Thanks for the quick response. I did as you suggested, but I still just got the "Too few Parameters. Expected 1" I'll try a few more things, but any idea why this might be happening? The table ("Aircraft)"that the button is trying to act on has the following fields: Thanks Jim
  15. J

    Programming a button on a Form

    Guys, I realise this is where you are completely justified in telling me to F.O.A.D., but I'm trying to pick up Access after not having touched it in over 10 years, and never really being too clever with code...can you explain what you mean in words of one syllable or less, so that my addled old...
Top Bottom