Search results

Morning, I've writen an access application which when opened hides the access main window leaving just the modal forms. this works fine but if the user click on the "Show Desktop" icon on the task bar all applications are minimised, since my access app is hidden it does not appear on the...

I have a select Query in which i sum one field ID |Location | value | Cat 1 | A | 10 | 23 1 | B | 11 | 24 1 | B | 10 | 34 2 |A | 1 | 37 Using Select [ sum ] From [ ] Group BY [] so far i have the following...

hello all, i've written this query and all was working fine, but.... i added the Where IN statement and no it runs really slow. i have tried using the Where exists option but couldn't get it working. As i understand it this is probably the worst query to run on a jet database as it contains...

i have two select queries that i essentially want to be one, i have tried using a sub selecect query but it doest seems to work , it only shows the main select not the sub select 1 SELECT LNE_P3e_Activities.UID, Sum(Results_Cost_Next_Period_Activities.Planned_Cost) AS ["costing"] FROM...

hi the problem i have is that i cant get the value out of a query without setting/restting the recordset every time. and this takes ages ( about 1 sec but * 10,000 times) i was originally using Dlookup to get the value out of the query but this is even worse! my code is as follows as you can...

i'm trying to append 5 tables into one , but... although the majority of the fields are the same for each table in each tabel there are a few fields not found in the other tables. to add to the problems i dont know what the name s of these additional columns will be, the will change quite...

is ther any way of making a progrss bar that will "Grow" during the import of a text file? the files i'm bringing across are about 30 Mb (over a LAN) so i want the user to know that the import is working. i havent found any way doing this ideas? i did have a thought that it it might be possible...