Search results

Sorry - forgot to add that I am using Access 2007. Should be the same in 2010. Wayne

Try going into Design View on your form. Highlight any one of the fields that the Control Tip Text is not showing up for. Right click on that highlighted field, choose "Position", and click on "Bring to Front". Now go back to Form View and try it again. Now it should appear (as long as you have...

Hi Yas, and welcome to the forum. I hope you will find the answers to your questions here, and possibly help others with theirs.

I have set up 3 combo boxes on a form. They are based on a value list, not a table or query. I have set the limit to list property to Yes, and put the following code into the OnNotInList Event: Private Sub AgtType_NotInList(NewData As String, Response As Integer) Dim ctl As Control ' Return...

Thanks John. This will work nicely. I really appreciate the help.

I run a small trucking company. I have a table for orders (Deliveries). I know that grouping on a form (like on a report) is not possible, however, is it possible to use a tab control on a form, with 7 tabs, one for each day of the wek, and to populate each page based on the week selected on the...

Welcome to the forum from a fellow Canuck! Hope you find the help you need here, and maybe you can help others to.

Great. I'm glad it worked out for you. I'm sorry but my experience is all in Access, not Excel. I wouldn't be able to help you there. Anybody else got any ideas?

Sorry! I goofed! That should read: [YourReportFieldName] = [Forms]![YourFormName]![YourFormFieldThatMatchesYourReportFieldName] I kinda had that one backwards! Sorry. This will work.

Hopefully, you already know how to create a button, and place it where you want on the form. With the form in design view, and the properties window open on the "Events" tab, click on the button to highlight it, click on the line for "ONClick" event in the properties window. There is a little...

I'm not sure why you would store data in either a label or a caption. Is it a unique caption / label that applies to all records on the form, or is the ID number just a record number, or is it a unique part number, or something like that? If it is data, it should be stored in a field, so it can...

Where did you define your input mask? If this is an input mask from the definition of the underlying table, your form should have picked it up when you created the form. Check the properties window for that field in Design View under the "Data" tab. See if it carried over to the Input Mask line...

Try putting this at the end of your code: 00\-00\-0000;0;_ This tells Access to store the literal (formatted) value in the field. Should work.

Hello Costas. Wecome to the forum. I'm relatively new to this group myself. I hope you find the help you need here, and hopefully you can help out other users too. Welcome.

Welcome to the Forum. I'm relatively new to this group as well, but have been learning a lot from just reading the threads. It's a great community. You can find help with what you're doing, and hopefully, you'll discover a better way of doing something, and can post it for others to benefit...

Hi all. I just joined the forum today. I am a self-taught Access / VBA user for about 10 years now, and have been reading this forum lately for help on some issues. Thought I would sign up in case I need to ask any questions. I am from Toronto, Canada.