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

  1. RichardPrewitt

    Importing files from one Outlook user account into another

    I have a computer that I changed domains on and of course the user didnt export his outlook files before he gave it to me like I told him. Here is whats happening: 1: We use to use a pop3 Outlook account for our outside office users. 2: We are now moving everyone to an Exchange Server So by...
  2. RichardPrewitt

    Playing large files on WMP?

    I upgraded my Windows Media Player 9 at home to play large media files (700mb or higher) but now I cannot find that update to upgrade my new computers. Basically the media player works fine but because its over 700MB (its a movie) it doesnt play. Can anyone point me to the place that I need...
  3. RichardPrewitt

    Need A Crystal Enterprise 9 Security Tool

    Im looking for a tool that can give me a list of which people have rights, access, etc to which folders and reports Basically, its easy to find out which users have access to any given folder or report but it takes a tremendous amount of time to figure out which reports, folders, etc any...
  4. RichardPrewitt

    Having trouble with others seeing previous changes to a document

    I am having trouble with changes that I make, like omitions and strike throughs being viewable when others open the document. How do I make these changes unviewable to others?
  5. RichardPrewitt

    Need help with query that returns ""

    I have a report in Access that uses a query named qaverage that generates an average of completed tasks between two dates and then displays the tasks that are late. It actually uses two queries combined to accomplish this. Here is the SQL for the query qaverage: SELECT qbetween.actuallast...
  6. RichardPrewitt

    Help with word wrap in a text box bound to a MS Access DB

    I have a VB program that uses an Access database. On one of the forms I have a text box that the user inputs a description of about 150 characters or less. The problem is that when they enter the characters they only get one line and when the view the record the text in the text box is then...
  7. RichardPrewitt

    Program Problem needs Fixed Fast!! Please Help!

    I have a program that has a couple problems that have to be fixed yesterday. I need to get the program to do a print preview or page setup (be able to specify which pages they want to print, like pages 23-31 of 45 or page 27 of 45) Can anyone help me with code that does this without giving them...
  8. RichardPrewitt

    Access: Help with field calculation for average?

    ok heres the story. I have a program that is writing to Access. I have a few reports in Access that the program prints. Now on one of these reporst I have say 6 fields: [machine] [perm number] [% complete] [task #] [last time completed] [description] Now I sorted the first row by...
  9. RichardPrewitt

    I need to only display the last 30 days of records

    OK two problems about the same. Problem #1 ------------- I need a query that will display only dates < 30 days old. Please help me. The query is going to be used on a report. I have the dates entered into fields in the table two different ways. One in format ##/##/#### and another way in 3...
  10. RichardPrewitt

    Help please Having trouble comparing dates in Access

    Im writing reports in access that are printed from a VB program. Now on one of the reports they want me to take the last completed date which in a field in each record and compare it to today's date to get a "how long has it been since this task was completed last" field on the report. I was...
  11. RichardPrewitt

    HELP with Printing!!!!

    I am working on a program that uses an Access database and I want to create a report that the VB program prints. I do not want to use Word or Crystal Reports. I am trying to create a sub procedure so I can code the reports like: Printer.Print Tab(40); Format(variable, variable) something...
  12. RichardPrewitt

    I'm trying to write to an Access database through VB

    I made a database in Access and have a program that writes to it made in Visual Basic. I am trying to get the vb program to write to two tables in the same form. For some reason I cannot get the fields of one record and write them to the fields of another table. I have a task table and a...
  13. RichardPrewitt

    ? about limiting access to Access db while using VB

    I am making an Access database with a Visual Basic user interface. I am used to putting the db on the server and the program on the PC's but this time I need to put the db on the same PC as the program. My question is, How do you deny access from the user of the PC to the db and still allow...
  14. RichardPrewitt

    Getting underline and hyperlinks to print as shown on screen

    I have recently gotten several computers off lease and I installed Office 2000 on the new ones coming in. One person (VERY computer illiterate) can break a steal ball and somehow made it so that none of her underlined hyperlinks or words will print the underline. It shows fine in Word...
  15. RichardPrewitt

    The print popup on a word document comes up behind the document

    I recieved a Word document via e-mail in Lotus Notes as an attachment. I view the Word document and go to file then print. The print pop-up box for print options that normally comes up in front of the document instead comes up behind. This is the only document that this happens on. I'm...
  16. RichardPrewitt

    I keep getting the end-user agreement every time I open an Office doc

    I loaded a PC up last week the normal way I usually do it, but this time I keep getting the end-user license agreement. Every Excel, Word, Access or PP doc that I open, I am asked to accept or decline this license agreement, even after I have accepted it before. This is driving me nuts. Any help...
  17. RichardPrewitt

    Trying to get just the current date to show in an Excel spreadsheet

    I program VB and C++ projects with the NOW() formula all of the time, but I can't figure out how to get just the date and not the time when using formulas in an Excel spreadsheet. I found that it varies quite a bit from Access, and I haven't used date and time formulas in Excel since I was in...
  18. RichardPrewitt

    I am trying to convert an Excel spread sheet into an Access Database

    I am trying to convert an Excel spread sheet into an Access Database. Any help would be appreciated. Thanks
  19. RichardPrewitt

    Trying to Null a field to an underlying Access DB

    I have the following code in the Object cmdCancelFollowUp and the Procedure Click. The RequireFollowUp, DateOfFollowUp, and TimeOfFollowUp are fields in the underlying 97 MS-Access database. datRequest is a data control on the main form in Visual Basic 6.0. When I run the program, it says that...
  20. RichardPrewitt

    Im getting blank pages inbetween printed pages on a report in MS-Acces

    I generated a report in MS-Access for a friend, and he messed with it somehow to make it print blank pages inbetween every printed page. The page counter at the bottom doesn't count the blank pages either. I can't seem to find what is causing this. Can you help? Probably something simple that...

Part and Inventory Search

Back
Top