Recent content by Kevin Robson

Hi ByteMyzer, Thanks for the one liner - it worked brilliantly. I had previously tried the Workbooks.add, but not got the syntax right. Thank You.

Hi, I have been developing a database that outputs its results into MS Excel. To manage formatting I use the following code to access Excel directly:- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Private Sub BuildExcel() Dim appExcel As Excel.Application Dim...

Thanks for this. I will give it a try and report back. Kevin.

Hi, I have written a small application and hidden the commandbars with the following code (previously found on the web): ------------------------------------------------------------------------------------------------------------------ Public Function DisableCmdBars() Dim cBars As CommandBars...

Thanks RG, Your right it 'is' sort of silly! I will give the ComapactDatabase method a try. Many Thanks

I am struggling with what should be a simple task: I have a working A2K database that uses the following references: Visual Basic For Applications Microsoft Access 9.0 Object Library Microsoft DAO 3.6 Object Library OLE Automation Microsoft Visual Basic for Applications Extensibility 5.3...

Alastair, This is an extract: MyRecordSet.Addnew MyRecordSet.Fields("RefNum") = TmpCostProfile("RefNum") MyRecordSet.Fields("Volume") = TmpCostProfile("Volume") Select Case TmpCostDriver.Fields("Type") Case "Units" MyRecordSet.Fields("Units") = TmpCostProfile ("Units")...

I have a subfom that displays perfectly in datsheet view. One of the columns changes its contents depending on a value. i.e. a list of units or a list of costs. I change the data using a Recordset update. When in the Main Form I am trying to change the column label that appears in the SubForm...

Chris, This works brilliantly, thank you. Re the passing of data between the forms: I use a public string variable to hold the filter specification as it is used by several procedures. My difficulty was getting the procedures to update automatically in the cost model when I exited the Filter...

Thanks for the reply. I am afraid that the result is exactly the same error message.

Help - Calling a form event from another form I am struggling with the following procedure call: I have two forms: 1. Cost Model 2. Filter Criteria I have opened the Filter Critera form from the Cost Model form and defined my search criteria. On closing the Filter Criteria form I want to call...

I am new to Access and I am creating a small programme that puts an incremental bar on the screen showing the progress of a database import. The progress bar works OK when tested with a simple loop to simulate the data import, but I seem unable to get the program to respond to clicking on a...