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

    How to reference value between columns?

    I've got a text file that contains data in the following format: ID START END COMMENT 01 9am 12pm Login 12pm 1pm Lunch 1pm 5pm Logout 02 7am 11am Login 11am 12am Lunch 12am 4pm Logout Now I...
  2. Spyder757

    Can a full XP Pro CD upgrade XP home?

    I bought a lap top a few months ago that shipped with XP Home. I'd like to upgrade to XP Pro. However I'd rather buy the XP full install rather than the XP Pro upgrade simply because my laptop didn't ship with the discs to reinstall the OS should it ever become corrupted. ANyway to make a long...
  3. Spyder757

    “SendObject” question. Possible to disable prompt?

    I’ve got a database and I’d really like it to be as easy as possible on the end users to export a report in snapshot format, open a new piece of mail from outlook, and attach the report. I decided to do this using the SendObject command. My code works fine for exporting the report and attaching...
  4. Spyder757

    Store hyperlink in table but display on form, report, webpage etc...

    I'd like to be able to store the hyperlink of a graphic file in my table but be able to display this image (rather than the link) any time I query it for a web page or form. Is this possible, or am i taking the wrong route on this?
  5. Spyder757

    Returning values “greater than” question.

    Basically I’ve got a query that returns the values of anyone who has tested greater than the value of a combo box. For this I use: >([Forms]![Rpt_Form]![Score Type 1]-0.01) >([Forms]![Rpt_Form]![Score Type 2]-0.01) Each employee has the option of two test types. So I’ve got 2 of the above...
  6. Spyder757

    How to sort records in combo box?

    I've got a combo on my form, it refers to query that has 6 coloums but is only bound to the 2nd. How can I go about having the records sorted in alphabetical order? I've tried sorting the query that the combo box refers to but it doesn't seem to work.
  7. Spyder757

    Getting value from text box question

    I currently have the following code: DoCmd.SendObject acReport, "Report", "SnapshotFormat(*.snp)", "[Forms]![Menu]![Email]", "", "", "Call Outs", "", False, "" My problem is that instead of checking the email text...
  8. Spyder757

    Querying Access From The Web

    Ok, I’ve been an Access user for 2 ½ years now and I am looking to expand into using it on a website. Basically I want to have a table, lets call it main table. It will have a query called Main Query And finally a data access page that displays the data. I would like to be able to select a...
  9. Spyder757

    How do I batch copy a file from a drive to a desktop?

    At my job all of the workstations are running Windows 2000. I would like to be able to write a simple batch file to copy and paste a database to the desk top of the users. Example: Copy Database.mdb C:\Documents and Settings\JJohnson\DesktopDatabase.mdb The problem I run into is each person’s...
  10. Spyder757

    Excel formula to show the last number in a series of cells?

    I need a formula to show the last number keyed in a series of cells. Example: Day 1: $15 Day 2: $25 Day 3: $30 Day 4: Day 5: Week Ending: $30 (this number will change when Day 4, and then finally Day 5's numbers are keyed) Any ideas?
  11. Spyder757

    Question In Regards To Data Access Page

    I consider myself a pretty experienced Access user however I’ve never been able to get the Data Access Page to do what I want. I’m currently running Access XP Developer. Anyway I create a Data Access Page using the Wizard using a basic table as my source. I have the option to scroll through the...
  12. Spyder757

    list only the top 10 records?

    Is it possible to list just the top 10 highest percentages in a query?. I've tried using that little drop down that appears in the query to limit it to just 10 records but the records that are returned aren't the top 10 but appear to be an average? Spyder757
  13. Spyder757

    Possible To View All Users Who Have A Database Open?

    I've got a database at work that at any time may have 10 to 15 people using it. I would like to be able to view either the address of the machine on the network.... -OR- The user ID used by the person to log into the work station. We run Windows NT 4.0, 2000, and a few machines have XP. The...
  14. Spyder757

    What is the function of MSBLAST.EXE

    I've recently upgraded from Windows 98 to Windows XP, and I noticed while running my firewall that MSBLAST.EXE will open 10 to 15 connections on port 135 to an IP registered to http://www.iana.org. When I terminate MSBLAST.EXE nothing bad seems to happen and my system goes about its business...
  15. Spyder757

    Where can I get Internet Information Server?

    I've recently (today) bought a new lap top running Win XP Home Edition. I'd like to be able to have a test envroment to play with web site design. Where could I download/buy MS Internet Information Server? Spyder757
  16. Spyder757

    Locked out of Windows/Internet Explorer. Please help.

    I went to change my homepage back to the default setting after some adware switched it on me. The problem is when I went to change it I got a message stating I could not make the change and that I would have to speak to my network admin for permission. If I attempt to make any system changes...
  17. Spyder757

    Possible to update a record in a table with the results of another tab

    Ok I’ve got a table named main table. It contains Paid Time Off (PTO) requests for all of our employees. As these people change supervisors and even departments (which they do rather frequently) I would like to go in and change the data previously entered for these people to their new...
  18. Spyder757

    How do you run an ASP from your desktop?

    I currently run Windows 98 and Office XP Developer. I’ve just recently become interested in web design and I was wondering how I could create a web site and test it locally on my computer. I’ve tried making ASPs but Front Page states they need to be published in order to be viewed properly...
  19. Spyder757

    Possible to have a query look at a subform for value?

    Is it possible to have a query look at a subform for data? What I mean is I’ve got a main form called “PTO Review”. Within that form there is a sub form named “Current Skill” and it contains a field called “Skill”. What I need to have happened is a query need to look at “Skill” for the value...
  20. Spyder757

    How to delete specific records using a Delete Query?

    I’ve got a main table that contains: Agent Name ID Vacation Days And I’ve got a table of employees who have been termed that contains: Agent Name ID Term Date Now I need to be able to automatically go back and delete the dates the termed agents had been requested out of the main table. How...

Part and Inventory Search

Back
Top