Search results

  1. S

    Disable the Function Keys

    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...
  2. S

    Problem: Highlighted record in Subform when opened

    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...
  3. S

    Problem: Highlighted record in Subform when opened

    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...
  4. S

    Disable the Function Keys

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

    Disable the Function Keys

    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.
  6. S

    refresh a list on a tabbed subform

    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.
  7. S

    refresh a list on a tabbed subform

    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...
  8. S

    XP Help Lament

    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.
  9. S

    XP Validation Rule/Text Ptroblem

    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...
  10. S

    XP Validation Rule/Text Ptroblem

    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...
  11. S

    XP Help Lament

    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...
  12. S

    refresh a list on a tabbed subform

    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!
  13. S

    refresh a list on a tabbed subform

    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...
  14. S

    refresh a list on a tabbed subform

    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...
  15. S

    XP Help Lament

    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...
  16. S

    Language Translation & Keyboard Characters

    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...
  17. S

    Language Translation & Keyboard Characters

    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...
  18. S

    Language Translation & Keyboard Characters

    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...
  19. S

    Language Translation & Keyboard Characters

    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...
  20. S

    Language Translation & Keyboard Characters

    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...
Back
Top Bottom