Recent content by nector

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

When you create an invoice and you discover that the entire invoice is wrong. Then you must reverse that invoice , create an opposite document called credit note referencing the invoice being reversed . This record will have its own primary and foreign keys in both the parent and child tables...

I have created an insert query it works exactly as required but its not inserting the foreign key in the child table , if that works then is exactly what I wanted. Insert queries Private Sub CmdDuplicate_Click() DoCmd.SetWarnings False DoCmd.OpenQuery "Qry01" DoCmd.OpenQuery "Qry02"...

Very good understanding sir

What I want to archive is to completely reverse the transaction without changing the copy record here, for example see the picture below: I want the same record to be copy into the next new record that is it nothing else