Search results

Since the label is bound to the checkbox (it is, right?) then there is no way to identify a tab order for both the label and the checkbox. You could always just set the focus to the checkbox (or other control) depending on the tab label selected...

You can just requery the comboboxes when the user clicks on the navigation buttons and as long as the company field is in the comboboxes recordsource then you should get the desired result. Comboboxes have a Column Widths property to define which columns in the recordsource to display. For...

You can reference a comboboxes' columns using the syntax me.myComboBox.column(x), where x is the column number (starting at 0 I believe). So in the comboboxes' OnChange event you just assign the values of the selected records columns to the fields in your form. For Example: me.firstField =...

It's probably easier to do the processing after the user has finished typing stuff in (which you will know how?). Then you could use Split function to do something like this: Split the memo field by spaces to get each word Split each word by a period, comma, semi-colon, etc to separate words...

If you say that the Undo button works from the toolbar then you can call the toolbar using the DoMenuItem method. For Example: DoCmd.DoMenuItem acFormBar, acRecordsMenu, acUndo, , acMenuVer70 or you can try... DoCmd.RunCommand acCmdUndo

I believe that as long as you have the Auto Center form property set to No then the form should open in the position in which it was last saved.

Have you tried to include the listbox control in the subform's Link Master Fields property and linked it to a corresponding field in the subform's Link Child Fields property? If so then I believe the subform should automatically change when the listbox does.

I believe you can only call a function and it has to be defined in a standard module (I.e. not a form module). Then in the Onaction field of your submenu call it like this: =myFunction() I you try to do this in VB make sure you put the equal sign in the assignment. E.g. myCmdBarCtl.OnACtion =...

=doCmdOpenForm("My Form", "My OpenArgs") Too many quotes, duh!!!

I think you have too may double quotes. Your database name is Show Database.mde, right? If so then try this in your deployment scripts... "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "$(AppPath)\Show Database.mde""

I have created a function (below) that opens a form (whose name is passed to the function in a variable) and passes in an argument (whose value is also passed to the function in a variable). Public Function doCmdOpenForm(formName As String, openArgs as string)...

How do you know when there are enough orders? Who schedules the deliveries? You can make sure the right orders are added to the right deliveries using something like this... Note: I am replacing all spaces in names for convenience of writing the SQL. INSERT INTO DELIVERY_ITEM (SELECT...

You can also do it through code. Put the appropriate properties you want to configure in a macro or module that gets called when the database is opened... ' Set STARTUP options changeProperty "AppTitle", DB_Text, "" changeProperty "StartupForm", DB_Text, "Menu" changeProperty...

This has examples of what you are looking to do... Access Security FAQ

The following Oracle ODBC driver versions work just fine for me: 8.00.05.00 8.00.510.00 8.00.64.00 8.01.06.00 8.01.57.00 8.01.64.00 As does the following Microsoft ODBC for Oracle dirver: 2.573.4403.00 Here is a snippit of code that I use that may help? Dim wrkODBC As Workspace Dim...

Pat, do you know if it is possible to determine whether the close button (X) has been pressed? I could then display the appropriate message from the Form_BeforeUpdate procedure telling the user that they must either save the record before proceeding (if X not pressed) or that their changes are...

That is pretty much what I have (I don't have it in a function) but I think you will run into the same problem I am. When you are editing a record, click on the close (X) button. When you get your prompt say No. Don't you get the prompt (from original thread) I am trying to avoid?

Currently I have code in the form's BeforeUpdate event to notify the user if the record is dirty, telling them that they must save the record before proceeding. The event is then cancelled and everything works fine. The problem I need help with is that when the user tries to close a dirty form...

I knew there was a way to do it. Enjoy!!! Public Function processShortcutMenu() Dim frm As Form Dim cmdbarCtl As CommandBarControl Set cmdbarCtl = CommandBars.ActionControl Set frm = Forms(application.CurrentObjectName) CallByName frm, cmdbarCtl.Tag, VbMethod End...

You need to put that in the command button event procedure, before the save command. For example, if your button is called RECORD_SAVE_Button then in the command button properties you should have an event procedure defined for the On Click event. If you used the wizard to create the button then...