Search results

So now Im really confused I open your database. Paste my Times Roman text into a new Rich Text Field and it STAYS as Times new Roman and the Rich text code changes to: <div><font face="Times New Roman" size=3 color=black>This is the the pasted Times Roman Text<strong> That is sometimes in...

Could you post your new database please Isladogs

Hi Minty Yes I guess that's what i'm trying to do. Regardless of the format of my copied it should format to Arial 7 when triggered Create a table with Notes (Rich Text) Create a form Add notes field Open Form Paste html times roman 10 into it Close Form Open form Make the Times roman format...

I can't explain it any simpler !!! I open a Form On that for is a field called notes (whose text format is set to Rich Text) I paste into this field some copied Times New Roman pt 10 text When I either lose focus or close the form: The format of the text changes to Arial pt7 When I reopen...

OK I would like to open my form paste my text into my notes field and for it to format to a specified format. Can somebody help me with this please. I'm totally lost.

I think that we are at cross purposes here. The user opens the form and pastes data into the notes field. This could have all manner of formatting but on closing the form (or losing focus on the notes field) I want to format what has been pasted to a specific font and specific size. I tried...

Thanks Isladogs Great tool !! Many thanks I now have my Rich text format namely: <div><font face=Arial size=1>Text with border</font></div> How do I apply this within my VB code?

My Sub form contains a notes section that is invariably used by the user by copy/pasting data from rich text environments into it. What I am looking to do is to format the font name and size. I have tried this however I'm not getting any success. Private Sub notes_LostFocus() Me.notes.FontSize...

Fixed in !! Thanks for you time guys. It pointed me in the right direction. My solution Dim FilterStatus As String Dim FilterCustomer As String FilterStatus = "Status = '...awaiting decision'" FilterCustomer= "Customer = [Forms]![frmSettings]![UserName]" Me.Filter = Me.Filter = FilterStatus &...

Hi Minty I'm only getting the UserName results isladogs...not bothered as long as it works ! lol

Could someone help me to apply two filter into one please? I have tried several iterations but to no avail. Both work independently. DoCmd.ApplyFilter , "Status = '...awaiting decision'" DoCmd.ApplyFilter , "customer = [Forms]![frmSettings]![UserName]" I tried this which doesn't create an...

Gasman I love you I had realised that I had ommitted the criteria on which to cpnnect the two fields however I would have struggled with the syntax regardless. I'm indebted to you.

Having selected my client and populated their unique Identifier (IOID) I ask if they have a partner via a message box? Preceeding code has established the partners unique ID (called IOIDJ) I'm trying to populate an unbound field on the parent form with the full_name of the client's partner...

Now would I leave you ? lol Thanks guys

Hi everybody Can anybody recommend a SQL forum. I'm moving my back end into SQL Server 2012 and could do with a support forum. Just think....I won't be bugging you lot anymore !! lol Cheers

That'll be thanks to me then!

Save a filter It might be useful to save a filter if you will be using it again. The filter settings that are in effect at the time when you close a table, query, form, or report are automatically saved along with the object, and they are available for reapplying. However, by default, the filter...

What I don't know is what you are talking about? I know how to create a table I know how to create a query I know how to create and run updates I know how to use VBA to a degree What I don't know is how to answer the question that I put to you! I simply want to be able to either a) retain...

Anyway !!! I have no idea what you are talking about ? Create a table ? to store the filter. Could you perhaps point me in the right direction to study what your'e on about. Thanks for you time so far

Thanks DBguy. How do I save the filter?