Recent content by JEPEDEWE

Can't you unlock it by clicking on te shift button while you click "enter" with the cursor on the files name? Strange

Oops sorry Go to "hoofdmenu" Pick a name "Fiche" opens Click "File" an this should add the (bold, underlined) current date on top of the TxtOpmerkingen memofield Greetz

Here is the file.. Hope you can help. Thanks a lot JP Belgium, Flanders

I changed the format of the memofield now I get a syntax error in the line: Me.TxtOpmerkingen = <div><strong><u> date </u></strong></div> & vbCrLf & TxtOpmerkingen Sorry I don't understand the situation fully (and that I cross-posted my question)

Where do I find this Rich Text setting (I have a ducth version of access so... ) Which tab should I choose Thanks for your reply

Colin, I miss the | vbCRlF in your code and I still get the compilation error where "= <" after Me.TxtOpmerkingen is highlighted saying "expected: expression" (this is what i translate from Dutch to English)

Me.TxtOpmerkingen = <div><strong><u> date </u></strong></div> & vbCrLf & TxtOpmerkingen gives a compilation error thanks for your kind help

Hello, I have a record with a memofield. On this record I created a pushbutton with following code: Me.TxtOpmerkingen = vbCrLf & TxtOpmerkingen Me.TxtOpmerkingen = Date & vbCrLf & TxtOpmerkingen TXOpmerkingen is a memo-field With this code I add the current date on top of the...

Hi, To print invoices I have to use official documents Alle data should be printed on correct locations... so far no problem But The invoice-pages are 30,5 cm long and12,7cm wide I need to change the pageformat to these values Now it's A4, not wide enough and I can not find where to change the...

Perfect.... thansk a lot Tried the Brian-solution... no errormessage and result just like I wanted But Thank you all!!! JP, Belgium

Hi, I have a table with a date field I want a query that displays all records from last monday till now So I wrote: >Date - Weekday(Date; vbMonday) + 1 this returns an errormassage saying: "The expression you entered has an invalid .(dot) or ! operator or invalid paramaters" Cursor stood on...

True... not so far from Belgium Been here before??? I did what you suggested Saved the SQL in a query Created a form with the query as rowsource now I have data from 2004 until now I see in fields named 2004.... What will happen when I, for example, delete data from 2004 Then the from will be...

Just wondering Now you make a total per month.. setting this value at the beginning of the table. Can you also make a total per year and place this value at the bottomline? Many thanks (Denmark... I heard it's a very nice country....true??)

Almost perfect What I get now is what I send in a JPG file The month remains "jan"... doens't change Also When I run the pivot I see columns and rows like I send you, but, how to place this on a form I created one and put the pivot in the recordsource... alas no way to "build" a nice form...

OK, changed it but "data type mismatch" error remains I alt Taly confused ;)