Search results

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...

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? :-(

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...

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...

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...

I have a form with a unbound text field which when a user inserts text and then removes the focus from that field, the text gets inserted into a memo field. By using: Me.[NOTES] = Now() & " " & Environ("UserName") & " - " & Text27365 & vbCrLf & Me.[NOTES] However, I have noticed an issue...

I have a memo field which records the events that happen on a form. So for example when a user changes the assignment from one user to the next, a row is written to the memo field indicating date, time, windows logon and then a brief description Basically I end up with : 07/12/06 11:16:34...

Help !! - Can anyone help. I have had a quick look through the previous threads and can't seem to find anything that may help me. Has anyone got any ideas. I have a table which has many columns, one of these columns is called actions. On the design of the table, the action column is a Text...

Can anyone help.... I have a field on an Access db, this is a "Memo " type field which has many lines of text within it. I need to run a query on this to get the last line of text within this field. Aside from records where this memo field is filled in I also have records where the memo field...