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: *

  1. fkegley

    Word linked with database

    I have had no luck doing that. There is tho a workaround, develop a Make-Table query that puts in the local database the data you want to use in the Word document. Then tell Word to use the local table as its data source. Frank kegley
  2. fkegley

    Excel Unicode CSV Issue

    What about a macro that does a Find and Replace, it could for instance find all the tabs and replace with ,s. Then it export the worksheet to a text file. Frank kegley
  3. fkegley

    Hotmail Question

    There was something recently that I saw about files with a WMF extension being susceptible to infection. That, I believe is proprietary to Microsoft, so they may have arranged for Hotmail to block opening those kinds of files. Frank kegley
  4. fkegley

    Microsoft Word Macro Missing

    I think Organizer can do this. Open the Word document, then Tools--->Templates And Addins... Organizer. You should be able to then copy the macro from the one it is in now to the one that is open. I am using version 2003, so the menus and commands may be different for you. Frank kegley
  5. fkegley

    Using Group and Outline features on a protected Spreadhseet

    Try developing a macro that unprotects the sheet, puts in the outlining, and then reprotects the sheet. Frank kegley
  6. fkegley

    Open DB without triggering autoexec macro

    It would be simpler to rename the AutoExec macro. Frank kegley
  7. fkegley

    Help With Form - Update

    Use the Control Wizard to put a Save Record button on the form. Have the Print Record disabled until they click the Save Record button. You'll need to modify the code produced by the Wizard to do this: In the Click event of the Save Record button (get the properties of the button, Events...
  8. fkegley

    Product Table

    I would probably uae an AutoNumber field as my primary key. The only reason I wouldn't would be if gaps in the numbering were unacceptable. You will have more gaps with AutoNumber than with other ways. Once you do that, then you can have multiple records with the same ProductID, so I would have...
  9. fkegley

    Cannot see text in Word Art result

    This sounds like an incomplete or faulty install to me. Have you tried uninstall and reinstall, ensuring a complete install? Frank kegley
  10. fkegley

    Export to Excel Table and Query names from Access

    Look into Documenter. It will create a report of all the objects in a database. Frank kegley
  11. fkegley

    Excel 2003 macro convert to Excel 2000

    I too have noticed this in some of my macros. All I can suggest is that you record for the OLDEST version of Excel that you have out there. This may mean keeping several versions of Excel on your development machine. The difference I noted (the only one I remember anyway) was in the Sort...
  12. fkegley

    Excel Data Labels

    kim00 the symbol you're trying to get rid of IS the carriage return that you just inserted. It has to be there or there's no way Excel knows to do a CarriageReturn at that point in the text. Frank kegley
  13. fkegley

    Not Enough Memory

    What about opening the one she could open, copying the data, closing and opening the other one? The data will stay on the clipboard once it is pasted there. Frank kegley
  14. fkegley

    Pivot table discarded to due to integrity problems

    If the data is coming across a network, I would suspect the network connection. Frank kegley
  15. fkegley

    Add year(s) to current date

    The DateDiff function can do this. The help files can steer you to the correct syntax much better than I can. Frank kegley fkegley@hotmail.com
  16. fkegley

    Encryption

    Basically, when your database stores data, it stores it in a way such that it can be read by anyone with the specialized software, I believe it is a sector editor, and the time to root thru your hard drive until they find your database data. I have used a text editor that enabled me to root thru...
  17. fkegley

    Importing Access and Excel into Word

    I think you ought to know that Word does not always do a good job of displaying Access reports. Frank kegley fkegley@hotmail.com
  18. fkegley

    OLE-linking pictures

    It could. Sometimes the service packs turn out to be disservice packs. Frank kegley fkegley@hotmail.com
  19. fkegley

    Trouble with SQL statement

    WHERE Action <> "Rejected" OR Action <> "Transferred" When you put in this WHERE clause, you forgot that computers do what they are told to do, not what you want them to do. If Action is 'Rejected' then that is not = 'Transferred' and vice versa. That is why you were getting more records than...
  20. fkegley

    Updating tables through forms

    You also need to examine the rules regarding which recordsets are updatable and which are not. From Access Help: When can I update data from a query? In some cases, you can edit data in query Datasheet view to change the data in the underlying table. In other cases, you can't. The following...

Part and Inventory Search

Back
Top