Recent content by nector

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

There were some hidden controls in the footer sub report taking a wider space, after shrinking them to zero all was sorted out, thanks to minty he opened up my thinking

The issue on the subreport now its working okay

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

Many thanks to all of you I appreciate your help its well noted

Can you demonstrate what you want to occur? Suppose you have the below sample data, please list the data you expect your query to return: TPIN, ID abc, 1 def, 2 ghi, 1 abc, 2 def, 2 If TPIN = 100 , then even if in a combo there 5 customers with 100 , the combo must return only one

At the moment users captures one customer twice hence the need for a filter

The Dd is mysql its on cloud

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

Yes, the road is quite complex, but somehow, I have to find a library in MS Access equivalent VB6 : EAGetMailObj ActiveX Object This is the one I cannot find in MS Access to create a session

Okay it's a mixture of VB6 and some translation to come up with this, in some bits are from VB6 and VBA the problem which i have or I see the critical killer is how to reference the correct library in order to create an object session, that is where the problem is . The code will work fine if...

Before you can receive emails you have to set an email address up and to do that you use something like outlook Gmail Yahoo... Now you have an email address, you give the email address to someone, they send an email but it doesn't go to you, it goes to outlook or Gmail or wherever and is stored...

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