Search results

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

Yes the user has read/write access. I tested it using "normal" table linking (File/External data/link tables). M

Hello! I'm using Access 2003 and MyODBC 5.1 driver to connect to a remote MySQL server. I have to connect from code, because I have timeout issues (which can not be resolved from MyODBC 5.1 driver interface; no more "Initial statement" option). Anyway after a painful process of getting this...

Fixed it. The problem was that due to some othe part of the code (in certain cases) I had some primary key violentions. Tnx for the help. M

Hi! I hope this is the right section for posting this Q. I use Access 2003 on WinXP pro as front-end & for back-end a MySql on a Linux server. I use MyODBC to connect to the back-end and all the tables are on the back-end. The workstation is connected to the server via VPN (so the server and...

just one more thing: if I use the autoincrement in a field (system table) is there any way that I don't get any missing values ??? e.g. I start with 1 then, 2, 3, 4, 5, I then delete the record with the "5" and I would like the next record to be "5" again not "6" !