Recent content by aranj

Well I've resolved it in a clumsy way. With a font editor, I rotated an entire font set and saved it as a new font. Then used the StrReverse function to reverse the string content. Hope that helps somebody.

As per other threads, I have tried using the RotateLabel ActiveX Control Ver 2.0 control from www.lebans.com. Specifically http://www.lebans.com/xrotatetext.htm It mostly works for me, but when the fields I want are bound to this control, they are often replaced by the caption and/or are not...

No, I agree too. Belatedly! Is there a way?

Many thanks Matt - works perfectly (without the comma after column name as it gave me a syntax error). Much appreciated - thanks again.

Hi. I have a form with two text boxes, call them FIRSTNO and LASTNO. The user inputs a first and last number into these boxes, and what I want to do is append to table NOS all integers between these two. E.g. user inputs 6 and 11 and I would like table NOS to contain 6 rows, with the first...

Thanks Mark.

I have a form, the view of which is continuous forms. It has information on the left of the screen which the user is expected to manually match to information on the right, based on the suggestion of the underlying query (based on table a and table b) E.g. Client A $200 <button>...

Many thanks Newman, though that should be : WHERE Identicalfield In (Select Identicalfield from secondarytable); Thanks again.

A SELECT works: SELECT * from mastertable INNER JOIN secondarytable ON mastertable.Identicalfield = secondarytable.Identicalfield But none of these do: DELETE FROM mastertable INNER JOIN secondarytable ON mastertable.Identicalfield = secondarytable.Identicalfield **Incorrect syntax near the...

So now I'm doing something along the lines of: SELECT Tag = 1, Parent = NULL, [Record!1!] = NULL, [RecordHeader!2!] = NULL, [RecordHeader!2!HeaderData] = NULL, [RecordHeader!2!HeaderData2] = NULL, [RecordBody!3!] = NULL, [RecordBody!3!BodyData] = NULL, [RecordBody!3!BodyData2] = NULL UNION ALL...

Apologies for the newbie question. I have read and re-read about FOR XML EXPLICIT and now my head hurts! This is the XML I am trying to form from a very simple SQL table: <Record> <RecordHeader> <HeaderData>HeaderStuff</HeaderData> <HeaderData2>HeaderStuff</HeaderData2> </RecordHeader>...

Hi. I’m a complete XML newbie (reading “Sam’s Teach Yourself XML in 21 days” as I type). I have spent days perfecting my database in Access 2000. I now have to export a simple "end result" table to XML using a schema that has been provided. (All the hard work is done appending data to this...

Ah, I have seen this: http://support.microsoft.com/?kbid=207636 Hope this may help anyone else with the same trouble.

I have a very simple query that produces results: Name WeekEnding CountOfWeekEnding ABC 01/05/2005 4 ABC 08/05/2005 2 ABC 15/05/2005 1 (name comes from a drop down box, so only one name in the query) All I want from Access 2000 is a simple bar chart: 4...

Hi. I regularly import tables with many fields from a third party application into Access 2000. These fields all have captions as well as field names (obviously!) but I give them much more meaningful "friendly" names. But to do this I must first manually delete all the captions. Is there an...