Search results

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

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

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

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

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

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

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

After working almost the whole Xmas day 25th December 2024 to make sure that access is able to send an email from its own form. This process is now working okay though very length . Last issue requiring your help is on attachment for an external document, here I'm using the actual path of the...

Am trying to configure a simple email system in MS Access 2016 so that I can directly send invoices from MS Access 2016 using a form. I have put a button on a form as onclick event, but whenever, I try to send an email I'm getting an error message saying: "Check your internet", transportation...

I need help to solve the parameters in this URL string below which is working okay as long as the parameters are hard codded , now I want the parameters to be more flexible by providing some kind of input form parameters like below: Here are the parameters: Me.txtlatsouth = -15 (where there is...

I have imported the data from the internet successfully, but surprising I'm failing to save it in the database, below is my code what is the problem here: Private Sub CmdImports_Click() Dim n As Integer Dim Request As Object Dim strData As String Dim stUrl As String Dim Response As String Dim...

I'm not sure whether I got a response on this, I have staff who are relatively new and so are not competent to process the landed costing, since we are using the cloud accounting software, I'm able to see their work where we are based. The problem here how to approve their work digitally since...

Dear all, Is it possible someone can have an idea how to call two functions immediately after successful printing of a receipt, the print function is stated below, and so once its run and the document comes out, I need to call the other two functions which links to two APIs to update inventory...

I want to implement the error handling mechanism in the code below, the objectives of the error handling are to give the error message and once the user click okay the code must exit the processing immediately. This will help to ensure that the stock levels are only updated once there no errors...

Hi I'm now doubting myself here on a single form data clone, I want to clone the underlying data on a single form called frmProducts so that people can edit that data anytime they want to. Here is what I'm doing: Private Sub CboSelectProducttoedit_AfterUpdate() Me.Filter = "ProductID = " &...

Sorry people, this question was asked here before, but I seem to see where the problem is coming from and if the permanent solution is found then it will help others as well. When MS Access is used as Front End with MYSQL then whichever form you use for entering new data the Primary Key does...

I have two forms, one the parent form also called Invoice header, and the sub form referred as detail Ines. Now when users are entering data in the sub form the form calculate also the remaining balance of the stock being sold, so in short, the running balances per each product latest balance is...

What is happening here is that whenever I move from one location to another my public IP address changes which is cumbersome, now Imagin we have salesmen moving to different locations in a day. This means that they cannot login or connect to PHP cPanel MYSQL database, is there a way to sort out...