Search results for query: *

Hi Combo again and kjv1611, If you don't mind I'll answer both your questions and suggestions in the one post. The code that's highlighted is "[highlight #FCE94F]Private sub cboHospital-change()[/highlight]", this event leads to other controls being populated with the existing data for the...

Hi Combo, Thank you for your response, I have been trying to find what is 'firing' the event but I'm not sure it is firing. The error message is a compile error and with no linked cells for any of the controls and no events associated with the workbook closing I am baffled. Why the workbook...

Hi, Apologies if this has been answered somewhere but the only other instance of this question I found had no responses, I'm hoping to be more lucky! I have a workbook with several Active X controls on one sheet, if I close the workbook there is no problem but closing Excel (if there are no...

Hi Missinglinq Thanks for those tips and pointers, esp. the Rice Wine! I shall set too - it's not needed 'til 1st November!! Ken

Hi, I have an Access application that I need to convert to work in Japanese and English (ie on start up select your language). Furthermore it needs to run on both Japanese and English spec. computers. The application contains a large amount of vba, forms/subforms etc as you would expect, and...

Hi CautionMP, I guessed it would be simple, I had referenced the Excel object library but your solution works perfectly. Many thanks, Ken

I am generating a chart in Excel from Access, all of which is working fine. My client has requested that the bar charts be two colour fill and this is causing me problems, debugging the code gives "variable not defined" for 'msogradienthorizontal'. Any guidance gratefully received :) relevent...

Hi Gerry, I take your point about the vba forum - I've always stuck the Access fora before but I'm trying to troubleshoot some Excel work for a colleague. There is a lot of code behind this form and I cannot isolate the problematic area, if I could I would post some. To elaborate: this is a...

Hi Excel 2000/Office 2000Pro I have a user form that displays customer information according to the selection in a combo box. Then there are three more combo boxes used to update certain information on the customer. This apparently works perfectly well for the first customer, and I can select...

Hi Zameer, Thanks for the reply, ldb file had gone. I have no idea how they created this problem but we do have a back up from earlier in the day. A lot of new data had been entered hence the desire to rescue it if possible. Ken

Hi, I have an application used by 4 people on a network. This morning it cannot be opened and gives the message "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." Is there any way I can break into this...

Ken, That's exactly what I needed. Many thanks and have a star :) Ken

Hi, Struggling with this one for hours... Excel 2000/Access 2000/Windows 2000 Running Excel from Access I'm adding a chart and need it to be within an existing sheet so: with xlsApp.application <code working> .Charts.Add .ActiveChart.Location Where:=xlLocationAsObject, "Event Chart" <code...

Hi, I have an application that allows the user to create several other applications each with a subset of the data from the first. I have succeeded in setting the necessary start up options and properties for each of these but only by having an AutoExec macro that calls the code. Thus only on...

Hi, I have a subform that contains a column of text boxes used for entering scores copied in from a paper form - the access form is intended to mirror the paper form. The subform disappears off the bottom of the screen and it would be really nice if it scrolled up as the user tabbed down the...

Hi, Using Office 2000 I need to add a text box to an Excel chart, code running in Access but all I get is the &quot;Object doesn't support this property or method&quot; error. Code is: With xlsApp.Application <working code> .ActiveChart.Shapes.AddTextbox(xmsoTextOrientationHorizontal...

thanks both of you. minimising the window then clearing the variable worked just fine. MinusM's solution is well worth noting as most of my customers need reports exported to Excel for manipulation so I shall undoubtably use it. Regards, Ken

Hi, No doubt this is simple but I haven't managed it yet :( Using Office 2000: I have an application that 1) Opens a browse window for the user to select an XLS spreadsheet 2) Opens the spreadsheet and cleans some data 3) Saves and closes the spreadsheet 4) Imports the spreadsheet to an...

Hi Ken, yes, I have compiled the code and the subforms aren't query based - they track documents through a long approval process and are all from the same table. I have thrown away my work and rebuilt it again and still get the same issue, even commenting out what little extra code I have added...

Hi I have a form with tab controls and 6 subforms (1 per tab). This is a development from an earlier version of this app in which this form has 5 tabs/subforms and has been working happily for some months. Opening the form from the switchboard opens it, but does not load the subforms. Double...