Search results

Thanks everyone, for the great tips and help! MIB1019

Hello, all. Is there a function out there for changing a field entry to proper case in the after update event, that traps and corrects problems like this: Washington DC becomes Washington Dc McGurley becomes Mcgurley 1125 NW becomes 1124 Nw etc. Thanks in advance! MIB1019

Looks excellent, arnelgp. Am going to incorporate your advice in my db. MIB1019

Yes, here is a form. I want to turn off the one that is accessed with right-click on the TAB, but keep the one that is available for form records.

It seems like I cannot have it both ways, i.e. to turn off (or modify) the context menu on the object's tab and keep the context menus for the controls on the forms.

Hello All! In my database, the objects open is TAB view, rather than separate windows. I want all of the forms to retain the default context menubars for the controls, (so that I can use cut/copy/paste, sort, etc.) I want to disable the context menus on the tabs themselves. User will have the...

I have my application using tabbed documents rather than separate windows for forms, etc. I need to modify the context menu on the tabs and don't know how that is addressed in VBA. I believe the Shortcut Menu property for the form relates to the records, not the tab itself. Will be creating...

Well, that didn't work after all, just as you suggested. I went the route of the textbox on top of it, locked and with no tab stop. Left the enter and exit events on the combo box. It seems to be fine now. Thanks again...you guys are great! MIB1019

Here's what I've done: Changed the row source of cboContact_ID combo not dependent on the Company_ID. On Enter event of the cboContact_ID, uses an SQL string to filter the combo dependent on the Company_ID. On Exit event of the cboContact_ID, reset the rowsource to its 'default' state, not...

But is it a cascading combo box by virtue of it getting the Company_ID value from the main form? There isn't a combo on the subform that feeds it's value into the SQL that populates it? Thanks! MIB1019

Hello, I have a subform called Journal Subform, with a combo box called cboContact_ID. The same subform is used on two different main forms. The two main forms hold company information, including a Company_ID. I have VBA filling the combo box on the subform with the SQL statements, varied only...

Sorry for not responding to this. Have been away for a few days. Simply deleting the links altogether, as Micron suggested, and rebuilding it did the trick. Thanks again! MIB1019

Thanks everyone! That worked! MIB1019

Hello, hope you can help me. I have moved a database (front-end and back-end) to another computer, ready for the user. The Linked Table Manager is having an issue with one table, fails to link to it. I get an error that I need to check the table name for puctuation and name length. It has...

Thank you all! I will turn off Compact on close and keep an eye on it for bloat. I assume I need to turn it off on the two files, front-end and back-end. You're all the best!! MIB1019

Hi, I have a button on a Dashboard form to close Access. May have several objects open in the database, so want to close the program 'gently'. Current Database properties include Compact On Close. What would you suggest? Thanks! MIB1019

Hi arnelgp! I want to try to get the main form function you suggested, DatesToTextBox(), working on my popup form. Do you know why I might be getting the #Size! error in the textbook control? MIB1019

Yes! Thanks so much!! MIB1019

The tblIODetails_Dates has three fields: 1: Date_ID (autonumber), 2: Detail_ID 3: Air_Date I think the hangup is in the VALUES part of SQL, since it skips the AutoNumber field. MIB1019

So, I'm almost there on this form. The form that calls this little popup for the user to enter dates has the txtAir_Dates on it that the simpleCSV function eventually when the popup is closed. Sometimes, the user won't have to be opening the dialog to enter dates because there is only one. So...