Recent content by mihabaki

Thank you for the reply, but I'm not sure I understand how it helps to solve my problem/error?? Miha

Hello! I've been using Lebans report to PDF on Windows XP PRO for several years without any problems (Access 2003). I recently moved to Windows 7 PRO 64bit (and still using Access 2003). I get to the following error when trying to convert to PDF: "Run-time error '2282': The format in which...

Hi! I have a module for sending e-mail using CDO. It looks something like this: Dim iCfg As Object Dim iMsg As Object Set iCfg = CreateObject("CDO.Configuration") Set iMsg = CreateObject("CDO.Message") With iCfg.Fields...

does you code execute at all??? did you add the module to your command button on the form (open form in design view and check the button's properties) and also is your button's name "cmdButton" ?? miha

Post some info on the table/s / query (especially the data contained) from which you're generating the report m

do you have any (long) text fields on your MSSQL backend? If so, try changing to nvarchar() also any numeric field types on your MSSQL that are "bigint" or "int(>11)" could cause your linked tables to Access to not show correctly m

OK, here it goes (I have to say this was a bit hard to prepare, because I realy don't understand your need for such a query) - also note that my original solution was not good. Put this code behind the "on click" event of a command button on a form of your choice (it will create a new query and...

try using instead of character " ' " character " ` "

I will post you a detailed example tomorrow morning (CET)

instead of ['users comments'] try 'users comments'

Base your report on a new table. The table should be empty and have the same structure as your source table/query. Before your report open you should run VBA code that includes: - create a recordset (SET rs = currendb.openrecordset("SELECT * FROM ... ;")) that selects all the rows from your...

Empty the imported table (it has to be "local" table in Access) and change the type of the ("problematic") field to text. Then select all the rows in your Excel source table and copy/paste to the table in Access. M

It's not a problem to add all the images in the attachment, but I do not know how to reference them (locally) in html code <image src...> ??? Miha

Hello! I use CDO (schemas.microsoft.com/cdo) to send bulk e-mail from Access 2003. E-mail is in html format and I'm having problem with embedding images: ".... <v:imagedata src="datoteke/image001.jpg" o:title="Logotip-KRIK-nov"/> </v:shape><![endif]--><![if !vml]><img border=0 width=184...

1) Still the same problem 2) Still the same problem 3) This works without any problems. But I can only use this using MyODBC 3.51 which has no UTF8 support (which is essential in my case). Using MyODBC i5.1 driver is a problem, because of the timeout issue. Is there anything else I could try? M