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

I'll give it a try. For now I use a workaround: put a page-break after the figure. When the form starts on a new page, output is neat.

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

Thanks, Tony! It's a perfect solution. I didn't see EncodeDate under the methods of TDateTime, but now I have it. Cheers, Henk

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

Thanks for the suggestion, Gerry. I'll do it with variables, for I want to handle docs from inside and outside my company different. An outside doc will be based on Normal.dot, and I want to discriminate it from an intern doc on Normal.dot.

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

Thanks, but I'm looking for the VBA code or some other trick...

I've a mainform which contains a tabcontrol with several tabs. On every tab there is a subform. The form opens on the first tab. The uppermost control has focus. This control is rather on top of the window, so that the tabs of the tabcontrol aren't visible. And I have to scroll up to see them...

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

I've clicked the button "More buttons" at the end of the toolbar. This gives a checkbox list of the buttons in the toolbar. Here I've unchecked the button. When I record the reverse action, there is no code in the macro.

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

OK, I like "nice" solutions. How to create an index that increments by one? It's not simply a dataset that grows one record per date. There are several different meters each with a value per date. So the index (in the example above) is like "create index INCREM on meterstand (emeter_code...

Thanks for your help! I've found some code at msdn and now my code is something like Sub BerekenVerbruik() Dim conDatabase As ADODB.Connection Dim rstMstanden As ADODB.Recordset Dim strSQL As String Set conDatabase = CurrentProject.Connection strSQL = "SELECT emeter_code, datum...