Search results

After posting this, I removed the on error resume next...it then whinges on the wsSheet.Close statement. Apparently WorkSheets don't support 'Close'!!! wtf??? Ok it doesn't, according to this: Office Dev Site But removing that didn't help :(

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?

It's not null though! But I did try that earlier. It still complains cmb_audittype has no value, and I guess null is a kind of value.

Anybody else got some ideas?

Both return the error "You entered an expression that has no value", error 2427.

mmm, I can do, but without the pages of initialisation code and the form design its not going to make a lot of sense! Which is why I was looking for the more general case. Select Case Cmb_AuditType Is the line that fails. The combo box is filled with a fixed query, so it has data, though at...

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

I'd have thought going down the web front end route would be the easiest. Rather than any kind of syncing. Esp with the iPad's fairly competent browser you'd likely get away with a single site for both desktop users and the iPad. Just a thought what about SharePoint? If you've got a 2010...

Needs a bit of tidying but got this: On Error Resume Next Dim db As DATABASE Dim doc As Document Dim a As Form Dim c As Control Dim p As Property Dim x As Integer Set db = CurrentDb For Each doc In db.Containers("Forms").Documents DoCmd.OpenForm doc.Name, acHidden Set a =...

Needs a bit of tidying but got this: On Error Resume Next Dim db As DATABASE Dim doc As Document Dim a As Form Dim c As Control Dim p As Property Dim x As Integer Set db = CurrentDb For Each doc In db.Containers("Forms").Documents DoCmd.OpenForm doc.Name, acHidden Set a =...

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.

Cept NT, or any install not in C:\Windows! :)

In my previous job that approach was what we used. However we don't need word and excel, so a full office 97 install isn't applicable. We just need enough so that all features of Access 97 work on a XP OS with Office 2003. I think that copying the ISAM dll's and registering them, might be it...

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

the execass function will work whatever windows! (well it will if the pc still has help associations setup...which 99% will do)

lots of hunting on the net basically!

I've got the code running the package ok, it was installing the components needed for it to run. Eventually I've found this: To install client tools only for SQL Server 2000 1. Insert the Microsoft® SQL Server™ 2000 compact disc in your CD-ROM drive. If the compact disc does not autorun...