Search results

The VBA code below sometimes takes more than twenty seconds to run, now a decision is made that if this code takes longer than 20 seconds then it should quit and move to the next code instead of rotating for 10 minutes on one code, for sure a timer is required, that is where it's getting...

This scenario is based on a POS touch screen where you cannot see any keyboard for data entry, now in MS Access we built a Keyboard unbound form to assist in capturing data. The reason why we did it that way is that there are some situations when the scanner fails to scan the barcode, and so the...

Hi all, The code below is coming from the solution previously given, fair enough that was excellent, but last night when I was now doing an extensive testing, I discovered that the VBA Code below sometimes will start numbering rows in the subform from 0,1,2,3 ,4 etc instead of always starting...

Hi Yesterday I came to learn that the access database does not have a row line numbering system, for example if an invoice has ten rows, how can we also number those rows from one to ten. I tried the small database below I cannot get write. See if you can figure it out. EG 1 2 3 4 I want...

Instead of the users lookup for the correct product code/barcode from the subform I want the users to simply scan the barcode from the parent form from the control called productcode and once that is done then the after update event fires and update the subform. Option Compare Database Option...

We dumped MS SQL Server for MYSQL as relational database due to speed we have been using this MYSQL databases with MS Access as front end and has proved to be reliable and our users like the speed compared to MS SQL Server which makes the speed horrible even if you do what is so called tunning...

I'm trying to work on this VBA which helps to send invoices to customers silently without opening outlook, but on the .Edit I'm getting an error message what could be the reason for that and how to fix it. However, this is not my code I got it on the internet, Im simply trying to see if it can...

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

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

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

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

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