Search results for query: *

You can change the alignment of axis labels on both horizontal (category) and vertical (value) axes. But when you have multiple-level category labels in your chart, you can only change the alignment of one level of labels. How can you change the alignment of them all. Help!

"If you expect to receive different flat file documents on the same receive location, you typically include several flat file disassemblers in the receive pipeline, one for each schema" This is mentioned in the SDK (for the schema resolver). Does anyone have a sample implementing the IProbe...

Hi I'm using the BeforeUpdate event to validate data (catch nulls). This works fine unless a user happens to enter data and then delete it. Error 2108 generated. Can someone explain what is happening? Thanks in advance Stewart -------------------- Private Sub txtControl_BeforeUpdate(Cancel...

Hi I have a page that contains a OWC chart and pivot table that pulls data from MS SQL using a stored procedure that works correctly on most machines. On some machine it generates an error: The PivotTable list "PivotTable" could not connect to the data source "". For information...

I have an old machine (1983) which is just a box that spits out a printout everyday. I want to capture the data that is sent and store this as a file on a 'normal' computer. Is there any way I can connect this old machine using the printer cable? Thanks for any help in advance. Stew

Hi All My case is quite simple. Raw material is turned into a finished product. This could then be stored (or not) and at a later date (or the same day) be processed into a further finished products. The db will have to describe the entire production path and packaging and finally show stocks...

Hi All Have a homegrown system with lots of nice components which worked fine for a number of months. However, it has developed serious instability issues – which make the system unusable. With a certain degree of certainty the computer crashes with a blue screen and reboots. This doesn’t...

Hi All I have spent quite a few years working with Access, VB and numerous other tools - but almost always working on internal projects usually for large companies churning through huge quantities of data. Presentation has never been an issue - nor has distribution. Now, a change of situation...

Hi All I have a form with a series of subreports. Everything works fine - but a foreign key field will generate an error - which is correct and valid - but I would like to change its content to something that the users understand! This is generated when a component is added in the component...

Hi All As an simple example, I have a number of suppliers who all supply products which may be a full or a subset of all products. In order to find the cheapest possible method of supply - I am using a cartesian product (which works very well) but would like to explore other alternatives (for...

Hi all Have a Access 97 frontend on win XP that fails to copy and paste data. This isn't an issue of data type etc as this fe had no problems on Win 98. The copy function seems to work - but the paste function simply does nothing (no errors). Interestingly, when trying to paste the data into...

Hi All I used to have one computer downloading emails from an ISP into Outlook Express on win98. Now I have a second computer that needs access to the same emails. What is the best way of sharing these mails? Looking for a simple solution. Thanks in advance. Stew

Hi All Tried converting a 97 db to 2000. After solving all the usual problems (DAO, corrupt VB etc) the front end is fine - except it is really slow. Just clicking on a button to open another form is taking much longer than expected. All object have been imported into the new db. What else...

Hi All After working with a db certain for ages - I have now had to start to make some substantial changes to the entire db - changing table structure and of course relationships. The db is split (front-end and backend) - but I have a question regarding the relationships of these two dbs. I...

Hi All My first shot at ASP so go easy on me here. This is a bit over my head but here goes. First, a stored procedure that should indicate whether something is true or false. CREATE PROCEDURE XAA_in_PROF @XAA nvarchar(6), @PEL_PROF nvarchar(4), @Result INT OUTPUT AS IF (Some SQL) >0...

Hi all This must be easy Product return volatility D 2% 1% A 10% 3% B 11% 10% C 30% 15% With this data I want to plot return against volatility (like a scatter diagram) and have the points labelled with the product name. Couldn’t be easier - but how?? If possible to draw 'through' these...

Hi All This must be real easy. I want to double click on a record in a subform datasheet and have the view change from datasheet to form view. This is just a normal right click operation - but I can figure out how to code it. Help. Stew

Hi All Still a newbie to SQL Server. Want to start scheduling items in DTS and it seems very easy. Right click and choose your options. But I have a nasty looking error: "Blah Blah Cannot perform this operation while sqlserveragent is starting. Try again later." Try again later -...

Hi All You can have stripy worksheets by using conditional formatting. As the condition will be based on row numbers - it isn't effected by row deletions. Select the area to 'make stripy'. FORMAT|CONDITIONAL FORMATTING... Change 'cell value' is to 'formula is' Enter the formula...

Hi All Need to find ******* in a worksheet. How? Stew "Even a stopped clock tells the right time twice a day."