Search results

Thanks for the feedback June. I will switch to ControlSource instead. I'm actually using the ControlTipText to provide feedback on the result, what is wrong etc. So is it possible to refer to the name of the image in the function call? I have mulitple of these validation checks and images to...

Hi all, I need some help. On my form I have an unbound image object. I want to set the image source and image tooltip text from an external procedure (module in the same DB). It's basically a validation sub. The user enters some details, for example an e-mail address. Then I run the validation...

I'm very interested to see if you find a solution for this, could be usefull for everybody. Attached are the files from UA, hope it helps!

It looks like Google offers a (depricated) API for this as part of the Google Charts API. I didn't test it yet, but basically you send a XML GET request with the specified URL and parameters and then you should be able to download the image. It may be a good starting point...

Or take a look at this excellent thread from Ridders https://access-programmers.co.uk/forums/showthread.php?t=294548

Thank you Doc Man, that's a very interesting concept. I didn't think of it that way. My current HourType table is comparible to your TransactionType table, so I just need to add the multiplier value there. I will work further on this concept, thank you for sharing your insights!

Hi all, I'm building a database to keep track of holiday hours and absent hours of my personnel. Before building all forms and reports I want to set up the data structure properly. I currently have 1 table that stores everything. EmployeeID, HourTypeID, NrOfHours. The problem is that with...

To increase readability and prevent missing parameters, I would not use IIF for 20 scenarios. Why not just 20 If... Then... End if statements? Would make things a lot clear in my opinion.

+1 on B... We need JSON support!

Are we sure that the 'else' statements here are optional? You have 2 iif statements and only 2 then statements, I think you need at least 1 more else statement. Iif(x = y, high, iif(a = b, low, ""), "")

Thanks a lot CJ. The year is actually stored as a string in this particular DB, so I made it a string deliberately. And yes, changing the name of the parameter to a non-reserved word makes good sense. I will try to modify the query to use the Eval function instead. I think this was my main...

Hi all, I am having issues with opening a recordset based on a query that requires two parameters. My query has a parameter [Year] and a parameter [Partlist] The partlist should be a string of Article codes seperated by the Or parameter. The first parameter (Year) works fine, but when I add...

I also use this code for updating the frontends in my office. It works very well, but I would recommend making one modification. Currently the update process runs if the Frontend version is not equal to the master version. It would be better to run it only when the Frontend version is smaller...

Hello I don't have a complete code ready, but as a start you can take a look at this function from Daniel Pinault from the DevHut: https://www.devhut.net/2012/07/13/vba-list-of-files-in-a-specified-folder-or-directory/ It allows you to loop through your PDF dir. You then add a line that...

You can also use an Access Excel automation example, for example this one provided by Daniel Pinault from the DevHut: https://www.devhut.net/2017/03/15/ms-access-vba-export-recordset-to-excel/ If you simply don't save the file, the user can do that himself or just close the file without saving....

Hi Static, why do you choose this method (open recordset and test EOF) instead of a dcount or dlookup? And don't you have to explicitly close the recordset as well? Just wondering. Thx

Ok... that was easier then expected. I created the function below and it seems to work as expected. Any feedback is always welcome, but for now it seems to be solved. Public Function CalcGermanVAT(strVatNr As String) As Boolean 'Declare variables Dim IntCnt As Integer Dim...

Hi guys, I have a need to validate German VAT numbers using the check digit formula. The German VAT number starts with DE followed by 8 digits and 1 check digit. There is a formula that you can use the calculate the check digit and with that validate if the number is correct. The formula is...

You should debug.print the SQL without executing it... You miss the space after the where part

The last format function is opened, but never closed and you don't specify the desired format...