Search results

Hi All Please can you tell me how to instert carriage return/new line in SQL Update query? thanks

Hi Your right that I do use dynamic fields. I have a form where users can use a combobox or text boxes to specify their date... the code is more complicated it is as followows: p.s. the one thing i dont understand is why it works on some computers but not on others...hmmm.. Private Sub...

Hi All I desperately need to resolve this issue which came out of the blue. I have a form where the users click a button that produces SQL. The SQL is passed to the report I have and the data is presented to the user in the report based on the SQL: This works on certain computers and returns...

Hi All I have a memo field on my form that is linked to my table. When I trye to view the contents of the memo (sometimes they can be lengthy comments someone has written), it doesnt display all the text/characters, its seems to cut off the majority of the comments written in it. How can I...

Hi All I was wondering if you guys can advise me or help me with this big problem I have which I cant get my head around and could cause huge problems for me. I have created a Access 2007 database for the Sales team at the company I am working for. The Sales team sell products and receive...

Many Thanks, That Helps. One final question - It all well to use the HTMLbody to create pre-defined templates to send i.e. Dear Mr Smith Thank you for contacting etc.... but.. what if the user needs to write their own message then how do i know when to use the carriage returns i.e...

Hi All I have created an email sender in Access and I need to add a signiture but in different colours and font etc.... which means I have to to use .HTMLBody But I dont know anything about HTML. Is there a way around adding a signiture in the colours i want (i.e. some sort of HTML...

Hi All I have a link Table to an Excel spreadsheet called 'tblLinkTable'. I want to refresh the specific table automatically in VBA. Ive got as far as: RunCommand acCmdLinkedTableManager this only opens the lnik table manager but i need it to automatically Update the...

Many Thanks!

Hi All Can someone tell me how I can Load the basic System Calculator (the one that comes with every windows operating system) via VBA, say at the click of the button? Thanks

Hi All Ive been trying for hours to close a word document i have. I open it from Access VBA with the following code Dim MSWord As New Word.Application Set MSWord = New Word.Application MSWord.Documents.Open FileName:="V:\Confirmation Of Instructions - Capital Visas"...

Hi All Ive been trying for hours to close a word document i have. I open it from Access VBA with the following code Dim MSWord As New Word.Application Set MSWord = New Word.Application MSWord.Documents.Open FileName:="V:\Confirmation Of Instructions - Capital Visas"...

Hi All Im trying to use the Autowizard to merge with Microsoft Word, but the wizard fails as my query references a form in my database i.e. the criteria in my query for one of my fields is Forms!frmForm1!tbxCustomer But access doesnt like this and wont allow me to merge with word... Is there...

Hi All Im trying to use the Autowizard to merge with Microsoft Word, but the wizard fails as my query references a form in my database i.e. the criteria in my query for one of my fields is Forms!frmForm1!tbxCustomer But access doesnt like this and wont allow me to merge with word... Is...

Many Thanks It Works Great!

Fantastic...your suggestion works...many thanks:)

Hi All I have a form called 'frmCustomer' and the datasource is a table called 'tblData'. The 'tblData' has a memo field and i have the memo field on my form, the memo field is called 'Notes'. I try to populate it with pre-defined text in the VBA editor by writing the code when a button is...

Hi All I have a tab strip on my form. I have created Page21_Click() On click event to bring back a message box for when ever i click on the second page on my tab strip(which is called Page21). this is the code Private Sub Page21_Click() MsgBox "Hello" End Sub But it doesnt execute...

Many Thanks Thats fantastic

Hi All I have been looking around but cant find the solution to this problem. I have customers providing their first and last names in the wrong case e.g. "boB dylAn" Sounds bizzare why people do it, but they do. I need my Access Query to convert them to the Proper Case.... e.g. "Bob...