Recent content by scratch

i created a local table called item_price_link with the same fields as item_price so now the query is this INSERT INTO item_price_link ( item_id, price, store_id ) SELECT id, iif(cdbl(price) < cdbl(bminprice), bminprice, price), 1 FROM [SELECT id, round(iif(calc_price < bCost * (1 +...

i'm using this insert into item_price select * from item_price_link item_price_link has the fields as item_price and are all the records i need to insesrt. nothing fancy there but it's still slow. item_price is the only mysql table

i changed it so the select goes into a local table and then the new query is insert into item_price select * from item_price_link it's not a complicated query now at all but it's still slow

below is the sql the query is using INSERT INTO item_price ( item_id, price, store_id ) SELECT id, iif(cdbl(price) < cdbl(bminprice), bminprice, price), 1 FROM [SELECT id, round(iif(calc_price < bCost * (1 + STORE_min_markup), bCost * (1 + STORE_min_markup), Iif(calc_price > bCost * (1 +...

I'm trying to insert into an odbc linked table on mysql. If the whole thing is local and access based, the insert is fast. When i try to use a linked table, it takes 15 minutes. Any way to speed this up?

According to Microsoft: "You can greatly enhance performance when opening the main database ... by forcing the linked database to remain open: ... create an empty table in the linked database, link the table in the main database, then use the OpenRecordset method to open the linked table. This...

anyway to either update the records on the web from the local table or transfer the table would do as long as it's fairly quick

I need to have a user edit records locally since the web based forms are lacking some features that the datagrid views in access have. The problem is linked tables are too slow. Pass through queries work great for speed but i don't know of a way of inserting a local table to mysql one. I'd...

I've imported somebody's access db which hides the database window by default. When I click the db window button in the toolbar, the db window pops up high up and is somewhat hidden by the toolbar. I can't pull it back down as the top is hidden and when I try to move the toolbar,the db window...

Hello, I know that using vba you can get a style to be added to an automated word doc like wdApp.Selection.Style = .ActiveDocument.Styles("Title") There seems to be a few variations on how to do it but that does work. The problem is that I need to do a few styles at once like "Title +...

looks like a global variable worked nicely in this case...

Hello, I know that you can pass information to a report with openargs but what about when your instantiating a new report like Dim rpt As New Report Set rpt = New Report_rptClinicalInfoForStudent Is there any way to pass a variable to it? I've tried a few ways and no luck. Thanks, scratch

Hello, I have a form that has 2 subforms on it. On one of the subforms, there's a check box that I want deactivated. It's meant to be a "read only" type thing. I've had the Enabled and Locked property set to "yes" and "no" in all comibnations but it still gets checked if you check it (though...

Hi All, For some strange reason, a replica db is being created along side the original. I don't believe it's a back up since the name back_up usually appears in the file name. I've seen it happen once when the proper mdb file was opened and then noticed the new db was created (always called...

not sure how i did it but when i open an access db there's nothing there but the grey background. I managed to find the forms by right clicking on the access logo on the top left of the window and selecting restore. How I can i get it back to normal. scratch