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 SkipVought 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. porter

    sql 7.0 model database

    thanks for the advice, but I already tried that and that is when I get the error saying that I do not have an exclusive lock on database MODEL. I know I can't have an exclusive lock on a database that doesn't exist according to the master database, so I am looking for a to attach the model...
  2. porter

    sql 7.0 model database

    I backed up the master database from one server after I had detached the model database. I then restored this master backup to a new server and now I do not have a model database referenced in master on this new server. I have the .mdf and .ldf files for the model database and I have tried...
  3. porter

    How to copy all sheets in an exel file

    How about just copying the filename?? P
  4. porter

    Key-Cmd to Flip Worksheets?

    Try crtl-PageDown and crtl-PageUp P
  5. porter

    Backing Up Autocorrect

    We are going from Win95 to 2000. Would like to backup the autocorrect, don't know what file stored the info. Can someone help?? P
  6. porter

    Sort by words, not by column

    Thanks, that did it. I appreciate the patients. By the way, congraduation tlbroadbent on being voted TipMaster of the Week. Good luck on winning that leather jacket. P
  7. porter

    Sort by words, not by column

    Not sure what I'm doing wrong. Select the query name, click on design, then inserted a new column. Left "Field" "Table" "Sort" blank. Typed MYSTATUS: IIf(Left([STATUS],1)="C",1,IIf(Left([STATUS],1)="P",2,3)) in Criteria. Go to click on...
  8. porter

    Sort by words, not by column

    I copied your statement and pasted into a new column criteria in the query. I get an error message. "The expression you enter has an invalid...", click OK and the cursor blinks on the first open parentheses. I have four open parentheses and four closed parentheses. I do have the...
  9. porter

    Sort by words, not by column

    tlbroadbent, Your suggestion may work, but can you tell me where to put the code?? Sorry, not real good with codes. P
  10. porter

    Sort by words, not by column

    In my report I would like to have, under Status, show all entries that are "Complete", first. Then all entries that are Partial, second. Then all entries that are Incomplete, third.
  11. porter

    Sort by words, not by column

    I have a column in my report called "Status". The Status will be either Complete - Incomplete - Partial. How do I make the column list by Complete - Partial - Incomplete?? I run the report from a query. P
  12. porter

    Assigning a Macro to a Control Button

    In Office 95 after I draw the control button it prompted me on what macro I wanted to assign to the button. Now in office 2k it doesn't ask. How can I assign an already made macro to a control button with going into visual basic and copying and pasting the code?? P
  13. porter

    Problems with Outlook Contacts to Access

    I tried to copy all of my Outlook Contacts into an access table. I used the “Get External Data” and had the wizard make a table for me, but it only copied 15 of my 54 contacts into the table. I noticed that it only picked up the contacts that have e-mail addresses. Some businesses don’t have...
  14. porter

    Boot-up looping at beginning

    Thanks for the response. I did reseat the memory chip. I will try the others. Before replacing the M/B, do you think it would help to flash the bios??
  15. porter

    Boot-up looping at beginning

    When I turn on my computer the first screen comes up with 3 lines in which one line has "SGRAM Size 8.00". Then another screen comes up which has the Energy Save symbol and does a memory test along with plug & play. Then it loops back to the first screen and keeps cycling through...

Part and Inventory Search

Back
Top