Search results

  1. Q

    keep default in drop down

    bump .....
  2. Q

    SQL query in code over 100 lines long

    Hi I have a complex SQL query, which I need to put into my DB in some VBA code so that it can be dynamically changed. As far as I know, Access does not have anything like stored procedures, which would have made this easier. I'm planning to use this SQL query as the record source of a form but...
  3. Q

    DB runs slow over network

    I think using terminal server will be beyond most of the users. I think moving everything into queries will help but not sure.... Any ideas?
  4. Q

    sum calculated boxes from Detail section

    At the moment, it's just an expression, which queries the DB and returns the total. What I would like to do is make all the textboxes query based and then I think it will be easy as I can just put in the query field, e.g. Sum([SQLQueryField]) ?
  5. Q

    query runs slowly as soon as I add a join

    The join structure here is a little different to what I'm used to in SQL Server. For some reason, Access adds brackets round everything. When I run this, it's lightning fast: SELECT IIf(Len([Company Code])=2,"00" & [Company Code],[Company Code]) AS Expr1, ((Sum([1To90])+Sum([Not...
  6. Q

    DB runs slow over network

    It's still very slow. I think each of the calculated control boxes must make a call to the DB to retrieve it's information. It then moves onto the next control box and requeries the DB again. I'm sure it has to do with this because I have a subform, which only gets data from a SQL query and that...
  7. Q

    Update with JOIN but only on Top 1 ?

    bump .....
  8. Q

    sum calculated boxes from Detail section

    Hi The textbox is 1 box in the Detail section, which becomes about 10 boxes when you load it up so I can only ever give it one name. For example, see the attached JPG. So in the totals section, I need to sum the Detail section textbox above it but Access doesn't like it when I put in...
  9. Q

    DB runs slow over network

    Do you think all the control boxes could be causing the problem or is it more likely to be one of the issues on that link ?
  10. Q

    DB runs slow over network

    Thanks, I'll have a look through that. It's not just that though, I have the DB set to compact every time someone closes it and this is taking ages, whereas on my local machine it takes a few seconds. I have to compact it otherwise, the DB will grow too big. ANy thoughts ?
  11. Q

    sum calculated boxes from Detail section

    Hi Got a form with a Detail section that can have any number of textboxes in it depending on the data a query brings back: e.g. QueryID Calculatedtextbox QueryID Calculatedtextbox QueryID Calculatedtextbox QueryID Calculatedtextbox The Calculatedtextbox has a DSum function...
  12. Q

    Update with JOIN but only on Top 1 ?

    I'm trying to update a table via a join with the current query: UPDATE zarageddebt_CURR INNER JOIN baddebt_CURR ON baddebt_CURR.DocNo = zarageddebt_CURR.DocNo SET zarageddebt_CURR.[Bad Debt] = baddebt_CURR.[Bad Debt]; Unfortunately, I have just discovered that the relationship is not always 1...
  13. Q

    DB runs slow over network

    I have a 16Mb DB. The intention is for users to access this over the network without copying onto their local machines. At present, many of the forms are located on 1 master form and they are all subforms on tabs. There are a lot of calculated control boxes on the forms, and these seem to be...
  14. Q

    #Error! is only displayed sometimes on calculated textbox

    ANyone know of a way to refresh the form to correct all these #Error boxes ?
  15. Q

    excel stays in task manager ?!

    Found the problem: http://www.tushar-mehta.com/excel/vba/xl_doesnt_quit/
  16. Q

    using vba from Access to change Excel worksheet

    It's okay. It's this: .Range("C25:C27").AutoFill Destination:=Range("C25:F27"), Type:=xlFillDefault changed to: .Range("C25:C27").AutoFill Destination:=xlWB.Sheets(1).Range("C25:F27"), Type:=xlFillDefault
  17. Q

    using vba from Access to change Excel worksheet

    Thanks for that. I have tidied up the code. However, as suggested I am now having problems with getting Excel to quit. If I close down Excel manually from Excel, it still stays in the taskbar. I cannot find any global references in the code...unless I'm misunderstanding the scope. Any ideas...
  18. Q

    excel stays in task manager ?!

    I have an export function on a form, which exports relevant data to an Excel file. Unfortunately, when I close down Excel, the excel.exe still stays running in the background. This means I can only use the sub/command button once. I set all references to Nothing in the code but cannot work out...
  19. Q

    using vba from Access to change Excel worksheet

    Hi I create an Excel workbook from Access and this contains some exported data. I am then trying to change various cells in the worksheet so that it is essentially a finished product. I am doing this by recording a macro and then using some of that code in Access. This is Access 2003 and Excel...
  20. Q

    trouble with VBA between Access and Excel

    Thanks. WHat I'm trying to get at is why the Excel macro code is not recognised. The Excel macro code should be correct no matter what and should be recognised by Access immediately shouldn't it? Therefore worksheet.ActiveCell.FormulaR1C1 = "1" should work directly without me having to edit it...
Back
Top Bottom