Search results

Kindly see the example database for easy experiment , I want the same record to be copied to primary key number 2 to make a copy of record on primary key number 1. I do want people to be capturing manually , this way we will avoid errors, both record in parent and child table must be the same...

The record is properly retrieved and I can edit it the problem is the it doesn't come with a new primary key, I'm simply trying to create the exactly duplicate record with just a new primary key ,think of reversing the record or a credit note the only difference required here is that the record...

I have tried that but it is adding zero record up to infinite until I had to stop it by rebooting The parent table and the child table need to have the new record

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

Many thanks to you all and your contribution are highly valued. We sorted out the issue exactly like what Minty said it was the security features with the mixture of VPN and the router.

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

My apologies people for taking too late to reply to this issue, I have been investing why the CDO does not work well with runtime. I have finally found the truth here: (1) The CDO was created to work with full MS Access not depleted runtime period.

This sounds like the index issues here, if the tables are properly indexed and you are using wired local area network access works faster. Never use WIFi in this case. Shifting to SQL Server is like climbing mount Everest, if you really want performance forget about that SQL server its just a...

Many thanks to all experts above for providing valuable information this helped a lot.

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

Many thanks to all you have helped to solve this issues I real appreciate you all.

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

Many thanks CJ London you are great! the sky is the limit you have really made my new present 2025. Once again thank you Regards Ch

Its now giving me the sending failure message , unless I have changed a wrong place , see the new code Dim Newmail As Object Dim mailConfig As Object Dim fields As Variant Dim msConfigURL As String Dim a() As String Dim i As Integer On Error GoTo Err1: 'late binding Set Newmail =...

Many thanks CJ but I do not know where I'm going wrong , see the message below

@ Use the split function on your attachment field and then loop through the array I'm a beat lost how do we use this split function

Its giving me type missmatch With Newmail If Not IsNull(Me.Attachment(1)) Then .AddAttachment Me.Attachment(1) End If If Not IsNull(Me.Attachment(2)) Then .AddAttachment Me.Attachment(2) End If End With

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

Is there any problem if I change the FE from accde to accdr. If leave the FE in this format accde , the above error does not come, but I want to try it again four times. Commenting the error did not show any error in the code at all

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