Search results

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.