Recent content by AJN2004

You probably need to reference the Microsoft VB Printer Dialog(PSS) (vbPrnDlg.dll)

Are we talking about two seperate forms? If so then lupins46 suggestion is correct. If however we are talking about a main form with a sub form based on the same record set then you should remove the navigation buttons from the form where you don't want to be able to add a new record, ste it's...

I'm not a network specialist, but this sounds as if one or both of the following has occured: 1. Your drive mapping is not the same as it was on the old network; therefore your front end cannot find the tables database and delivers the error message. 2. Due to active directory and the security...

Hello SharonMee! When you design a form in Access it is opened in the single record modus. This means that your form will display one record from your table at a time. You can change to the next record set using either the navigation buttons on the form (Added automatically if you used the...

Another cause could be how you allow you form to deal with data. If for example your form is set to enter data as a property in the properties dialog, then on opening the form a new record in the underlying table is created. Even if you don't enter data on the form, the new record is there with...

Never encountered this one before. A swift resolution would be to manually import all your tables into a new db and then link with the linking assistant. This should work, but doesn't provide an answer as to why the error with the database splitter occurs. Is it possible that you have used the...

Not being sure how you have constructed your query, try this instead of NZ: Iif(IsNull(YourField),0,YourField) When "YourField" is NULL, it takes the value 0, otherwise it stays the same value as it has. hth

You didn't mention which version of Access you're currently using. I assume that you have set the start options for your MDB so that the database window on start is invisible. When this is so then consider the following: Design your start form so that when it loads it is automatically set to...

lupins46 is pretty much correct in what he says with the exception of the installation difficulties. I develop and distribute Access programs myself and have used both the Office XP developer and the newer Access 2003 Developer Extensions. If you set the install path to, let's say...

Just for the record here it is in black & white from MS: PSS ID Number: 248657 Article Last Modified on 5/23/2003 -------------------------------------------------------------------------------- The information in this article applies to: Microsoft Excel 2000 Microsoft PowerPoint 2000...

Thanks for the star, I'm not certain that I deserve it! One point, I do not set the X Axis to negative values. Perhaps I explained badly. The X axis is a time axis that stays constant over a time period that is taken from the underlying table. It is the Y axis that can have negative values. When...

Thanks for your swift reply. I'm using code pretty much the same as yours, which as I said earlier works fine with positive values. The problem with negative values lies in the Chart object itself. To make the reading of the values in the X axis easier to read I slanted them - no probs with...

Here is a function that I used a few years ago, unfortunantly I can't rememeber where I got or who wrote it! Another drawback ist that it calculates for german Holidays, but you could change it yours. Function IstFeiertag( _ Optional ByVal Datum As Variant _ ) As Boolean IstFeiertag =...

In a Program I'm currently developing I have an MS Graph object that is populated out of a query that is built with SQl statements that are fed from a combo box which allows the user to select a category that he/she wishes to see. In my code I establish the maximum and minimum values out of the...

See http://www.tek-tips.com/viewthread.cfm?SQID=847841&SPID=181&page=3