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...
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...
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"...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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 -...
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...
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...
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...
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, &...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.