Search results

That code created the following error: Application-defined or object-defined error

I've tried those- the one I was sure would work is its something like Forms!ChooseActivity!ChooseParticipant!Combo13.Set Focus but that returns an object not found error... Thanks for trying, I appreciate the help found here :)

I have fought with this for more than an hour. I have tried various combinations to no avail. I finnaly just did it exactly like a previous thread that I found using the search feature. I get an error message=Application defined or Object defined error 2465 Event=AfterUpdate of Combo29 Move...

I need to fill a year field on a form from a date field on the same form when the date field is filled in by the user. Thanks, Dave

No I am glad that YOU got it working. I usually fight things for 4 or 5 hours before running back here with questions- I have been working on this all week. I hated to tell my customers that they could NOT use spell check- felt much better to tell them it is now working. I tried again to leave...

SWEEEEET! Thanks- I appreciate the time you took to help :)

Here is the code.... Private Sub Nature_of_Business__AfterUpdate() With Me![Nature of Business?] If Len(.Value) > 0 Then DoCmd.SetWarnings False .SelStart = 1 .SelLength = Len(.Value) DoCmd.RunCommand acCmdSpelling .SelLength = 0 DoCmd.SetWarnings True End If...

I replaced the 'ControlToBeChecked' text with the field name: [Type of business?]. I put the code in the after update event for the [Type of business?] field. When you run a spell check and it finds a bad word, it suggests a change. If you accept that change it corrects the original text with...

This resulted in an error message: Cannot save to this field... Recheck Macro... blah blah or Recheck macro... other blah blah or Redefine the function in the module window Thanks for trying :) Dave

This works, but checks every record in the form's underlying table...

I searched and read previous posts and could not find anything newer than Access 97. I am using Access 2007 and a few customers are using 2003. When I run a spell check from the field I want checked, it goes through all the records and starts displaying suggested changes for other records, and...

Using Access 2007 I am trying to load fields from a closed table- first field is below Forms!frmtabsurvey!Dba = tables!track2!Doing_business_as_name I get an 'object required' error message TIA, Dave

The combo box is a subform- with limited space- and the scroll bars were making the data hard to read. I also tried this on a single field and it had no effect. Dave

I finally found how to control the scrollbars in 2007 and override the default decision made by 2007- Me.Scrollbars = 0 0 = None 1 = Horizontal 2 = Vertical 3 = Both

I finally gave up last night and went to a work station that is still 2003. The change took under a minute and it works correctly on both versions of Access [2003, 2007]. So I think what you are saying is that there is no longer a property of setting the scroll bars, that they are just there...

My workstation was upgraded a few days ago to Acess 2007. A customer asked me to add a drop-down record selector to one of their forms. When I added the combo box and sized it to fit the correct area it had both scroll bars. I cannot find the scroll bar horz/vert/both/neither property. I...

Neither of the form resizers that I use work in Access 2007. Has anyone a lead on one that will work with 2007? Thanks, Dave

Downloaded and will test this morning. Thanks for the info. Dave

A form resizer that I used will not run in Access 2007. I have this included in all my forms. Is there a way using VBA that I can do a global search and replace on all form in my dBase? Thanks, Dave

Matbe this can save someone else a headache or two- as you folks have for me many times :)