Search results

I am using Access XP on a Win2000 PC ghudson, I did as you said, rechecked the work about 3 times. I cannot get a message response clicking anywhere on the form. I added the case structure to a control's OnKeyDown and got the messages. All I have on the form is a listbox, subform and many...

SforSoftware, They are set at Continuous, although I admit I am not sure the significance of this, I think it is the default. I had hoped that the SendKeys would: F2 - unhighlight the record HOME - place the cursor at the beginning of the text. At this point, I am getting the form to...

I have several of these types of forms with subforms. When the form opens, most of the time the first record is highlighted. I do not know how to code to insure that this does not happen. In the OnOpen event of the Main form I have code like below. Note that the subform does open at the...

If I could, I'd rathere do this in VBA instead of a macro.

With the marco I got F2 disabled but now I cannot get it back! I have closed the program and later shut down the computer but I can no longer F2 around. How do I enable F2 again? Access is XP version.

JonatABS, I think it would be a good thing to put out a file to this forum with the bare essentials. Note in the code where it is failing. Keep it simple and note the Access version.

JonatABS, There certainly a parallel with our problems. We have a form and a subform that aren't talking. You have the addition of the tab to contend with. Well here are some thoughts. The first easy question to ask is have you used the Builder tool? It was with it that I discovered my glitch...

Pat, The link worked for me but I have not used it yet. XP Help totally crashed and an Option Box I added failed to perform. I am going to reinstall Access XP and see if I gain any improvement.

You know, it may take a while to like XP! In this case, after entering the post, I closed the dB, opened it again and the Validation Rule/Text worked! I have the Access XP on an old Dell GXi 200 mhz. 126MB of RAM. Perhaps this is part of my problem. Anyway, no need to respond. If anyone else...

In Access XP I have a field "Year" in a table as a long integer. In a form based on the table, the textbox txtYear has the above field as its Control Source. For the properties I entered: Validation Rule: >1980 AND <2040 For Validation Text: "You must enter a year between 1980 and...

dcx693 Greetings! I got the subform syntax, my error was in assuming that the name of the subform was the name I should use, I found out with the BUILD in Access97 that the main form uses the property name of the subform control instead. I ws wondering, can a guy somehow import Access97 Help...

I see, itwasn't the caption but the Name property of the subform as seen from within the Main Form. That makes me feel a lot better. Thanks, Rich!

I found my answer but not without some pain. I converted the XP back to 97, moved it to my 97 PC and ran it. Same error. Now I have become convinced it is an error. I was using the name of the subform as entered into the Database Window/Forms pane. But what access wanted was the Caption name...

Requery a Subform I wonder if this thread is talking XP or an earlier version. My problem lies with XP. I agree with DC693's syntax "Forms!mainformname!subformname.Form!controlname.Requery" but XP is returning the Run-Time error 2465 and "can't find the field <subformname> My code line is...

I am reluctantly using Access XP. I need to requery a subform from the main form (parent). Would you believe that the words subform and requery are not in the Help Index!!!!!!!!!!!!!!!!! Talk about 2 steps backwards. Then in VBA code, the BUILD option has been removed. So looking around in...

Well here it is July 25th and I have not obtained any degree of success. There are a lot of translators out there but none that I have found that can be run from within MS Access. I am going to check out some VB sites for possibilities. I find it strange that there is so little translation...

Looking for a English to Spanish Translator I need to obtain a simple English to Spanish translator, reasonably accurate, that I can manipulate through Access. Cost is a real factor but I'd appreciate hearing of all options. I'd like to hear from any developers who have used either a custom...

IMG Visual Keyboard Innovation Management Group has a series of software products that include a visual keyboard - now called OnScreen and was named My-T-Soft prior. I found that the software is dependent on the operating system keyboard layout but otherwise worked nicely to input a foreign...

Microsoft Visual Keyboard Question I returned to the MS Visual Keyboard again, not believing my notes. But once again I found that it would not write into my Access form. I could write a foreign language into MS Word, then copy and paste into Access but not directly. Has anyone else...

Microsoft Keyboard Language Support? Microsoft has included language support to Windows 2000 O/S and later for Unicode and a variety of keyboard languages in Win98 and later. I have found that the selection of languages varies from one O/S to another. For example I found Russian on my Win98 PC...