Search results

Dear Good morning! First all many thanks to the team members you really helped me a lot from day one when I joined this forum and my intention is to be featuring here frequently to help others as well. This is the only forum that I respect so much, my seven years of coding with VBA would have...

Good afternoon, all! See how you can advise when using MYSQL DB Maria ODBC connector. Connecting to the DB require composing an ODBC string like below: ODBC;DRIVER={MySQL ODBC 8.0 ANSI...

Hi Is there a way or VBA code to stop access from printing extra page which is blank at the end of the report. For example, page 1 has only two lines of data, but it will also print page 2 which is completely blank which is a waist of paper. We have been intervening manually by going into...

I want to filter the column called TPIN so that all duplicates are eliminated , how do I do it? SELECT tblCustomers.CustomerID, tblCustomers.Company, tblCustomers.CustStatus, tblCustomers.TPIN FROM tblCustomers WHERE (((tblCustomers.Company) Is Not Null) AND ((tblCustomers.CustStatus) Is Null...

I'm having some challenges connecting my MS Access front end to mysql phpmyadmin using VPN , but if I use the public IP address everything works very well. The only challenge with the public IP address is that most of the users use the phone hot spots and keep on switching location as a result...

Hello. I'm trying to receive some emails into my MS Access database directly from my Gmail account using CDO 2000 library, but somehow I'm getting an error see the pictures for the error: VBA CODE Private Sub CmdNewEmails_Click() Dim objSession As Object Dim objInbox As Object Dim...

I want to a convert a month written like , 31/01/2025 into a number example = 1 etc , is there a function that I can use at MS Access Query level I tried this below its not doing what I want: Private Function GetMonthNumber(pstrMonthName As String) As Integer Dim i As Long For i = 1 To 12...

I want to be updating a control called currentstock whenever I launch a query below instead of me doing it manually to avoid mistakes. At the moment the update is put on afterevent in the subform and it fires immediately I change the quantinty but does not fire if I requery the data unless I go...

Hi I have managed to get the underlaying record by filtering, from the filtered record I want to create a new record to be used as a credit note. The filter below gets the invoice detail all of it, instead of recapturing the records one by one I'm using filter below, now I want to use that...

I have two computers using the same network in the same building storing the information on MYSQL (Cloud), now as long as I'm in the same building computer B can access the resources stored on computer A which is the JAVA file by using port number 8080 because the public IP address on both...

Our department want an MS Access switchboard menu , though I Know we add it manually its not on the menu of MS Access 2016 . The sales switchboard must have the following reports : (1) Sales reports with each button representing a sales area or an outlet (Example, town Centre , first class ...

Is possible to convert a longer date received from a website into a short date in MS Access Example longer date : Tue, 24 Dec 2024 12:55:03 GMT) Convert into : 24/12/2024 I have tried this it failed: Format((Tue, 24 Dec 2024 12:55:03 GMT),"DD\/MM\/YYYY") Any idea here We are interested...

The code below is almost complete of course with the help of the members here or on this forum, all is working fine but with one exception it can only send one attachment at a time. I have managed to attach multiple file as you can see below on the screen shoot, so the challenge is how to send...

I have configured the Gmail in MS Access 2016 with VBA and everything is work okay: (1) I'm able to select recipients emails from the combo box (2) I'm able to concatenate several emails automatically like we do it in outlook (3) I have made both the attachment and CC as option all is working...

After working almost the whole Xmas day 25th December 2024 to make sure that access is able to send an email from its own form. This process is now working okay though very length . Last issue requiring your help is on attachment for an external document, here I'm using the actual path of the...

Am trying to configure a simple email system in MS Access 2016 so that I can directly send invoices from MS Access 2016 using a form. I have put a button on a form as onclick event, but whenever, I try to send an email I'm getting an error message saying: "Check your internet", transportation...

I need help to solve the parameters in this URL string below which is working okay as long as the parameters are hard codded , now I want the parameters to be more flexible by providing some kind of input form parameters like below: Here are the parameters: Me.txtlatsouth = -15 (where there is...

I have imported the data from the internet successfully, but surprising I'm failing to save it in the database, below is my code what is the problem here: Private Sub CmdImports_Click() Dim n As Integer Dim Request As Object Dim strData As String Dim stUrl As String Dim Response As String Dim...

I'm not sure whether I got a response on this, I have staff who are relatively new and so are not competent to process the landed costing, since we are using the cloud accounting software, I'm able to see their work where we are based. The problem here how to approve their work digitally since...

Dear all, Is it possible someone can have an idea how to call two functions immediately after successful printing of a receipt, the print function is stated below, and so once its run and the document comes out, I need to call the other two functions which links to two APIs to update inventory...