Recent content by Corsica

Hello, I'm wanting to copy, paste and rename a file from within a module. I don't know whether or not this can be done. Any help would be much appreciated. - If this can be done, then any pointers regarding how....please :) Thanks, Corsica

Thanx, PH! - Have just looked at the tips that the hyperlinks took me to. Will look for Application.CreateControl in the VBA help files a bit later. CSC

Hi, No, I mean the version of VBA that is part of the Access 2000 environment. - Sorry, should have said this at the outset. I've used Access for years and had never before needed to create and position a series of text boxes in the 'on-load' event of a form... -Corsica

In the 'on_load' event of a form we want to write code that creates and positions a series of text boxes [that will then be seen on the form...] Any ideas etc. would be much appreciated. Corsica

Thanks. I think that I would want to write the required code, and it would add a new level of interest for me, if you get what I mean. But, would you please tell me where you would be placing such code. Would it be 'on_load' or 'on_open' of the form, or somewhere else? Thanks again. Corsica

Hi, I need to show, on the one form, the contents of one column of data, each datum in a text box, that's why I had used 'continuous forms'. I can see that the code above may help me to dynamically set the size of the form, detail section and objects on the form, for example a text box. But I...

Thanks very much! But won't each text box have the same height? Corsica

Thanks Ken, for your helpful replies. The only possible problem with your suggested solution is that then I'll have quite a lot of space between the text strings that are much shorter than the longest one in the set. -Am I thinking along the right lines...? Thanks again. Corsica

In the 'detail' part of one of my forms I have placed one text box. I've set the form property 'default view' to 'continuous forms' and set both the 'detail' and text box properties 'can shrink' & 'can grow' to 'yes'. But when I look at the form in form view I find that the text boxes do not...

Thanks PH. I'll take a look at that. And, to be fair, I can see now that writing 'it does not work' in the question wasn't the best thing. I won't go into the details now as there seems to be no point. But later, if necessary, I'll post another better worded question. Corsica

Thanks for your reply, PHV. Yes, it does not work. No error message. The unexpected result is that....it does not work - despite the fact that the underlying SQL code of cmboStartDate.RowSource was not changed after the file was loaded onto the laptop. I thought that the laptop may not have...

On the 'on change' event on another text box on my form called 'frmWIT2' I have put this line of code: Forms![frmWIT2]![cmboStartDate].Requery The combo box 'cmboStartDate' is requeried as required when I run the database file on my home computer, but when I run it on my laptop it does not...

Thanks nice95gle for your reply. I do have code at the end of each of my modules which closes the database object, but I'll take a look at the task manager next time it happens... CSC

Thanks for this Mike, but I should have said that I'm using Access 2000... CSC

One way is to use a module which opens the query that you've created. Declare a public variable at the top of the module. Then store the relevant name in the public variable. Then, on 'form-load' of any form use the following code: Me.txtName = pubName Where txtName is the name of the...