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

this is part of the code i'm using SELECT DISTINCT PL_Volume_AC_Calculated.Project_ID , PL_Volume_AC_Calculated.UID_Desc, PL_Volume_AC_Calculated.Principal_Contractor, PL_Volume_AC_Calculated.UID, PLBU_ACT.Completion_Units_FY, PLBU_ACT.CurrentBudget_FY FROM PL_Volume_AC_Calculated LEFT JOIN...

sorry i dont exacty follow that

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

well...... i gave it some thought and followed your advice and this is what i came up with Function PLVolumeAnswers(Territory_DD As String) DoCmd.SetWarnings False 'Echo False 'Application.Screen = False Dim myqdf As QueryDef Dim mydate As Date Dim ThisYear As String Dim rstdcalc As...

thanks for the advice, i've had a look into it and i can't really see how to use FindNext, what i'm trying to achieve is: search a table for the sum off three or so values where the record has the correct project id and period number, each project has a possible 13 entries so i'm loopoing...

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

because i'm running a transfertext i don't think i can use that code. is there any way i can get the little acccess progress bar to apear in a form? when i run my forms it hides the access window so that it doen't look like an access database. this means that the status bar is also hidden if i...

yep i'm using transfertext but have had no luck finding a way to measure the amount of data transfered? very annoying because as you point out access seems to do it in the progress bar. i'll keep hunting for an answer there must be a way!

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