Search results

On my form I have a "delete this record" button, which I set up using the command button wizard. If the user clicks it, and then goes "Opps" and clicks "No - actually I don't want to delete this record" (or whatever the standard message is) another message box pops up saying "The DoMenuItem...

I have a form with four "traffic lights" - N/A, red, orange, green. They are toggle buttons, with option values of 0,1,2,3 respectively. The values are from a table with a 2nd field of description. The chosen value drops into a 2nd table to give the status. So - if I choose Green (option value...

This appears to work for me. YAY! I knew it would end up being a simple answer. Thank you for input. I learn more each day.

I feel like a right proper dummy :) I opened a 'dead' database and created a form with a subform (so scared I'll "break" the real database), and realised what was going on when it asked me to name the sub-form control. I've now re-named the subform in the real database to better reflect where...

Thanks for the link. I've sent it to our Access team (most of us being rank beginners). But the code isn't working. As I write it, it doesn't give me "formheader" as an option in the 2nd line. When I run it, it says it doesn't like the first line. (Run time error 2449; There is an invalid...

I'm a little hazy about how subforms work. My specific question in this instance is about a form I haven't designed, but which I'm trying to add some code to. I have a main form: frmGroup The subform is called: subfRolesSubform But when I open "frmGroup" in design view and click the...

Thanks for that. Not sure I follow it all, but probably understood enough to answer my question :-)

What is the difference between "me." and "me!" in coding? I've been using them as though there is no difference, but now, looking at code someone else has written with both, I wonder.

I'm using 03. I've tried it in two different databases; and it works perfectly - hides the (wrong) header every time.

Not sure why I would, but I tried it and it still works. Put the same line against a command button and when I click it - it turns off the header (of the main form).

Me.FormHeader.Visible = True ... works. It turns off the form header BUT on the main form not the sub form :( I can't work out how to get the code to set the focus to the sub-form and THEN run the command.

Having some difficulty getting the header to hide when I open the main form. The code I'm using is: Private Sub Form_Load() Me.tblRoles_Subform.SetFocus Me.FormHeader.Visible = False End Sub I'm a little confused because the sub-form is actually called "subfRolesSubform". I don't...

The unique identifier is the "book ID". If I have two titles by different authors say: "Koalas" by Smith & Jones "Koalas" by Brown & White they would have two different "Book ID" entries.

My table has (among others) fields "book ID" (autonumber) and "title". Each title has only one record in the table, but may have more than one author - picking up from another table. I have a search form that allows users to enter data in various text boxes to return all the titles in the...

I have a form with a subform (let's call them Form01 and SubForm01). SubForm01 is also used as a stand-alone form, accessed from a command button on another form (Form02). All my forms (dozens of them) have a standard header - client logo, title, exit button, background colour etc. When...

That's great, thanks. Always easier to work things out for yourself if you actually understand the "why" and "how" and not simply the "what".

Where do I put that code? I tried a couple of places in the existing code, but nothing is working.

What does ME. mean in VB? I'm using it 'cause I've been told what to write, but I'd like to understand what it's actually telling the program to do.

I have an AfterUpdate code on a text box in a form that returns an error message when invalid data is entered and resets the field to a null value (thanks for your help). However, it flicks the cursor to the next tab stop when the message box is closed and I would like the cursor to stay in...

Evan Works beautiful, except ... to doesn't return the box value to zero - but it won't let you leave until you put a valid date in it. Possibly more effective, but could be potentially very frustrating for PMs without a lot of Access experience. My field is called "Started", my box on the...