Search results

Hi all, I'm trying to speed up the record set in MS Access being used by the VBA code below, see the code, but I got mixed up in the middle especially on the issue below by the way this is based on linked table to AZURE: (1) What happens with the concurrent users, suppose someone post a record...

I'm trying to develop a progress meter to help users have an idea of how long their report or open record set is taking running, this way users will have full ideas of what is going on in the system rather than just waiting. The small, attached database has a VBA module below working in...

I have come across the statement below suggesting that the memory could be very important to gain speed with MS Access linked to cloud SQL database: SQL Server is a memory hog. You'd need 32-64 gb minimum, depending on the databases it's handling. Is the above statement true????????

I thought this was going to be very simple but I keep on getting an error message when I try to run a pass through query to insert data to similar table in MS SQL server. Please note that all the fields are the same except that the other table is in access while other one is MS SQL Server...

I want to update my parent form controls from the results of the subform line totals so that people do not need to capture the results into the parent form where they are mandatory required manually. I'm currently picking the totals from the subform into the parent form unbound controls by the...

I have tried to convert this query below into a passthrough delete query but I keep on getting an error message from the SQL Server why? DELETE tblItemClassList.itemlistID, tblItemClassList.itemClsCd, tblItemClassList.itemClsNm FROM tblItemClassList WHERE (((tblItemClassList.itemClsNm) Is Not...

I'm only pulling one record at a time to be used by the VBA record set from Cloud SQL server, I'm using this strategy as per advice from this platform , yes there is an improvement , but the 10 seconds its taking to pull data is too much and users do like this. Here is my simple Query: SELECT...

I want to clear the input form so that new record can be added, I'm using this code below, but it's creating a new PK number, this is leaving some gaps in sequencing my record and it's an audit issue because it's not always when people should continue capturing at some point they have to knock...

The field below is a date release now sometimes the date field is empty , now in the Json dictionary it keeps return "" instead of null as result I'm always getting an error. Company.Add "stockRlsDt", rs!stockreleasing.value I want this field to return null if empty and actual date if not null

We have a pricing table which is linked from access by ODBC link tables to SQL server cloud , now this table is required to change the prices regularly , but whenever we want to do the changes we always receive a message that the table is being edited by another user even if there is non , and...

We have 10 salesmen who go in the field to go and sell our products (They all have tablets with Windows 11 and Access 365 as FE), the taxman require them to issue a digital tax invoice right there in the field, but to do that they need to connect to our local server and this can be done via WIFI...

Although I have an option to recapture the received Json manually from the report into both the parent and child tables, but I see this option to be somehow risk because wrong data can be easily captured we are human and this is also alot of work So, in view of the above I have struggled to...

I'm not a fan of indexing the foreign in my SQL Server Database, some people suggest that indexing the foreign can help queries data retrieval faster as but the queries be parameterized. Especially when the front end is MS Access, could this be true? If yes any supporting material evidence?

We have two backends (BEs, that is Cloud SQL Server and MS Access) using the same MS Access interface as front end (FE) to send data via the internet to the server. If we send the data using the code below and save the response to the backends below, see results: (1) Cloud SQL Server will take...

Hello people! I have created a server that run Apache tomcat & Java JDK to communicate essential information or sales invoice data to another organization totally different from ours. This system works very well if run on the local server where Apache tomcat & JDK is installed. Now we have...

First my apologies people one team member helped on the most complex saving Json in access table, I thought the one below was simpler, and so I was going to manage it without problems, but it is simply saving air only in the table. Where do I go wrong here? Received Json from cloud server...

When we process an invoice, we transmit it to the taxman by the way of an API and then when accepted by the taxman server, the server responds by sending back a Json string like below: {"resultCd":"000","resultMsg":"It is...

I'm now stack here, I have an application which get the information from a server in another city, now we have installed both JAVA JDK and Apache Tomcat link the local server which uses a router to link the cloud server all is working fine as expected. The challenge is how to create a static IP...

How do we get a unique record from sql server relating to a primary key without any duplicate on the report, I have been using the code below but if the user creates two or three lines with the same product name , unit price and total only one record will appear instead of all. Why it does not...

I have developed a code for the purpose of get information from the server, well if I put the correct URL it works just fine , but if I put a wrong URL it give an error message and also debug. I do not want to see the debug on the screen but a proper suppressing error handler with a message not...