Search results

Hi there, currently, I am writing one column of a listbox selection into an array: Zähler = Forms![View Unpaid Invoices]!Liste2.ItemsSelected.Count ReDim Preserve aVariable(Zähler) For Each element In Forms![View Unpaid Invoices]!Liste2.ItemsSelected aVariable(count1) = Forms![View Unpaid...

Hi Simon - I get the image dimensions via picHgt = ctl.ImageHeight picWdt = ctl.ImageWidth. The image control should alter its size according to the widths and lengths, which is not working. Sorry - but I don't really get your point (Image Control does not have a Can Grow). Thanks for...

No one?? Thank you for any advice.... Frank

Hi there, I have an application where users can indicate a url to their logo stored online. When they open a report (invoice, quote) that logo gets displayed in an image frame (online image gets stored in a temp folder before that). Now I would like the image frame to adapt to the actual image...

Hi there - I'd like to try MS SQL Express as an alternative to MySQL. Do I get a hosted MS SQL Express database from db providers or do I have to host it myself on a windows server? Thanks a lot for help - I already did a lot of web search, without decent results though... FRANK

OK - apparently I didn't have a porpoer design. Tables should rather expand vertically than horizontally. Thx - FRANK

Hi - I have an Access table with already 150 columns. Now I am getting the error message "record too big" (?!) (German: Datensatz zu groß) when I try to enter data. All fields are formatted as text. The upper two of the 6 rows are quite full of data and the error message pops only up when I...

Thank you - will go for the array solution. In addition, I chose to use the language table as offline Access table within the application, so the language strings will not be pulled from MySQL anymore as it will always take a little to do that. Thanks again - FRANK

Hi, I am adding the functionality of changing interface languages to my application, however, I realized that now it takes 3-4 seconds until the form loads, which is a bit frustrating. This time lag appears already with small forms with few labels and buttons. So obviously I would like to...

I know that I am not the most patient person. However, with this forum thread I also wanted to see if there is someone with an online database solution that makes use of MS Access as front-end over WAN which has no connection problems (i.d. timeouts; Server has gone away-problems). Of course...

True - there are plenty of forum discussions on MySQL with Access as front-end (a quite good one: http://www.utteraccess.com/forum/lofiversion/index.php/t1939485.html). I have never seen a real solution though where people agreed on a method which would ensure a stable ODBC connection to the...

Access front-end with MySQL back-end over WAN - exactly (Access 2007 via ODBC 5.1; MySQL-Client-Version: 5.0.51a). I don't know if that answers your question completely. If you need more info for the diagnosis let me know!

I am connecting via MySQL Connector 5.1. The database is hosted on a server where I cannot change server settings, however, I already had my database on a virtual server where I could change wait timeouts etc. via shell and nothing helped. I also have started different forum threads...

I am not saying that MySQL is unstable in general. But as online database for my Access client application is has been very unstable with constant time out problems and many people exerience this issue with no solution in sight. As I said - it is recommended to change server timeouts etc. which...

...if someone could recommend a stable database solution for my Access client application in general, it would be much appreaciated, too. As I said - MySQL is great because it's free, but it is rather unstable considering the fact that the connection often gets interrupted. Thanks for advice -...

MySQL vs. SQL Azure Hi there - I have a small Access application that I sell and I'd like to give my customers also the opportunity to work on their data using an online database. MySQL works ok, but I have never solved the "Server has gone away" issue (including timeout adjustments etc.)...

Great code - works perfectly! Thanks a lot - FRANK

Hi - For several msgbox strings I would like to read the current currency from the regional settings in order to attach the respective currency symbol to different numbers. Is that possible with VBA and - more important - how can I do that? Thanks for help!! FRANK

Thanks for the note on sql. I considered that issue already, so the numbers in my db get nicely stored and retrieved :-) BTW: The workaround with the field.format = currency works very well and is exactly what I needed. Thanks again! One more thing - for a couple of user messages I would like...

Great article - he describes exactly the problem I am facing when Access is showing a "counter-intuitive behaviour" - as he calls it correctly - using the hard-coded value of the previous currency setting instead of the currency set in the regional settings. This was pretty much what I wanted to...