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 bkrike 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: NSGuard
  • Content: Threads
  • Order by date
  1. NSGuard

    Excel Macro - Help

    I'm looking to make a macro that takes data in column A and seperate it into three columns. I'm able to do it by setting up the macro manually, but is there a way to loop it to do it automatically as long as there is information in column A...
  2. NSGuard

    If Then Function in Excel

    Is there a way to have two If Functions running together. The second one is attempting to place an greater than or less than equation into the first If loop based on if a specific cell contains a negative or positive number. ie This is what mycurrent attempt has produced, but doesn't work, the...
  3. NSGuard

    Movie Files in PowerPoint not working

    Does anyone have an idea why a movie file won't run on one persons computer but run on anothers. I have a presentation with 4 media clips attached to it, the presentation runs flawlessly on my computer and anothers, but will not run others. I'm dumbfounded. Thanks for any ideas in advance.
  4. NSGuard

    Combining Reports

    Is there a way to take 11 seperate reports and combine them into one continuous report (the reports each have different fields). report1 followed by report2 and then report3, etc all are apart of reportall. The program was originally set up to print off all 11 reports, but the user now wants...
  5. NSGuard

    Vertically Center in a Textbox?

    I have a report that prints out 10 Labels to a page and some information doesn't take up the whole Label, so I was wondering if there was a way to vertically center the information so that the whitespace isn't so drastic. You can do it in Excel, but I can't seem to figure out a way to do it in...
  6. NSGuard

    Consolidating Information

    In a report I have a bunch of personal information for multiple people. They are listed in such a fashion: Name Address1 Address2 Address3 CityStateZip HomePhone WorkPhone1 WorkPhone2 etc... When information isn't present I have the textboxes become invisible and the information then moves...
  7. NSGuard

    Group Header Trouble

    In a birthday report, I am sorting the birthdays by month. In the group header I have this as the format of the text box: =Format([txtBirthday],"mmmm") The information being brought in is from a query and is being sorted/grouped by this action: =Month([Birthday]) =DatePart("d",[Birthday]) Those...
  8. NSGuard

    Date Trouble

    I am trying to edit the input mask of a Birthday field. The only data I want to be entered is the Month and the Day, not the year. I've tried mm/dd and 99/99, and neither of them work, they always default to mm/dd/yyyy. This is most likely very easy, I am just probably going about it the wrong...
  9. NSGuard

    Reports able to be stored in a seperate location?

    Is there a way to output a report that is designed and stored in the Access Database, in a common folder on a network, so that users can go to the report and view/print it w/o having access to the database? If it is possible, when the report is being stored in the seperare location, will it...
  10. NSGuard

    Viewing Mail Merge Data

    I am merging three data fields into a word document through the mail merge function. I have it set up so that only the current record I am looking at in the database, sends information to the word document. What I am really doing is populating a template word form. My question is: When I...
  11. NSGuard

    Macro Trouble

    This should be quite easy for you guys, but I just don't understand the problem. I am taking three fields from a table and mail merging them into a Word Template so that it automatically updates the document with the information in the database. That works fine, but my problem arises when I...

Part and Inventory Search

Back
Top