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!

Register Log in
  • Congratulations Rhinorhino 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: *

  • Users: GeekGirlau
  • Content: Threads
  • Order by date
  1. GeekGirlau

    Word Template Add-In Not Firing

    I have a template add-in in the startup path for MS Word 2003 (SP3). If I have a user with Outlook set to use Word as the email editor, this affects the template add-in for Word. If Outlook is loaded first, followed by Word, the template code does not fire. However it works correctly if Word...
  2. GeekGirlau

    Preventing Links to SQL Data

    I've been given the task of providing recommendations for upgrades to an Access 2003 database that links to SQL Server data. I have one user in particular that is bypassing the Access application and creating his own, directly linking to the tables. What I want to do is allow read/write...
  3. GeekGirlau

    Huge Increase in Excel File Size

    I have a workbook where the code copies one of two "template" sheets to a new workbook, copies all cells and pastes the values. The sheet is then password protected and saved separately. The issue is that the master workbook (containing 6 sheets, 2 user forms and 4 modules) is 492 KB in size...
  4. GeekGirlau

    SumProduct with Wildcard

    I've had a look at the posts re SumProduct with a wildcard, but my problem is a little different. I have some criteria that may be blank, in which case I don't want them included in the SumProduct at all. My actual SumProduct formula requires an additional 3-4 criteria, but I've shortened it...
  5. GeekGirlau

    Outlook 2K Form - CustomPropertyChange event

    I posted this question in the VB Script forum as well, but haven't yet found the answer. I have a custom form in Outlook that uses the CustomPropertyChange event to hide or display different controls each time the value is changed within a list box. Sample of the code appears below: Sub...
  6. GeekGirlau

    Outlook 2K - Not Running CustomPropertyChange Code

    I have a custom form that uses the CustomPropertyChange event to hide or display different controls each time the value is changed within a list box. Sample of the code appears below: Sub Item_CustomPropertyChange(ByVal Name) Select Case Name Case...
  7. GeekGirlau

    Decimal Places Problem

    I have a field defined as Single data type, Fixed format with 3 decimal places. When I type a value that has 3 decimal places, the last digit is rounded so that it always displays as zero. So if I type 15.752 I get 15.750, 1.105 becomes 1.110 etc. Any ideas?
  8. GeekGirlau

    Hyperlink to Word Template

    I'd like to create a number of hyperlinks in a Word document that link to various shared Word templates. However I don't want the hyperlink to open the template; I want it to create a new document based on the template. Basically I want it to perform the same function as if you selected File...
  9. GeekGirlau

    GetObject and MS Word

    AAAAAAAAAAGGGGGGGGGGGGGGGGGGGGGHHHHHHHHHHH! Sorry, had to get that out of my system. I'm having trouble with using GetObject to manipulate Word from Access. Sample: Function StupidWord() Dim objWord as Word.Application On Error Goto ErrHandle Set objWord = GetObject(...
  10. GeekGirlau

    Security Permissions for New User

    I've made the erroneous assumption that when you create a new user in a secure database and add them to specific groups, they inherit all the permissions for those groups. However what I'm finding is that the user doesn't automatically have permission to open the database object, even if they...
  11. GeekGirlau

    Search for String with Query SQL

    As a contractor working predominantly on databases I haven't developed, it can be a daunting task trying to find references to tables, fields or functions within a list of several hundred queries. The following code is attached to a command button on a simple form listing all queries in the...
  12. GeekGirlau

    Problem with CreateObject to Launch Word

    AAAARRRRRGGGHHHHH!!!!!!!!! I'm having constant fun and games using CreateObject and GetObject. In the following sample, if Word is not running I get error 429, but Word is not being launched. As soon as I reach the ".Documents.Add" I get error 91 - object not set. I can use Shell to...

Part and Inventory Search

Back
Top