Search results

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

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 will do a video on I solved it for other to learn

I think there is a total misunderstanding here. When a user is creating some invoice detail line the current stock balance is automatically calculated the moment the new stock quantity is entered, what fire the calculation is the after event on quantity control. At this stage all is fine, the...

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

Many thanks Mike you pointed me to the right direction with a minor amendments to your code, this now work correctly INSERT INTO tblLineDetails ( InvoiceID, Quantities, SellingPrice, ProductName ) SELECT DMax("InvoiceID","tblInvoiceHeader"), tblLineDetails.Quantities...

Thank you so much you appear to understand my problem and its almost just there, check on the child tale the key being entered 1 instead of new foreign key called 2 , if this can be achieved that is all I want.

Is there a way to insert a foreign keys, that is my query nothing more