Search results

To answer your question, it seems like you to say I use this method below which also works in full version Access I do not in runtime: Private Sub txtPosCashEndDate_AfterUpdate() Me.txtPosCashEndDate = Format((Me.txtPosCashEndDate), "YYYY\/MM\/DD") End Sub Private Sub...

No validation rule at all

Here is what happens when you enter the date using a date picker, see the picture below: this only happen in Access runtime NOT full version

I have just encountered a problem in access runtime environment; I have created an unbound access form specifically to aid users to select dates required for a parameterized report, this form work very well in in full version of Access and is able to recognize the dates but fail to recognize the...

I don't understand your first code why you set a recordset to something and set it again to something else right after you just set it I don't understand your first code why you set a recordset to something and set it again to something else right after you just set it There two subform which...

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