Recent content by kleaves

Populating a cell depending on the filter in another w/sheet Thanks, Used Vlookup and it is exactly what I wanted Thanks again

Title should say: Populating a cell in a column from another sheet I have a 2 column spreadsheet Column 1 – Holds the correct status Column 2 – Holds the old status I have a filter set up on this so that when I select the old status, it shows me what the correct status should be. I now have...

Help I'm having a nightmare with this. I have set the field (AuthorisedBy) on the form to Locked = True within the properties. Checked this worked and although a user can see the drop down, they cannot select another value. (This is fine) The next step is to only allow users whose windows...

Keith Thanks, for the quick response - thats exactly what I wanted. Kleaves

HI, I have a number of queris within my access database and I wish to export the list of queries. Is there any way in which I can do this? Or Am I going to have to retype the list in word? :-(

Thanks, I realised as I clicked the button to post the reply, done the search and have found a thread in relation to this.

I have a form which I want to disable the close button. On the properties of the form I set Close Button option to 'NO'. When I open the form the form close button is disable, but as soon as I maximse this screen, the close button becomes enabled again. Any Ideas as to why this is happening...

Thanks Rural Guy Will have a play around with this and see where I get to !! Thanks again

I have a table of Users, where has two columns, Col1 = Username, col2=Auth Code. So I could say something Like: If users.[auth code] = 'M' then UnlockIt Else LockIt Is this correct?

I have a field within a form, which I want all the users of the database to see, but I only want it to be editable if your windows logon name is one of the following: kleaves jbloggs Jsmith I know I can use the environ variable - environ ("username") and I think I should set this code under...

OK, Thanks guys, will give it a try and see what i come out with. Thanks for the help Kleaves

Col Unfortunately, I cannot make this field mandatory as its not always necessary to be filled in. Would this still work if the deadline date was blank? Also in some cases, I would need to know when the deadline is passed by how many days - What would be nice is if it said something like...

HI, this should be relatively simple, but for some reason I cannot figure it out. I have a field titled "DEADLINE" - a user inputs a date in this field (the datatype for this filed id date/time) What I want to do is, on the form create a text box which takes the deadline date - todays date to...

RG Thanks all code now moved to After Update and it works like a dream. T Thanks for that. Its very much appreciated Kleaves

So are you saying that on the TEXTBOX I can still have the OnLostFocus event, which updates the NOTES memo field. then also on the Textbox properties on AfterUpdate set the Event Procedure: Me.Text27365 = "" I tried that and now what happens is that, I open the form, the text field for the...