Search results

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

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

Okay thanks Minty I missed the key word snapshoot, very correct

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

Thank you for the advice to all contributors

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

Okay thanks , this one has worked IIF(Len(rs!stockreleasing), rs!stockreleasing, Null) This was given by Josef P. Many thanks him and all the contributors. Regards Chris