Search results

I am thinking of archiving because my client is complaining of too slow operation even after I index all the tables in the application. I am also thinking of inserting into new table because data will be pulled from 3 tables to update and record keeping at various times not at the same time...

I am actually fetching the data from 3 tables, that's why I am using MyQuery as source and I want to insert into one almighty table for achieving and other reasons

Hi, I am just trying out something here. Although I have gone thru various post concerning this question, but I haven't seen the exact one that fits into my criteria. I want RecordSet that Insert The Following Fields from a query (MyQuery) into a new table (MyTable) MyQuery feilds are TransID...

Well here is the SQL statement which is also the row source for my form: SELECT tblOutbound.ItemID, tblItem.ItemName, tblItem.QtyAvail, tblItem.UnitSale, tblOutbound.ExtendedPrice, tblOutbound.QtyOut, tblOutbound.DateOut, tblOutbound.ClientID, tblClient.ClientAcc, tblOutbound.InvoiceNo...

Hi please can someone help me out on this code? Dim Db As Database Dim RS As Recordset Set Db = CurrentDb Set RS = Db.OpenRecordset("SalesQRY", dbOpenDynaset, dbSeeChanges) With RS ' Modify data in local recordset. Do While RS.EOF .Edit If RS <> Forms!frmPoS!Invoice Then...

Okay thank you all soooooo Muuuuuuuch. I will go to the client office and try it out for her. Then I'll get back to when I am thru with her later. Thanks a million

It's a split Application. I checked the record Locking is Shared not Exclusive

Yes, it's a shared app. Each user has a copy of the FE. They are only collaborating at the Back-End (BE), I mean one table sets (DB)

Hi, Please I just bug into this problem on my small access application being used by 2 individuals using the same shared Application on a network. The puzzle is when both of them update the same item in a one table, one freezes while the other may scale through. My request here is any code that...

here is my attachment for your view and possible assistance

Thank you for quick response to my puzzle. I think the context I am looking at is app that works on touch-smart PC and Laptops. I mean a situation where you open the app and you are greeted with most of the Items you have in the DB pop-up in a grid-like boxes and all you need do order any of...

Hi, I just want to find out if it is possible to have items (any product) display within a form in a grid-like boxes as in 4 or more in a row and 10 or more columns? I will greatly appreciate if anyone can find a way out for me in this regard. Thanks, John Moore

Ok, assuming the query is opened in locked/exclusive mode, how do I get change it permanently for the 2 or more users to use the same query simultaneously? I will try and paste the sample query here for all to view and comment

It's not code that I am using, but query. What I am looking for now is VBA that update and while one is updating, the second should wait until the first has finished updating

Hi, can someone provide me with VBA code to update multiple tables on a split backend. There are 2 or 3 system interconnected to the same backend and my puzzle is when 2 systems are updating the same Item, one will freeze while the other will update successfully I have been using queries to...

Hi all, can someone here give me sample VBA code to UPDATE Multiple tables/Querries at the same time from one FORM? I have the following code which I don't know the reason why it is not working after series of trials: Private Sub cmdSales_Click() On Error Resume Next Dim SQL As String Dim SQL2...

Thank you all who contributed immensely to my question. After series of suggestions and advice from this house, I have resolve to use just 32-bits access application and it worked perfectly I learned from this research that there's difference between 32 and 64-bits even of the same access 2016...

Thanks, I think this will work for me. Thank you so much

Thank you all for your quick and reliable responses. My next puzzle is where do I insert or edit in this code to be 64bit and backward compartible as the examples given where all running incomplete statements with ... ends Please edit this my code and let me see the typical example here. Thanks...

Hi please how can I resolve this issue? "Compiler error" The code in this project must be updated for use on 64-bit systems. Please review and update Declare Statements and then mark them with the PtrSafe attribute...