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 Wanet Telecoms Ltd 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. basement131

    Number of records in each table - query required

    i have a MS access 2003 database with 120 tables. rather than checking each one to see how many records are in each i would like to run a query that would tell me just that. the table name and the number of records within. any help much appreciated. Your help & assistance today will be...
  2. basement131

    Ghost & smaller partition

    I have a slight problem. first, i created an image of my XP sp2 system using Norton Ghost 9 and saved it onto the network drive. then at a later time i used partition magic to partition my hard drive. then at some point in time i copied the Image of the system onto one of the partitions. Now...
  3. basement131

    NIC not recognized Ghost 9.0 when restore

    I am unsing the Norton Ghost recovery disk to restore my hard drive. At one point I backed up an image onto the network drive and now i would like to restore. Problem is that when i go to run the symantec recovery disc i get the error, "Failed to install network adapter -- check winbom"...
  4. basement131

    MS Visio Very slow

    perhaps it is my computer, which is a P3 866 Mhz, with 512 PC133 SDram using XP Pro. & visio 2002 sp2 standard edition i have a file with approximately 11 sheets which is roughly 5000 KB in size. i am finding that my system is not performing various task very redily. For example when i open...
  5. basement131

    General Info

    i would like to know the most economical way to set up a network that would allow an office of 4 people to to work at the office as well as work out of their home. When at home i would like them to be able to access their files at work. here is the catch. is it possible for each person to...
  6. basement131

    Blackberry phone hookup without Data

    i am looking at purchasing a blackberry unit. i have the need for a cel phone and i currently have a IPAQ 1710. That means i am carrying around 2 devices all the time. i would like to buy a blackberry unit but i do not need the data transmission. i have seen many of these for sale and they...
  7. basement131

    HP 1500L Color Laser Printer

    i have a HP 1500L color laser printer. i would like to network this printer, but i do not have a printserver and do not want to buy Jetdirct $$$$$$$$$$$$$$. instead we have a Buffalo Linkstation 160 Lan, which has a print server, however, only works with select printers (something i found out...
  8. basement131

    max length of USB cable for printing

    Does anyone know the maximum length that you can run USB cables for printing. the issue. we have a network in our office of 4. From time to time we need to print color pages for reports. We have a HP 1500L color laser printer which was given to us (we did not buy it as it would not have been...
  9. basement131

    install word for new user accounts

    i have 2 user accounts on a computer (XP SP2 & MSoffice 2003). both have full access. when i set up everything and installed all the programs they were installed under my user account name. then when my my wife logs on, and tries to open a MS word documnet, she is always approached to install...
  10. basement131

    MSAccess 2000 - queries disappear

    has anyone ever had the following problem. i will run some queries, then close the queries and when i am brought back to the main page of the database the complete listing of my queries is gone. to be able to view it, i must click one of the other fields (table, forms, reports) and then reclick...
  11. basement131

    query to assign an incremental # based on order sorted

    For MS Access is there a function that exists or can someone build me one, so that i can assign an incremental number to a record based on the order that the records are sorted. such that the 1st record would be 1, 2nd=2, 3rd=3, etc. Your help & assistance today will be passed on to others...
  12. basement131

    selecting the bottom 10% instead of the top 10%

    Using MS access 2000 is there a way to select the bottom 10% as apposed to selecting the top10%. i know i could change the sorting to descending and then select the top10%, but then i would have to resort my sample after. is this the only way to do this without 2 steps. Your help & assistance...
  13. basement131

    Query using IIF & *

    i am trying to create a query that changes the names of positions so that i can group them based on similarity. ie. A Sr. VP operations and a Sr. VP Human Resources are the considered the same "Senior Exec", where as the VP operations & VP Human Resources are considered "Senior Manager" now...
  14. basement131

    I do not want the random number to change - in query

    i have the following query. Random number:Rnd([DE_fjrnldate]) the DE_fjrnldate - is a date that may or maynot be the same for different records. now when i run the query each record has a unique number. which is exactly what i want. however, when i rerun the query or click on the random...
  15. basement131

    Include Field Description in the Report

    i have searched the forums with no success on this topic. i have a table which was based on a survey the the fields are as follows Name city question1 question2 question3 and so on till question50. Now within each field under the design view i have included the 'actual question' (i.e -...
  16. basement131

    Thrown in Jail

    Here is the issue. i am looking at purchasing a program which costs $2000 per user and we have 7 users doing the math that equals $14000. Now here is the issue. THis program is used by all 7 of us but not very often. So it would be rare that we would all need it at the same time, but we would...
  17. basement131

    VPN vs RDC

    I am trying to access my computer at the office from home Details office computer is running Winxp pro connected to the internet via LAN we have a lynksys 4 port router BEFSR41-ca v.2 there are 4cpu's on the router no firewall except the router or xp the home computer is running win98se...
  18. basement131

    outlook.pst could not be accessed

    I have Win ME, Outlook 2000 on a stand alone cpu. my hard drive has 1.9G of space left & the PST file exists and is about 268 megs in size. when trying to open an email or delete an email i get the message The file C:\windows\application data\microsoft\outlook\outlook.pst could not be...
  19. basement131

    a query to join 1jobcode to many locations.

    i have 2 tables whith the following table 1 called [JC] this table only has the job codes which are numbers such as 120, 121, 122, 150, 180, 250, 260, 320, 390, 450, etc. table 2 called [JL] this table has the job locations in which there are only 4 locations as follows: C440, S440, R440, &...
  20. basement131

    access query - stumped

    i am trying to develop a query with 4 tables as follows Table "JC" has the job codes (i.e. 100, 200, 300, etc) Table "96" has the full time equivalents FTE for each job code in 1996 Table "97" has the full time equivalents FTE for each job code in 1997 Table "98" has the full time equivalents...

Part and Inventory Search

Back
Top