Search results

Hey everyone :D I created a system that automatically links emails from outlook to orders by storing the emails as a .msg file on our server. You can then open the msg file again by pressing a button in a form. To open the Msg File i am using the following code: Public Declare PtrSafe...

Hey, sadly i do not speak the language of the documentation, so i can not look it up for you. Most webservices either have a different URL for functions, GET Parameters or POST Parameters. For Example when i want to send a geocoding request on google i would use the following URL...

Then the simplest code i can come up with would be: inputStr = "CUT 2 09GN20T-01 LEADS" result = Mid(inputStr, InStr(inputStr, "09"), 10) Be carefull though. If it is possible that a 09 could appear somewhere before your desired result, a regex pattern would be better.

Okay. So if the performance of subqueries gets too bad one can use temp tables to cache data, so it does not need to be recalculated. That is a great idea! What tools do you use for a global search and replace?

Yes, this fits with my current knowledge. I also avoid custom functions, that is a good point! The question is now, how do you manage your queries. Are you not using any modularity at all? So for my example are you rewriting the customer name in every query? What if you want to change the layout...

Hey everyone, as a programmer i always try to keep my code modular, so that i can reuse it later. Because my Access SQL Skills are self-taught and i did not know any better, i tried to apply the same in access using subqueries. This resulted in queries i can reuse in any part of the program...

I don't think so. We built our computers based on our existing laws of physics. So to say that we are living in a simulation, because our world works exactly like a computer does is wrong, because we built our computers to work like the world does. Damn... what a weird sentence... :D

This is certainly an interesting topic but i do believe there is nothing that is truely random. If one could simulate every atom in the universe one could definitely predict the future. Why? Because the whole Universe is running on predefined rules. And for every rule there is a mathematical...

Then why do you allow him to partake in the discussion? If you see Adam is trolling just ban him/remove him from this thread. When Adam is trolling and people get mad it is his joy. If you ban him after having a emotional discussion, then he sees this as a success, and will create another...

I really enjoyed reading the discussion until conception_native_0123 joined. Since then the whole thread has just been accusations, offenses and personal stuff. I think your name is Adam right? The problem with your style of argumentation is that you try to get a reaction out of people by...

Thank you very much everyone! And thank you cheekybuddha for the awesome example code! This solves my problem :)

I do not want to set the focus on a report control, but a form control :) My bad. How do i pass the Form and Control Object? Like this?

Hello everyone, i want a control to receive focus whenever the mouse hovers above it. For this i use the following VBA Code: Private Sub ExampleCtrl_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) ExampleCtrl.SetFocus End Sub Now this should happen on multiple...

THAT one is great! Thank you very much! This is exactly what i needed!

Thank you arnelgp, your code helped me. You did convert the datasheet form to a single form view though, so this kinda defeats the purpose of my form. The error still persists when you convert it to a datasheet view and close all subdatasheets. I think the problem lies somewhere else. When you...

Here is the database. I can not give you the tables because they have customer data in it. I Removed the recordsource in the form, so the code should work. The error appears in the following line: With Forms!frm_Zahlungen.Form!frm_Zahlungen_Sub.Form!SubdataForm.Form

I think the problem here is that a SubSubForm opened as a Subdatasheet can not be referenced? But how do i get my code to work? Is there another way to reference it?

That is what i originally did. See my first post :) I tried it with the new "With" code With Forms!frm_Zahlungen!frm_Zahlungen_Sub.Form!SubdataForm.Form Still get the same error

Both names are correct though, so what may be the problem here?

i tried the following code With Forms!frm_Zahlungen!frm_Zahlungen_Sub!SubdataForm.Form .Filter = strFilter .FilterOn = True End With But i still get the error on the first line access error 2455 invalid reference to the property form report