Search results for query: *

Hi, I've developed a database with lots of tables and forms. I've defined a security schema with several groups and access rights per group. Now I've split the database with the Splitter tool, and I see the .mdb with the data has no security defined. What is the easiest way to maintain the...

Hi, I'm recently started with programming graphics in MS Access (2000) using MSChart. Now I use MS Chart Control 6.0 (SP4). As such it works and I'm able to make several graphics. But in the layout I've some problems: - when X-axis lables rotate and are displayed vertically, the font is very...

Hi, I've a form with a graphic (MSChart) and there beneath a subform with comments. All OK. However, when I want to print the form and call a print preview, the font of the subform has become very large and page fit is all away. Now when I move the subform to the upper of the form, and the...

Hi, Does anyone know an elegant method to compute someones birthday from his date-of-birth (given in a TDateTime)? I'm able to decode the year from a given TDateTime, but I don't see how to set the year. thx Henk

Hi, Has anyone experience with XML Data Binding? I want to manipulate a xml-file MyData.xml. Therefore I've used the XML Data Binding tool which has created a component with function _di_IXMLMyDataRootType __fastcall LoadMyDataRoot(const WideString FileName); When I call this function...

Hi, How can I find in VBA for Access the name of the .mdb file I'm working in? Thanks Henk

Hi, Is it possible to wrap lines in the column headings of a ms-access form in Datasheet View? The text in the heading appears to be the Name property of the textbox in the design grid. If this text is somewhat long, not all text is displayed in Datasheet View (I do not want to drag the...

Hi, I've created a form in MSaccess with underlying query e.g. select a, b, c, d from table1. Now when I run the form in Datasheet View the columns appear in a different order, e.g. a, c, d, b. How can I change the order of columns in this view? Thanks for help Henk

Hi, I've the following problem: I've a word template and a set of documents based on that template. When the template is updated (same name and location), the documents are connected with the the new template, but are based on the elder version of the template. I would like to recognise that...

Hi, I've a table with a blob field and want to insert the records into another table with: insert into T1withBlob select * from T2withBlob But causes error: "attempted update of read-only column" What can I do? Thanks for help Henk

Hi, I've a form in MS-Access that opens with the vertical scroll position not on top of the form. What can I do to make scroll position on top when I start the form? Thanks for help Henk

Hi, I've hidden a toolbar button manually (Word 2000). Now I want to make it visible with VBA. I have already som code: For Each ctl In CommandBars("formatting").Controls If ctl.caption = strCaption Then ctl.visible = visible End If Next ctl But it appears the...

Hi, I've an Access db with a table that records the state of an electricity meter on successive moments, say every last day of month. Now I want to compute the electricity use over the months. In order to do that I have to sort the records by date and loop through the table and compute for each...

Hi, I have a column in an Excel sheet in which I'd like to constrain the values the user can input, like a choice from values in a combobox. How can I do that? Thanks for suggestions, Henk

Hello, I have in a Word template an Auto_New macro, which fires when creating a new doc based on that template. Is there a similar macro for a PowerPoint template? Auto_New seems not to work. Thanks Henk

Hi, I would like to create and start an Excel worksheet (.xls), based on a template (.xlt), from a word document. When I create simply a link to the .xlt in my document, it opens the .xlt instead of creating a .xls based on the .xlt. Thanks for suggestions, Henk Stijnen

Hi, I have defined some autotext entries: when I type some text, the autotext entry is showing, and when I hit Enter the entry is inserted in the document. Now I have created a KeyBinding for the Enter key: when the Enter key is hit, a specific macro is executed. My question is: how can I...

Hi, I've a strange problem. I've in my Normal.dot a Document_Open() macro which can raise a message. Now I've a document which contains some table fault and therefore opens with an error message. This situation causes Word to crash (stack overflow). Apparently the two messages cannot go...

Hi, I've a workbook with different detail worksheets and one for aggregating. In the aggregate sheet I want to compute a total of some variable which exists on every detail sheet, but not in the same address (row, col). I've taken the following approach: I've devloped a Function Total() in...

Hi, Is it possible to detect the format of the data in the windows clipboard? I want to intercept the ctrl-V (Paste) in order to different processing of text, table, figure,... etc. Any suggestions? Henk