Search results

But I will not give up on this one no matter what, a solution will be found soon, I had the combo boxes problem before where 3 million records are on a table but the combo box can only load 65500 record, by trying the in initialized code on the combo box now all my forms load on a maximum of 3...

Many thanks all contributors, Kindly take note that is not the live table by just a fiction table , but the point remain the same was to get a progress meter because sometimes users feel uncomfortable when a report is taking long without any response.

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

Thank you so much all contributors

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

If you are suggesting some like below: DoCmd.OpenForm "frmCustomerInvoice", Where [InvoiceID] = 0"

Either you are doing something wrong like binding your forms to tables or queries with no criteria and using Access to filter locally. With total respect to what you are saying all my data entry form have their data entry properties set to "YES", and so they open without a single record at all...

Just filter a query either <> 0 in the query grid, I always do it that way

If you are using those codes within access and the DB or BE is access then its fine, but if you want to use the SQL server with Access then expect to pay a heavy price in terms of slowness.

Yes sir, from my own experience, using the SQL server can only be good if you are running Views for reports. But using bound forms to the table with the form's property turned to data entry still in terms of speed it is slow to about 25 seconds compared to a form bound to an MS Access table...

Many thanks cheekybuddha I will surely settle on your solution , also warm regards to all the contributors all your answers are valuable to me.

try it and see. Why not just use a linked table to sql server - what do you see as the benefit of using a passthrough query? I'm currently using the linked tables but committing just one takes too much time such 30 seconds

How about OPENROWSET in a passthrough query can it work here

Its looks like it does not recognize my access table tblstaffnew

Here is a clean code sir INSERT INTO tblStaff ( EmpName, EmpPassword, UserRights, tpin, bhfId, userId, adrs, cntc, authCd, remark, useYn, regrNm, regrId, modrNm, modrId, Status ) SELECT tblStaffNew.EmpName, tblStaffNew.EmpPassword, tblStaffNew.UserRights, tblStaffNew.tpin, tblStaffNew.bhfId...

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

Another way is not to try to use the subform to update the main form, but simply requery the main form. I can see that there could be an issue that, for instance, an order total is slightly different to the sum of the order lines because of the effect of rounding, and sometimes the best...

Do not save any totals data in the main data set. ;) And if this is absolutely necessary (for whatever reason): you are using the SQL server, aren't you? Let it do this via a trigger. So in this case we have to be capturing manually because its a requirement for a Tax API otherwise it will give...

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

Well after trying many way , I have come realise that since I need to the entire data in the temporal table , the systex should be like below: DELETE FROM tblItemClassList This can delete the data in SQL server even if it has 350000 lines in less than 5 seconds and that is what I wanted from...