Search results

Hi there, one of the users of my application has set his regional settings of Windows to Turkish which caused a strange error. So the application has 2 forms, one of which is for creating quotes, and the other for creating jobs. The "create quote" form is working absolutely fine. When I start...

I tried this query: SELECT Year([InvoiceDate]) & ' ' & Month([InvoiceDate]) AS [Month], IIf(IsNull([customers]![CustomerID]),0,[customers]![CustomerID]) AS Umsatz FROM Invoices INNER JOIN customers ON Invoices.CustomerID = customers.CustomerID WHERE (((Invoices.InvoiceDate) Between #1/1/2013#...

Sorry, but I don't quite understand! Could you give a hint how to implement this? Thanks a lot - FRANK

Hi there, I am pulling sales results per customer and month. For presenting the numbers in a diagram I would like to show 0 sales for months in which no sales were generated. At the moment the query results only the months in which there are sales > 0. Is there a trick that I don't know? Thanks...

Great advice - it still needed a lot of work, but your advice was very helpful. Thanks- Frank

Hi! I've spent hours to solve this...please help! I want to create a report with assigments (payment info etc). listed per translator. I have a translation table with the fields translator and proofreader. These two fields are linked to ID_Translator in the translator table. The problem is that...

Hi there, I'm trying to find out the size and resolution of the background image to make it fit 100% into the report without any part of the image getting cropped. As the report is A4 I tried to insert (via VBA; report.picture=...) an A4 Gif with a resolution of 72 pixels which results in a...

I just discovered that the auto increment values were missing. I had converted the table from MySQL and all primary keys were still there. Only the auto increment fields had been converted into number fields....:-/ Thank you, Frank

Hi there Until now I had no problems with my DoCmd.RunSQL commands. Then I split my database to have an external db file. No I am linking the tables each time when I access my application. Now commands such as DoCmd.RunSQL "Insert... are not working anmore. There is no error, but nothing...

I'd like to give the users of my app the possibility to connect to their MySQL database via SSH tunnel. Yes, Putty is helpful, but also not very handy. Thus, it'd be great to build the SSH tunnel with VBA. Is that possible? How?? :-) Thanks for help - FRANK

OK, thanks for your answer. With regard to the exe I know that the Runtime is not included in the exe, but in the setup package. Or is it different with the 2010 Developer Tools? I have created an exe including Access Runtime with Inno Setup, however it's not 100% reliable (sometimes the Access...

Hi there, I need advice on the Access Developer version. Currently I am distributing my Access app with Runtime 2007 and Inno as executable accde file. So now I heard of an Access Developer version which permits creating exe files and distributing the application as stand alone without Access...

Great idea - thanks a lot. :) I always focused on creating a little update file that would contain the update commands instead of simply implementing everything in the application. For me it's now important to see if MySQL needs other sql alter commands than the Access db for offline users. In...

This is exactly what I am trying to find out - how I can make the users of my application run certain commands which will update the tables they are using. Would you let them paste the commands in a form or is it possible to execute a file for instance? It should be really easy and ideally...

Hi there, I have an Access application which I distribute either as network version (with MySQL as backend) or as "offline" version using the standard access db as backend. For users with the standard offline version I have implemented a backup feature using the common VBA method which copies...

Thanks again for your input. As this report has only one page, I decided to simply use the enlargeable report header instead of the page header which cannot dynamically grow/shrink. FRANK

Currently, the text field is placed in the page header. It's plain text that goes into the text field. So you are saying that I could fill the subreport with my text (text depends on variables, so it's not always the same) and the subreport would dynamically expand and collapse, and so would the...

Hi there, with VBA I would like to dynamically adapt the height of a report's page header depending on the height of a certain text field, which is expandable. The problem is, even though the field is expandable, I always get the same value for textfieldXY.height, no matter how high it is in...

OK - first, I took a look at your code, but as I am not an expert, I didn't really get it... :-/ YOU ARE RIGHT - it works great!!! :-) Thanks a lot. Actually, it really does exactly what I needed. Thanks again!! FRANK

Thanks a lot - I think you got me wrong. I'll give you an example: Let's say the array contains 111, 126 and 200 (three invoice IDs). Now I would like to build a string as follows: Select * from invoices where InvoiceID = these three numbers. I solved this with a static solution (where InvoiceID...