Search results for query: *

No. It needs to get counted twice (connected to different procedures with different dates - not relevant for this problem).

For a column chart type in Excel 2010, I have quaitity as values for the Y axis and for the X axis, I have Month as one category and Priority as a second category. The Priority label is not the primary category and I am unable to align this vertically. So the chart is just counting the...

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!

You can use a custom pipeline and the Flat File Disassembler component where messages are parsed using header, trailer, and body schemas. Use the Flat File Schema Wizard to create schemas. Stew

FYI I found the Pipeline Component Wizard written (by Martijn Hoogendoorn) excellent: http://www.gotdotnet.com/Workspaces/Workspace.aspx?id=1d4f7d6b-7d27-4f05-a8ee-48cfcd5abf4a

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

Hi Hamzagm This seems like an overkill to me. Access has the escape button which (in effect) performs these operations (hit once|twice to undo field|record changes). If this really doesn't suffice, look into RunCommand|Undo in macros. If you want to be really professional - look into...

Hi KenReay - it really is that simple. I would never hope to start from scratch and develop an entire ERP/MRP/??P system. From 3 different raw materials we can produce a set number of products in a set number of production stages. For the traceability issue - all information was going to be...

Hi Ed You’re one step ahead of me. I suspected that something like DirectParallel cable access or a serial converter would be fine (I have never had to do this before). The world of cabling looks like a bit of a nightmare - but I will check it out. Once I get that far I will quiz you on the...

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 Ken Thanks for the reply - it sounds as though you have done this kind of thing before. To answer your question, I think the answer is: Quantities will be processed in batches that need to be tracked. To give an example: The raw material A (of quantity x) will be processed into 3 final...

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 Sorrells Thanks for the speedy reply. I really do know what you mean about the dearth of information on internationalisation issues. Tempted to move to Java yet? I found a suitable solution for my problem - although far from perfect. Simply by changing the settings in Windows XP...

Hi Sorrells Check out 'Dr. International' on MS web site. I have contacted this department in the past and they put an awful lot of effort into my 'internationalization' problems. Well worth getting touch. This is all the advice I can give, but you might be able to help me. I had thought that...

Bit late - but anyway. With a reference to the Excel object Library you could use: Excel.WorksheetFunction.Text(yourData, "# ??/??") from within access. Very clean

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 Djbell Sounds like you're doing things the hard way. Why not have two queries - one append query and one delete query - linked to a button to do the same thing? Stew

Hi Skyshadow5 I now have a headache. Are you saying you want to combine the two subqueries? 1. Actual spend for the year 2. budget info the year If your not getting the data you expect, I would have thought that your joins are bad - or the data is bad - or not structured the way you think it...