Search results

We are planning to open a supermarket in a busy place now the tax authority requires us to be sending any prices changes to their office each time we make any changes The reason for this is to ensure that they have record also The prices changes are sent to the tax authority by using an API...

We are keeping some SKU or product lines around 45,000 in the product table now updating prices line by is very cumbersome and time consuming, and so I'm compelled to building a split form which shows all the products with the listed controls and commands: (1) Percentage Change (This is where...

The program below works very fine no errors whatsoever; we have also made sure that all the tables have primary keys and foreign keys to easy searching records. However, someone whispered to me yesterday that the domain functions included in your VBA will be slowing the speed and the solution to...

Here I'm trying to sleep the function below for 10 seconds so that if the internet is not connected it should move to the next code and provide a friendly message to the user so that the user knows exactly what is happening. What is now happening (1) If there no internet the code works ok and...

Hi As I was concluding the pos , after now checking the actual receipts I was surprised to see that the receipts were coming without details lines. That forced me to use the audit software which revealed the following: (1) The code below does a good thing to set focus the cursor after...

I have a product table which hold products for six warehouses. The business rule here says each of the six warehouses must have the same products name, but the difference should be the primary key or differentiated by the primary key. The reason being each warehouse represents a branch listed as...

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