Search results for query: *

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

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

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

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

Hi, I am using filter by form but have a problem with the date field; manually I can type &quot;between #01/01/03# and #30/07/03#&quot; and it works as I would want it to, however I need to make it easier for the user to enter date criteria and have created a form so they simply choose the...

Hi, Am close to tearing my hair out on this one... I am using MichealRed's deltadays function to establish the order in which 3 depts reviewed a document after the Originator released it, the release dates and thus deltadays is held in tbl_DDays. I then need to establish deltadays for each...

Hi, I have a replicating app (Access 2000) that has been working fine for ages. Yesterday added code to allow automatic import of names from an excel spreadsheet and then imported some. the databases had been synchronised before the additional work but now I have the error &quot;Record too...

Hi I have an application that generates reports in Excel. I would like to add cover sheets with a logo to these reports - is there a way I can save the logo within the application for this or will I have to reference an external file? Thanks in advance Ken

Hi, I have a client who seems to update their staff's laptops on an ad hoc basis. This leads to reference library problems when some of them copy an application to their laptop from the network and take it away - network has Access 2002, many of the laptops are still on Access 2000 and so do not...

Hi, I am using FollowHyperLink to open a .hlp file but get the &quot;some files contain viruses...it is important to be certain...&quot; dialogue box popping up - can I override this one at all? Many thanks, Ken

Hi, This must be easy - I have made a .hlp file for an application but cannot associate it with the database. This database is a stand alone application and all I need is for it to recognise the hlp file, either to access it from the Help menu or from a button on the switchboard. Thanks for your...