Search results

The error occurs here: .Application.Run MacroName:="fill_with_data", varg1:=strDirectoryPath The error I get in Access is: Automation error. Exception occurred This is caused by passing the parameter to the word file as everything runs smootly when I do not pass the parameter. Debugging the...

Sure, here we go! (In Word I only retrieve the variable as shown above) Public Function open_quote_in_word(req_quoteID) Dim strFileName, varg1, strDirectoryPath As String strDirectoryPath = CurrentProject.Path & "\" Set db = CurrentDb strSQL = "Select quotes.QuoteID_ext_long...

That didn't do it :-( I might use a workaround with a temporary txt file...

Hi there, without any problems I execute a macro in a Word file from Access with this command: Application.Run MacroName:="fill_with_data"Now I would like to pass a parameter with this command: Application.Run MacroName:="fill_with_data", varg1:=strDirectoryPathIn Word I retrieve the variable...

However, when I switch back System Locale to German, the code is there (using the SAME file) and I can run the application without problems. Only with Japanese I get the errors and I can't see where the code stops (probably because the entire code is somehow locked). Who can help?

Yes, that's strange - it seems as if there is no VBA code. As I said - when I open the editor, there is nothing. I can't see any code. BUT - when I change the System locale back to German (incl. reboot) everything is back to normal, i.e. I can see the code and VBA/the application works. So it...

Hi there - I would like to install my Access app on machines in Japan running with Japanese OS. The users told me about problems on start up which is why I switched my System locale (Win 10; Access 2007) to Japanese. The first error message I get is: When I want to check the code for problems...

Hm, I think you got me wrong. I want to use the same method in Access/VBA for encryption as I do in the browser with PHP. This is why I'd like to know if someone can help me to implement SHA2 etc. in Access/VBA.

How to use sha hashing Hi there - I'd like to access data that I use in Access also via browser/php. For the login, I'd like to use a secure encryption method for passwords etc. MD5 seems to be unsecure - so now I'd like to implement sha encryption via Access VBA and in the browser/php. Has...

Thank you for your ideas - I can 100% exclude that other users are accessing the database - it's a local test database which is only openend by me. AND - I can alter other tables. Thank you for other ideas. FRANK

Hi - this has already taken me days....:-/ When I try to add a column via SQL to the table employees I get the following error: The database engine could not lock table employees because it is in use by another person or process.With my other tables the command works (tried it to make sure the...

Hi again - I didn't know that you can link queries like that! It works pretty well. Thanks a lot for working this out. Regarding the null values - they weren't meant to be in the absence table - I just wanted translators to be considered available that have no record in the absence table. That's...

Thank you, however this has been a format error. I needed to convert the date to US date format in order to use it in the query. I now attached the problematic query in a small db. You can see the problem when you look at translator1 who shouldn't be available today, but for whom were entered...

In the Access Expression Builder I successfully created the query - however when I copy and adapt this into VBA it results a syntax error. Can somebody help me with this: The working query in the Access Expression Builder: SELECT DISTINCT Language_Combinations_Prices.Trans_ID AS [" &...

Unfortunately it would take me hours to provide my database - otherwise I'd have done it right away. I now have tried LEFT JOIN which works pretty well but still has one problem - when there are several absence times entered for one translator, that translator gets listed if though he is not...

What if I have not entered any absence times for a translator? Actually they should be selected if I use WHERE (((translator_absence_times.startdate_absence) Is Null)), am I right? However this Select results in 0 results. When I use WHERE (((translator_absence_times.startdate_absence) Not Is...

Hi there - I'm trying to select translators who are available today. For this I'm checking against the entered absence times - how can I list also translators for whom no absence times where entered? (these are obviously available...) Thanks for help! FRANK SELECT DISTINCT...

Hi there - I'm using a great treeview component from http://www.jkp-ads.com/articles/treeview.asp using fm20.dll/Microsoft Forms Object Lib because I had issues with mscomctl.ocx. Now a user of my application doesn't see the treeview. Probably fm20.dll is missing or corrupted. Is it sufficient...

I'll try the same in the coming days - unfortunately the instructions for Access aren't as detailed as they are for Excel. BTW: On the same website there are more examples using the same treeview code: http://www.jkp-ads.com/Articles/treeview02.asp

I too have many issues with registering mscomctl.ocx, therefore I'd like to swith to this great solution. Here I found a working, simplified example: http://www.eileenslounge.com/viewtopic.php?f=30&t=12433 However it has been implemented in XLS.... :-/