Search results for query: *

Hi all, I have an A97 application which uses MS SQL Server 2000 as the back end database. This has been running sucessfully for a number of years. I'm having a problem with one record in one table. Every time I edit it in the application I get the "Write Conflict - ... another user has changed...

Hi all, I have a input text box used for dates. If a date is typed I have some Javascript validation on it. I also have a button which opens a Javascript calendar in order to pick a date and populate my text box. However, by definition onChange does not recognise this as a change (it only picks...

Hi all. This is a recurring porblem on this forum and the MS Access Modules forum, but I have not found a solution in any threads yet. I have an A97 db which exports a table to an Excel file on the user's desktop. The program checks whether the file exists, deletes it if so, and then saves a...

Hi, I am developing an application which access an MS SQL Server 2000 databse through the MS JDBC driver. My web app is in Tomcat V5.028 on my development PC and 5.025 on the production server. All is working fine on my development PC so I'm relatively confident that my coding is working, but...

Apologies in advance - I'm new to JSPs and struggling with some basic issues. My present problem is that I need to build a url. This will be of the format: /somepage?param1=p1&param2=p2. p1 and p2 are stored in a database rowset, lets call them ${row.p1} and ${row.p2}. I need to create a...

Hi, Can anyone tell me if there is a limit on the number of files or sub-directories allowed in a folder in windows? Thanks, Aidan.

Hi all. I'm new to Tomcat. I have Tomcat V5.0 running on Win 2K Pro on 2 seperate PCs for development purposes. Originally I put my JNDI, JDBC and security realm details for my application in /conf/server.xml as per the documentation. Subsecquently I found the Administration Tool, and made...

Hi. I have a TreeView control V6 in A97 on a Win 2K PC showing an organisation structure. It works fine on my PC and most others, but doesn't display correctly on a small number of others. The MSCOMCTL.OCX file is on all PCs. The symtoms on the problem PCs are that the org structure is...

I have a SQL Server 2000 stored procedure for sending e-mails which I call from an A97 front end. My problem is that it works on some PCs, but fails on others. It fails in Access - not SQL Server, so I am posting in this forum. The code is as follows: Dim wsp As Workspace Dim qdf As QueryDef...

Hi, I'm new to ABAP and have a problem with a spec. In MIRO, I need to default the Baseline Date to a different value than normal. My customer wants the change added to a suitable User Exit. I have been unable to find a suitable user exit to date. Can anyone give me any suggestions as to how I...

Hi all, I have an Access 97 db which has to upload some data from various Excel 2000 workbooks running on Win 2K. I have some code which opens an instance of Excel (I have the Excel 9.0 object library referenced), opens various recordsets, does some transfer of data, closes all the recordsets...

Hi all, I have about 150 reports to which I need to add a simple bit of code to the OnOpen event. Is there a way to add a piece of VBA to the OnOpen Event through VBA? In VBA, I can loop through all the reports and open each in design view. If I could add the code in this loop it would be so...

Hi all, I have Win 98 on my home PC with IE6 and Norton Internet Security. Recently some spyware got onto my PC, changed my home page and disabled my access to the part of IE's Tools->Options which allows the home page to be changed. I tried to fix this through RegEdit, but got a message...

Hi, I have an irritating problem with the VBA editor. Normally, as you type, the editor will pick up problems with your code and highlight them in red after you move to a new line. My editor is currently checking my spelling etc. far too quickly. I can be half way through typing a word and it...

Hi all, Is there any way to tell how big the various ojects within a database are? For example, if a db is 20MB, how much of this is made up from each table, query, form, report, macro, or module?. Reason for asking is that I have a 24MB (compacted) front end database with linked tables (no...

Recently I have had two versions of a database running at the same time (basically one was a mirror of the other). However, the mdw files were not being mirrored (and should have been). I therefore have two different mdw files for the same database, both of which have most users, but each of...

Hi all, In Excel 2000 I have a number of VB routines linked to buttons on a custom button bar. These are only relevant if a workbook is open and active. I can add an error routine to these so that I don't get ugly errors occuring when I 'm using Excel. How can I disable these buttons if no...

Hi all, I am getting the above error message on a number of PCs when running queries. Everything works fine on my PC and many more, but occurs on a number of users PCs. The functions which are not recognised are usually LEFT(), RIGHT(), FORMAT(), DATE() etc. I know this is a problem with...

Today has not been a good day ! ! When I click on a button, any button, on a form, I am getting error message as below: The expression On Click you entered as the event property setting produced the following error: Invalid outside procedure. *The expression may not result in the name of a...

Hi all, I need to be able to reference a form in VBA. The form may be different depending on user selections. I want to be able to set a variable to reference the appropriate form. The code is in a module, the form name being passed in as an attribute, stFrm. I can use DoCmd.OpenForm...