Search results

How can I solve this strange problem of half printing (viewing) the reports.

Strange thing: but get something like attachement when I try to print (preview) some (not all) reports; :confused:

I think you can put your text in RTF (rich text format) and rewrite your string (the one you would underline) for example as follows: sMessageBody = "Email <u> body </u> Text"

As it depends on me, I would choose for the second solution!

Explain your application more in detail. What do you mean by run and produce a run of validations. What do you want to put on the report (structure).

Problem solved. With this command I created a linked table (Back office). DoCmd.CopyObject , "tblLijstProducten_Kopie_" & Now(), acTable, "tblLijstProducten" I change this command into strKopieTabel = "SELECT tblLijstProducten.* INTO tblLijstenProducten_Kopie FROM tblLijstProducten;" and...

In the database I have made which I want to post, the procedure runs without any problem (see enclosed file). But in my application it doesn't run properly. Why? I can't figure out why!

It's sad, but this also doesn't work! :confused:

Why indexing a memofield or set a relationele on it. Then I think there's a problem with the normalization. Use it as a pseudo word processor: a field to put in some text more than 250 characters. But remember: Access is no word processor!

I work with Access 2013 and text fields are divided in two kind of text fields: a short and a long text field. The long text field is the replacement of the memo field. I use this kind of field in several forms/reports without any problem. Why else would this kind of data type developed in Access.

It doesn't work with DoEvents? Can anyone say me what's the problem? :confused:

I first want to copy a table and then to amend it. This is the code. DoCmd.CopyObject , "tblLijstProducten_Kopie_" & Now(), acTable, "tblLijstProducten" sqlUpdate = "UPDATE tblLijstProducten SET tblLijstProducten.ProductActief = False;" DoCmd.RunSQL sqlUpdate...

Hello, I am an experienced Access programmer for the government of Antwerp, Belgium. Hope to get a lot of answers to my sometimes to others - simples - questions. Greets