Search results

bump .....

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

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?

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]) ?

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

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

bump .....

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

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 ?

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 ?

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

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

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

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

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

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

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

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

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

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