Search results

Thanks Okay, yeah that works. Thanks for your help. Do you know of any good tutorial sites for Access? The advanced kind of stuff that is. I can do the basics but want to learn more about the programming part of it all... Thanks for your help on that code by the way!! Barnz

Hi. I was just curious to whether or not it is possible to group of say text boxes on a form together and then name them as "Text_Box_Group1" and then in Visual Basic try to make the entire group invisible? Thanks!

Similar but not the same... Hi. I want to do something similar, but for when I click on a label. Basically, I already have code that creates a box every time the user performs a certain action. Then I want them to be able to click on any of these and it take either the caption or the name of...

Hi again. Another idea... Is there anyway that there is code for say Me!Controls...<selected>? - to take information from the "selected" control? - and would this work for a label because I'm sure it is actually selected when it's clicked Thanks

I'm sure if it is unspecific enough, or clever enough :) but what about a GotFocus procedure? Don't know if that helps!

Right. I have a button that will create a label on another form, this button will display the name of something etc. I have also set the .OnClick procedure of any newly created label to a macro which opens up a new form. However I want to display information on this form that is revelant to the...

Okay. I put the code from the function straight into the Command Button code, and did have the right way to change the name. So it all works!! Thanks for all your help. If you could still point the in the right direction to learn about functions I'd be really greatful. Cheers

Sorry... another question; Can I change the name of the text box that i create? Thanks

Haha! That's wicked but I've never worked with functions before and although it's probably really simple to run one, I've tried and am having trouble. Can you just give me a quick example of how to run that function from a command button? Thanks very much for your help

Hi again. Sorry this might be a slightly silly question, but... If I want to open up a form, it seems that it already has to be "running" or shown on the screen for example, but it doesn't have to be infocus. How to do I actually Open a form or actually more, Load a form?? At present I am...

Oh!! Stupid me! :) Thanks for that. Can't believe I missed that.Cheers again

Yeh I kinda do need unlimited text boxes. The reason for this would be; I have a make-shift calendar with the dates down one side and for example, house numbers along the top. I need to create a textbox in the space on the calendar where the house is going to be occupied. And then be able to...

Hey. I need to actually create one of different size each time and in different places. Ambitious I know :o Thanks for that though

Code The story so far; I have a form called "Form" and I want to just put a square text box on to the form. Dim frm As Form Dim Box As Control Set frm = "Form" Set Box = CreateControl(frm.Name, acTextBox, , , , 1000, 1000, 1000, 1000) DoCmd.Restore I can't understand why it will not work...

I'm having trouble creating a text box in a form that already exists. I've used the example from the microsoft help thing to create a text box in a new form, but for some reason I haven't been able to edit it to create it to do what I want. :confused: If anyone has done this I would be really...

Oooo yeah. Thanks for that. Completely forgot about Conditional Formatting as I've only ever really used it in Excel! That actually helped a lot. Thanks.

Right ummm ok. I'm not sure if it worked or not. It's worked for two boxes but after that it doesn't :confused: not sure how that's happened?! but yeah.I'll keep fiddling but thanks for that. I'll get back to you later.

Code It was just inside a Command Button: Private Sub Select_Click() Me.Controls("R1D" & Me.StartDate.Caption).BackColor = "255" End Sub The TextBoxes are named "R1D...." plus an integer of the day. The StartDate being just a label containing the integer.

Saving?! The thing that I wanted it to do was to change the backcolor of the text box to show that it was "occupied". It turns red and it works great, except for the fact that it does not stay there. As soon as I change the view from say design to form or I just reopen the form etc, it is back...

Omg! Thanks so much! That was the perfect solution! I tried doing something like that quite a few times but am not very familiar with the Me! element of programming. I'm getting there, lol but thanks very much for your help, that was great. Barnz