Search results

@Simon: I really don't to create a multi-currency-application. I am aware of the fact that currencies would not be converted, but it would rather be only the prefix that would be changed when switching the currency in the regional settings. --> are you saying, I should e.g. choose an ordinary...

You got me wrong - I don't want 2 currencies at the same time. I just want one single currency, but all 'currency' formatted fields should display the currency choosen in the regional settings correctly. And one should be able to switch in between currencies. Of course, one Euro would be one...

Hi! I would like to give users the opportunity to use my application with different currencies (e.g. Germans with €, Swiss with Fr./CHF). I found out that it would be enough to format a field as 'currency' and then to simply change the currency in the regional settings of Windows. I did both...

Both ways work - so thanks a lot!!!!!!!! :) FRANK

Hi, I am trying to get the ID of the second highest record. Unfortunately, the sql-result is always empty. What is wrong with my code? Thanks for help! FRANK Set db = CurrentDb strSQL = "SELECT Min(QuoteID) FROM (SELECT TOP 2 * FROM Quotes ORDER BY QuoteID DESC)" Set rs =...

Hi - I am linking the tables of my MySQL database using the code below. The line "db.TableDefs.Append mytable" is causing an error though (triggers the on error event). Does anybody know how I can change the code so the code works without the error? Thanks a lot! FRANK Conn.Provider = "MSDASQL"...

...can anyone help me with the correct implementation of the auto-reconnect flag in the connection string? The one I have built (Constr = "DRIVER={MySQL ODBC 5.1 Driver};Server=" & Server & _ ";port=" & Port & ";user=" & user & ";Password=" & pw & ";Database=" & Datenbank & "; Option=4194304;")...

This is what I was looking for - I tried to implement the option into my connection string, but it didn't work so far. Can somebody tell me, if the string is correct like this? Option=4194304 is supposed to switch the auto-reconnect on. Constr = "DRIVER={MySQL ODBC 5.1 Driver};Server=" &...

It isn't really what I'm looking for, but thank you anyways. I thought I could do the same what I can do in the control panel (checking the enable automatic reconnect box) also in VBA. That would be the most convenient solution for me. THANK YOU!

Thank you for your answer. The if part seems reasonable, but I cannot constantly check, if the connection is lost, or can I? How can I trigger an event when the connection is lost? I need some help to implement this - sorry! Thank you - FRANK

Hi, I had the problem that Access lost the connection to my MySQL db after a certain time period. Previously I connected via Constr = "DRIVER={MySQL ODBC 3.51 Driver};Server=" & Server & _ ";port=" & Port & ";user=" & user & ";Password=" & pw & ";Database=" & Datenbank"Now I connect via DNS...

Hi - is there a way to display a custom message when Access loses the ODBC connection to the MySQL database? The default message is somthing like "MySQL server has gone away" Lost connection etc. I would like to customize the message. Is this possible? Thanks a lot for advice! FRANK

Well - I read that the following "pass through query" would help setting the wait_timeout parameter: Connect property: ODBC;DRIVER={MySQL ODBC 5.1 Driver};SERVER=xxx.xxx.xxx.xxx;DATABASE=YourDatabaseName;OPTION=35;INITSTMT=SET @@wait_timeout=28800;UID=YourUserName;PWD=YourPassword SQL...

Works great - thanks a lot! Regards, Frank

Nesting variables within string variables possible? Hi - I have a small access application where I have several text segments (like email subjects and bodies) which can be edited by users. These text segments/string variables shall contain variables, like names etc. Users should be able to...

Hi - I connect to MySQL via ODBC but after a few minutes the connection is dropped when the user is inactive. I heard that changing the wait_timeout variable would help, but according to my provider it cannot be changed (just for my purposes). Is there another way to keep the connection...

Well - if every company worldwide would have the same logo, the Save as solution would be absolutely ok. If an application is used by different users/providers it is necessary to offer a flexible solution where e.g. the path to the image can be changed by the user. So - can somebody recommend...

I have tried to load an image with the help of a webbrowser control into the report, but it worked only for forms. In reports I got only a black rectangle. Can anyone help me with this? Thanks in advance!

That rather sounds like a work around - do you know/have an existing script for that? Nobody knows how to display images withouth saving them on the hard disk? Thanks!

I am trying to load images (logos) into Access reports from a MySQL database (via image path). I already tried the simple approach with "X.picture = URL.jpg" but apparently Access cannot open jpgs following this procedure. I have already searched a lot in forums etc., but I didn't find...