Recent content by Brian Martin

Thankyou!!! Fantastic!! I've spent all morning trying to work that out. You've made my day and helped set me up for a good weekend. Thankyou!!

I want the full description text box to pickup the value from cboPress. I don't want the user to have to click on it though. I have tried using the selected property but couldn't quite get it to work. How can i achieve my aim? I have attached my example

Getting there It is a memo. I have partly sorted the problem. i had set the format of the memo field as > to make all the text capitals. i deleted that and now it lets me input more than 255. But when I run an append query I'm sometimes getting gobbldeegook added on to the end.

No luck tried your code and it didn't work either. I'm stumped. the reason I'm trying to do this instead of a regular query is because I have a memo field that just wont allow anything greater than 255 characters and i read in this forum that some people solved this problem by doing their...

Still stuck Both fields are text fields. i now have the following and it still doesn't work. SQLstring = "UPDATE [Product List] SET [Full Description] =" & [Forms]![frmChoose]![subChoose].[Form].Controls![FD] & _ " WHERE [Part Number] = " &...

Nothing is being updated What is wrong with this code?: SQLstring = "UPDATE [Product List] SET [Full Description] =" & [Forms]![frmChoose]![subChoose].[Form].Controls![FD] & "WHERE [Part Number] =" & [Forms]![frmChoose]![subChoose].[Form].Controls![PN] & ";"

Thankyou for all your suggestions but I have fixed the problem although I don't know why it was a problem. The queries activated by clicking the button used data from two textboxes on the form. I didn't need the user to see these text boxes so I shrunk them right down and hid them behind...

I have created a button on one of the forms in my database that works perfectly on my computer under my admin login. It also works perfectly on my computer under other users logins. But if I try on any other computer on the network even with my admin login it doesn't work. Each computer has...

Yeah sorry! Was in a bit of a panic!

I want to restore my secure databse from yesterdays back up tape. Can I simply overwrite the mdb file with yesterdays keeping the same name. Will the secured mdw file still be able to open it. Or do I have to replace other files too.

I've just accidentally deleted records from a table in my database because I didn'r realise the tables were linked. How can I restore this data. Aaaaaargh

no it's definitely only taking the 255 characters.

I have a field in my table which is a memo type field. However it only holds 255 characters. Why is this? It may have been a text field before I changed it to a memo I cant quite remember. Would this have anything to do with it?

Does anyone know of any web sites where you can download good looking form templates??

I have a secured database in which I am the administrator and I have all necessary permissions. But when I try to link to tables in this database from another secure database it says I don't have the necessary permissions. How can this be??