Recent content by potatohead

Hi there I've played around and managed to get it to work. What I've done instead is put the field "Confirm" into the form, and then hide it. When the 'update' button is clicked, then this is also set to -1. Bit of an unprofessional approach - but works fine! Thanks for the offer of help...

Hi there - thanks for that! I can now see the field after the Me. command. However, the code still isn't working - I get an error saying: "Run time error: 2467. The expression you entered refers to an object that is closed or doesn't exist" The table the form is dependent on is selected in...

Hi all I've followed the instructions on this post: http://www.access-programmers.co.uk/forums/showthread.php?t=85898&highlight=updating+field But, unfortunately doesn't seem to be working for me. I added the equivalant field to 'Hired' after I had previously made tables etc and started...

Hi Pat I don't have anything in the control sources of the text boxes I'm refering to on the form. Do I need anything in them? Cheers

It's alright - I've got it sorted! Cheers!!

Hi all I'm currently working through developing my first database. Basically, what I would like is for a query to run from a command button. The query should look at a field in a table (a yes/no field) and report back the ones that have been filled in. I know how to run the query from the...

Hi All I currently have a log on form that checks a users password against passwords in a table, before opening a form at that users record. Ie, If Fred Bloggs logged in with password FRED, the next form would open at Fred Bloggs' record. I've used the following code: Private Sub...

Hi bonecrusher Could you please post the answer on this board, as I am looking for this solution too. Cheers

Thanks for that very quick reply!!! Just one question, however. If the 'ID' is entered in a previous form (ie the log on form, in text56) how do I incorporate this into opening another form at that record? Ie, the log on screen requires you to put in your username and password. I would like...

Hi all Im currently designing one of my first databases! I've initiated a log on procedure, with a password. A user enters their ID and password. Once the correct password is entered, the next form is then loaded up, to which they make some choices. My problem is that I have lots of users...