Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Rick39

    Text Entered in Field Displays Backwards

    Hopefully someone has seen this and has a solution - A user of a multi-user application (2003) I developed recently reported that when typing text into certain fields fields (bound to memos) on a form, that the text displayed backwards or reversed. This occurred on his PC while a user next to...
  2. Rick39

    Visio Database Table Linking & Dynamic Updating

    Try http://www.mvps.org/visio/Information_Sites.htm or http://www.faroukmusa.com/CSC502/main/12_Visio.htm
  3. Rick39

    query truncating memo field - help

    Can you post the query SQL?
  4. Rick39

    query truncating memo field - help

    I've been able duplicate your problem by specifying a format (@) in the field property Format in the query grid. Could you be applying any formatting to your memo field in the query itself?
  5. Rick39

    query truncating memo field - help

    Make sure you're not using a GROUP BY clause
  6. Rick39

    MS Access Form to Word

    Take a look at http://support.microsoft.com/default.aspx?scid=kb;EN-US;210271
  7. Rick39

    how to open a MS Word document stored in Access 2000 as an ole object

    I've done it by referring to a hidden bound object frame on a form: Forms!YourForm!YourObject.Verb = acOLEVerbOpen Forms!YourForm!YourObject.Action = acOLEActivate
  8. Rick39

    Outlook Forms

    Some good info @ http://www.outlookcode.com/d/index.htm
  9. Rick39

    Create calendar item from Access

    I've found alot of good info at this site: http://www.slipstick.com/dev/code/index.htm
  10. Rick39

    Custom Message for Required Fields.

    That was the reason why I attached it to the Save button (it was an automatic Undo until all the fields were filled in).....Glad you found a work around Rick
  11. Rick39

    Still having trouble searching for a particular word

    Try something like: SELECT YourTableName.Field1, YourTableName.[Field2], YourTableName.Field3, [Field1] & [Field2] & [Field3] AS SearchCriteria FROM YourTableName WHERE ((([Field1] & [Field2] & [Field3]) Like "*" & [Enter Word to Search For] & "*")); Hope this helps Rick
  12. Rick39

    Custom Message for Required Fields.

    Glad it helped...thanks for the star
  13. Rick39

    Custom Message for Required Fields.

    My mistake.....I originally attached the validation code to a Save button (it always reset validated fields), but if you're going straight to the close button, you may want to make reference to a save routine in the close button's On Click event ( or the On Close event)
  14. Rick39

    Custom Message for Required Fields.

    I don't beleive that you can change the backcolor of a checkbox but here's a possible work around: Create a textbox named txtChecked, size it, set the font size to whatever size you want), set Enabled and Locked properties to Yes, and add this code to the On Click event: If...
  15. Rick39

    Output Table Data to MS Word Document

    See http://support.microsoft.com/default.aspx?scid=kb;EN-US;210271
  16. Rick39

    Showing the contents of a Word bookmark in ACCESS

    Take a look at http://support.microsoft.com/default.aspx?scid=kb;en-us;210032
  17. Rick39

    database will not open

    Take a look at http://support.microsoft.com/default.aspx?scid=kb;EN-US;306204
  18. Rick39

    Please help me to use a Word template from Access VBA

    This may help: http://support.microsoft.com/default.aspx?scid=kb;EN-US;210271 just remove the portion that closes Word: 'Quit Microsoft Word and release the object variable. objWord.Quit Set objWord = Nothing
  19. Rick39

    Combo Box Situation - Filling Text Box Based on Selection

    If you go with the text field (assuming your combobox fields are set up like Noun, Description), you could, in the AfterUpdate event of the combobox use: Me!YourTextBox = Forms!YourForm!YourComboxName.Column(1)

Part and Inventory Search

Back
Top