Search results

Hello everyone, i am trying to automate sending an email from Access to Outlook. For that i created the following code: Sub SendMail() Dim OlApp As Outlook.Application Dim ObjMail As Outlook.MailItem Set OlApp = Outlook.Application Set oMail= OlApp.CreateItem(olMailItem)...

Hello everyone, i know this is a bit offtopic, as we are talking mostly about dll's here, but at the end the dll should be used in access. I created a custom COM DLL using C# in Visual Studio. After importing the DLL in Access, a runtime error popped up "class not registered". According to...

Hello everyone, i am trying to use Amazon AWS WebService in MS Access. Amazon does not include official VBA support, but they provides a precompiled DLL for various different .Net Versions. https://www.nuget.org/packages/AWSSDK.Core/ My experience with DLL's in Access is limited to say the...

Hello everyone, i am working on a quite general system that should be used in any form. I have a popup form that can be opened on a lot of forms. This Popup form is a list where you can select values from. When opening the form, the "target control" is saved as a public variable. This is the...

Hello everyone, i have a combobox in an access form. The rowsource is set to a table in my database. Now whenever the user does a specific action i change the row source using VBA to display different values. Whenever i close the form and reopen it again, the rowsource is set back to it's...

Hey everyone, less of a suggestion and more of a question. I see a lot of you guys have a custom member tag/title. How can one change that?

Hey everyone, in my current project i have a list of Car Types one should be able to assign for each customer. for this system i have 3 tables. tbl_CarType(CarID, TypeName) tbl_Customer(CustomerID) tbl_Customer_CarType(ConnectionID, CustomerID_F, CarID_F) You can see tbl_Customer_CarType is...

Hello everyone, i have an ActiveX webbrowser control in my access database which is supposed to show PDF's. On some of our machines the webcontrol only shows a dark gray area. This is the code i use to open the pdf: WebBrowser.Navigate "T:\Path\To\File\FileName.pdf" I made sure the path for...

Hey everyone, currently i am running a Frontend/Backend Split, networked Access database. The backend lays on a seperate computer and we are using Shared Windows folder to connect the other PC's to the backend. (If it helps, the command we use to connect to the server is simply "net use T...

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 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...

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...

Hey everyone, for our software i want to create a form showing all customers in a table-view. In addition to that a subdatasheet is supposed to show all orders related to the customer. For this i created a subform, that shows all customers in table-view, and another subform inside the subform...

A client of mine requested to make him a general search field, that can be used to search for more than one field at the time. For example when searching for a customer in the system, you have one input box, where you can search for customer name, street, place, Tax-ID, email, telefone You can...

Hello everyone, in my VBA code i have 2 variables. VDate as Date and VString as String. VString = "22.2" VDate = 22.02.2021 I am now comparing those 2 in an if and the code inside the if is executed. If VString = VDate Then Debug.Print("Hello World") End If Output: Hello World Is this...

Hello everyone, i have a table with multiple timestamps and corresponding Actions. 00:00:01 - Action 1 00:00:04 - Action 2 00:00:10 - Action 3 00:01:00 - Action 4 00:01:23 - Action 5 I need a query that outputs the time that passed between those actions. The end result should look similar to...

Hello everyone, Coming from a programming background i like having independent systems, and reusing old "functions". Same applies for SQL queries. i created multiple subqueries to show data in the format i need. For example i have a query which shows all customers in the format [Name] &...

Hello everyone, i am creating a report which displays customers and their orders. For this i am using a report containing a subreport, which lists all the orders. Whenever i open the page preview everything works fine, the orders is listed the correct way. But whenever i try to print or open...

Hello everyone, i am currently developing an access application for a small company. We are close to finishing the project and the database has quite the size. I am the only developer so i have full control over the whole application. We split our database into a frontend and a backend, and i am...

Hello everyone, i am currently creating a vba solution for outlook to communicate with my access application. I created a custom Button in the Outlook Header Bar, that calls access to open a form. So far so good. Now i want vba to set the focus from outlook to access, so that i can immediately...