Search results

I've got an issue where my late binding between Access 2010 VBA and Excel 2010 is leaving a Excel.exe process behind :( I'm creating the objects via: Dim wbExcel As Object, wsSheet As Object 'Open the workbook, pick the worksheet and open it On Error Resume Next Set wbExcel = GetObject(...

I've never liked using hidden controls to store variables, so I was wondering if I created public property get/let's in the form, can a report reference these instead? If so what's the syntax to use?

I'm attempting a conversion of a Access 97 app to Access 2010. I'm hitting a problem with some of the forms where the Form_Load event is complex and sometimes references controls on the form. 2010 is now complaining that "You entered an expression that has no value", whereas 97 didn't. Firstly...

We've got an old 97 app that used the MSFlexGrid control that we're trying to convert to 2010. Don't seem to able to use OCX's in 2010 at all? Just get 'app doesn't support this ActiveX control'. So wondering what people use now a days? And in case someone has a alternative design idea...

Is it possible to access the internal form design? i.e. can I write something that could list the properties of each item on a form.

Please don't laugh but we're attempting to do an enterprise wide upgrade from NT / office 97 to XP / office 2003, and we're having problems installing Access 97 onto an XP machine with Office 2003 installed. We can get 90% of it working, but its little things like TransferSpreadsheet only...

I've come across an issue with sql server 2000 and I was wondering what the best technique is for dealing with it. I've got a table of rates which the user updates via a gui. These are stored as decimal (38,4) values. I was testing a colleagues piece of code that was using one of these...

We have an Access/SQL Server solution, and the access db builds and runs a dts packadge. (The DTS package object library) We need to deploy this to clients that do not have SQL server (and therefore the DTS components). Does any one have an guide on how we can install the components? We've...

We have an Access/SQL Server solution, and the access db builds and runs a dts packadge. (The DTS package object library) We need to deploy this to clients that do not have SQL server (and therefore the DTS components). Does any one have an guide on how we can install the components? We've...

We have an Access/SQL Server solution, and the access db builds and runs a dts packadge. (The DTS package object library) We need to deploy this to clients that do not have SQL server (and therefore the DTS components). Does any one have an guide on how we can install the components? We've...

I've got some code that generates an excel spreadsheet from scratch. When I run it, it sometimes falls over with the following error message: but, and this is what I don't understand, pressing F5 continues, it then might fall over slightly later but again F5 continues. It doesn't always fall...

I've got the following query: INSERT INTO selFeesSum ( FEE_TYPE, FEE_HOW_PAID, FEE_AMOUNT ) SELECT srcFees.FEE_TYPE, srcFees.FEE_HOW_PAID, srcFees.FEE_AMOUNT FROM selAccounts INNER JOIN srcFees ON (selAccounts.ACCOUNT_NO = srcFees.ACCOUNT_NO) AND (selAccounts.SUBACC_NO = srcFees.SUBACC_NO); If...

Is the following code snippet alright? 'add up int terms iTerms = 0 RateRS.Seek "=", AccsRS!ACCOUNT_NO, AccsRS!SUBACC_NO Do Until RateRS.NoMatch iTerms = iTerms + RateRS!TERM_BAND_LENGTH RateRS.Seek ">", AccsRS!ACCOUNT_NO, AccsRS!SUBACC_NO Loop It's the seek usage...

I've got a model that needs to do a lot of date lookup's on largeish (200k rows) tables, at the moment I load up readonly recordsets and use findfirst, but this is proving very slow. What alternatives are there? Would loading into arrays be an option (worried about memory there). or any other...

Is there a quick way to match a string to a group of strings? ie if "xyz" in ("xyz","zzx", "yyx") then true does that make sense? it would be even better if I could do like matching ie? if "xyz" in ("xy*", "xz*") then true anyone? or do I need to write it?

I'm creating a fairly complicated excel sheet in access vba and I'm finding i'm needing to do some manipulation of the references, enough to make me start think i need to spend time writing a set of functions to make this easier (ie add x columsn to ref, x rows, etc) Before I do that has...

How-to: Checklist display/storage I have a fixed checklist of steps, I want to store which of these steps have been completed. However on the form view I need to see all of the checklist steps. I'll have my tblCheckListSteps and a link table with id's for the main id and which checklist items...

being a bit braindead, I can't remember how to select the first item in a combo box on an access form...I keep going back to normal vb which don't work:(

I've got a simple report listing hours worked, and a sub report listing non chargeable hours. (The reason for the split is because the report should only total the chargeable hours, and the NC stuff has to be obviously seperate) The problem is that if the main report is empty, Access doesn't...

I've got the following code, and its taking a while to run, so I was checking to see if there is anything I can change in the .execute's to help the speed. Or optimize the update queries in anyway, or maybe the tables? The connection is an access 97 database, and on 21000 rows this takes...