Over 1 million tech questions and answers.

[SOLVED] Corrupted FAT table?

Q: [SOLVED] Corrupted FAT table?

My daughter's IBM ThinkPad 600E won't boot up into Windows 98SE. It tries to run scandisk but gives an error message that the FAT table is bad and it can't run. It then freezes when trying to open Windows. I also can't boot into safe mode but can boot to a DOS prompt. Any idea of a utility that can fix the drive?

RELEVANCY SCORE 200
Preferred Solution: [SOLVED] Corrupted FAT table?

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: [SOLVED] Corrupted FAT table?

Read other 11 answers
RELEVANCY SCORE 64.8

I am a complete novice so please be patient and talk to me like i'm a 6 year old if possible.
I have a 10 yr old hp with xp. I use a modem with Charter internet supplied by my apt complex for free. I recently bought a belkin router and a netgear tv box. Everything was working fine until we had a power outage during the night. The next morning nothing was working. A day later i got my modem, router and tv box to work. The computer worked after trying to turn it on 3 times. The monitor wouldn't come on at first. Now everything is working but i still can't get online. My connections say they are connected but nothing is received.
I ran the IE connection problem diagnostic tool and it says:
default gateway 0.0.0.0
no default gateway entry
corrupted routing table
the default route is missing or invalid
invalid IP address
could not connect HTTP connection
HTTPS and FTP connections

I have no idea what any of that means. Can you help? Thank you.

A:[SOLVED] corrupted ip routing table

I assume you have tried to reset the router?

Read other 19 answers
RELEVANCY SCORE 54.8

Anyone know how to fix a corrupted partition table?
Every program i have tried has not worked because they all say that the table is corrupted.
I have reformatted once and i wouldnt like to have to again.
So any help would be VERY appreciated.
Brandon
 

A:Partition Table corrupted

Read other 6 answers
RELEVANCY SCORE 54.8

Hi all,

For the past week I ve been having a lot of notifications on my Win2008 AD. They are the same:
NTDS (628) NTDSA: Database e:\Windows\NTDS\ntds.dit: Index DRA_USN_index of table datatable is corrupted (0).

Anybody knows what this is?
 

A:NTDS table is corrupted?

Your boot hard drive is failing
 

Read other 3 answers
RELEVANCY SCORE 54.4

Hi,

My Hitachi Touro 4TB disk partition got corrupted.
Originally it was one 4TB partition with about 2.5TB of files.

One minute it was fine, then it came up with "Need to format hard disk before use", then it wouldn't even start up.

The disk is currently mounted in a disk dock. The disk wouldn't start up in its original enclosure so there might have been a hardware problem with the electronics of the enclosure which corrupted the drive.

Now it has 3 partitions

465.75 GB RAW - Healthy (Primary Partition)
1582.25 GB Unallocated
1678.02 GB Unallocated.

I have tried TestDisk but for some reason after about an hour of scanning or so, the drive seems to switch off. But it seems fine when I'm using Windows software. I've tried writing MBR but TestDisk says it can't!!

Should I use something like easus partition manager and set the primary partition back to one 4TB partition and then use recovery software to recover the files or is there a better way?

Thanks

A:Best way to sort out a corrupted partition table?

Sorry to say this, but in every instance where any of my partitions were reported as "raw", that mean that the drive had suffered physical damage. And, in NONE of those cases was I able to recover anything of any of the drives.

I had two fairly new Seagate drives do this to me last year, and in both cases, they were sudden head crashes.

Read other 9 answers
RELEVANCY SCORE 54.4

Hello Sir,

First of all,to inform you, this has happened due to my mistake! and i am really very guilty about it.

The thing is that i have both ubuntu 12.04 and win 7 home basic installed on my system.
I installed ubuntu later so as expected the win7 loader was replaced by the grub loader.
What i wanted to do was restore my original win7 loader so that i could set my default OS to Win7 so that i didn't have to select it every time my system booted up.

In this regard,i searched some youtube videos and then ended up with a video which was not described very well, still i followed it because i wanted to get back the win7 loader desperately.
I am providing the link to that video:

Restoring Windows's Bootloader After Installing Linux - YouTube

I went ahead with the steps described in the video, And then shit happened.
My windows partition got corrupted and now i stand at the risk of losing about 500gb of important data which i had collected in about over an year.

I am able to boot using ubuntu but i am unable to browse my files on the hard disk(which i could do easily, earlier) as it doesn't show any partition.

When i inserted the recovery disc,it simply gives the option of restoring the factory settings,nothing else(like repair,which it used to give earlier).

My question to you sir, is that, is there any way through which i can restore my computer to normal and save my data?

I will be really very very grateful to anyone who helps me out of thi... Read more

A:Corrupted Windows partition Table

Hi ankitSurfzen and welcome to Seven Forums. You could try Minitool Partition Wizard to recover the partition. This video will show you how. How to perform Partition Recovery with partition magic? Partition Wizard Partition Recovery Video Help.

Read other 9 answers
RELEVANCY SCORE 53.2

The partition table is corrupted and I need to backup some stuff from C drive. I tried taking out the hard disk and backing up data but I got an error message saying that I need to format the disk before using it. Then I tried data recovery software recuva. It said " unable to determine filesystem type". Then I tried Testdisk n through it I recovered 2 partitions but not the C drive. Now I am using Mini tool Partition Wizard but it hangs at 9%. How should I get data from C drive?
 

A:Internal Hard Drive Partition Table Corrupted

Please do not start more than one thread for the same issue.

Closing duplicate.
 

Read other 1 answers
RELEVANCY SCORE 53.2

I have a 20G hard disk that is (used to be) divided into 5 partitions.
When my computer booted up yesterday, only the C partition was visible -
the other partitions, containing all my personal files, installed games and
digital photos, had disappeared without a trace. Partition magic, which I had
used to partition the disk in the first place, informs me that "Logical drive
chain points to sector without partition table." Is there some utility that
can recover my partition table for me?
 

A:Any way to rescue corrupted partition table on hard disk?

Disk Doctor, which is part of the Norton Utilities or Norton System Works depending on your OS, may be able to correct your problem.
 

Read other 1 answers
RELEVANCY SCORE 53.2

Silly me, I just saw the instructions here on how to post which I somehow missed before:

Is Windows 7 Professional
- x64 (64 bit)
- the original installed OS on the system? yes
- an OEM version
- OEM = NOT pre-installed - I installed myself when I build machine

- age of system (hardware): almost exactly 1 year old
- age of OS installation: almost exactly 1 year old also
- have you re-installed the OS?: no, I have never re-installed the OS

How do I get the dump files from a machine that won't load past the BIOS???

------------------------------------------------------------------
I haven't seen any recent threads on this so here is the situation:
I had a failed Service Pack Install so I ran both the Chkdsk C: /f function and a sfc /scannow System File checker functions as described in this article about Fixing a Failing Windows 7 Service Pack 1 Install.

I then installed and ran the Windows Update Readiness Tool.
Upon a 3rd reboot, I get the following error: 0cx000000e

I used the System Recovery Options from the Windows 7 Install Disk and the Startup Repair has diagnosed:

Test Performed:
Name: Check for updates
Result: Completed successfully. Error code 0x0.
Time Taken = 0 ms

Test Performed:
Name: System disk test
Result: Completed successfully. Error code 0x0.
Time Taken = 0 ms

Test Performed:
Name: Disk failure diagnosis
Result: Completed successfully. Error code 0x0.
Time Taken = 109 ms

Test Performed:
Name: Disk metadata test
Result: Completed successfu... Read more

A:0xc000000e - Partition Table Repair - corrupted F:\windows

Well, I see there has been some views of this post. Any ideas? even a RTFM comment would be appreciated. just tell me which manual. please. thanks.

or even tell me to just do a new install. or is it possible to do a repair install from the installation disk?

Read other 2 answers
RELEVANCY SCORE 53.2

Hello everyone,
After I used "Acronis Disk Director" in a HirenBoot CD to cut some space from my D drive to my C drive (boot drive), I've got this "Windows is checking the D drive" then "Corrupted master file table. Checkdisk is aborted" on my D drive. After doing some homework, I've tried corrected it by using testdisk's Fix MFT function but "Both of the MFT files are corrupted. Can't fix".
I did not back up the whole partition.
Are there any other ways that I could try to fix this? I do not really want to buy $60 + commercial software that TestDisk recommends just to fix this possibly once-in-a-lifetime issue. However, if recovery softwares is the only option left, then I have to use them.
Cheers guys. I'd really appreciate any help.

A:Corrupted master file table after resizing partitions

You could try running:
MBR - Restore Windows 7 Master Boot Record

Read other 1 answers
RELEVANCY SCORE 52.4

I have a Western Digital MyBook ES 500 GB external hard drive (USB and eSATA interfaces) for data backups formatted from a Windows XP PC that I now use with my laptop running Windows 7 64-bit Home Premium. Recently my son connected it to his Apple PC and tried to create a partition to back up his files. Apparently this corrupted the partition table. I can no longer access any data on the hard drive. The drive does not appear in Computer but does appear in Device Manager and Disk Management.

I believe the problem is that the partition table (formatted for Windows) was modified by an Apple computer so that Windows can no longer tell what file system is on the partitions. My son is gone for a month and I no longer have access to his Apple computer so I can't plug the drive into an Apple computer to check if the drive gets detected.

I looked at the drive using:

1. Windows 7 Disk Management
2. Acronis Disk Director 11
3. EASEUS Partition Recovery (latest version)
4. Partition Wizard 5.2

None of them could do anything except delete or format the partitions. I saw no repair option or ability to mark the partitions as NTFS file system.

The partitions on my external drive are still there but no file system is shown for most of them. Acronis Disk Director shows the following information:

Disk 1 (GPT)
VOLUME CAPACITY FREE SPACE TYPE FILE SYSTEM STATUS
EFI 200 MB 200 MB Ba... Read more

A:Corrupted Partition Table on External USB Data Backup Drive

A big chunk is unallocated. Was some of your data there? If so try Partition Wizard Partition Recovery Wizard - Video Help.

See if PW can also run Partition Wizard Check File System which can recover some partitions that are not readable.

If not some success has been reported repairing the partition table using Disk Genius trialware: http://www.diskgenius.net/

Read other 3 answers
RELEVANCY SCORE 52.4

I have a Make Table query that when I run it and view the table in the query it shows only the data I want. But when I go and open the table that theis query made, there are entries that should not be there.

It is putting in rows with blank fields, I am not sure how to stop it. I have tired to put something in the query for that field but I get back the error "Invalid Use of Null"

If I could put in the criteria that worked I would be all set.

Any ideas?
 

A:Solved: Access (Make Table) Query Results Returned not Same as Table

Read other 6 answers
RELEVANCY SCORE 52.4

A previous thread indicated problems encountered when trying to update a Table of Contents and Table of Figures, etc. using Word 2007. I couldn't find any solutions to that message. I am having the same problem. I tell it to update the Table of Contents or Table of Figures, and it does that correctly, but as soon as I click "print" the page numbers all change to 2! Any ideas?
 

A:Solved: Word 2007 - Page Number Issues Updating Table of Contents and Table of Figure

Read other 12 answers
RELEVANCY SCORE 51.6

I am having trouble updating data from one table to another. I am not Appending the data.

I've linked the two tables on an ID field.
I created a select query to see the data I would update.
I changed the query to an Update query.
In the Update To field I placed the following: [table].[field name]

After running the query I noticed the update did not work. The data from the first Table did not get updated to the second Table it wound up being deleted from the first Table.

Your help is appreciated.

Buttercup
 

A:Solved: Access 2003 Update Table from another Table

Buttercup1, welcome to the Forum.
I am not sure why you wan to update the second table with data from the first table.
Can you show me a screenshot of your query with the table(s) in and also your Table relationships?
 

Read other 3 answers
RELEVANCY SCORE 51.6

I am starting this Access database from scratch. I have to import/upload a sales file weekly. I will be adding this file to a main sales data table. The issue I have is that this file does not have any dates on it. I need to be able to add a start and end date to the table.

Example fields that I would need/have

Need:
start date
end date

Have:
Item #
Store #
Sales Units
Sales Dollars

What is the best way to handle this? I have an idea - just not sure what order I should put my steps for importing the file, asking for the date range, adding the date to the table, etc....
 

A:Solved: Access - import table - add date to table

Read other 9 answers
RELEVANCY SCORE 51.6

Hi SF dudes

Just seeking some help with a bsod problem, iv followed the SF bsod posting guide and have collected the dump files(attached), if iv missed something please let me know.

Buils as follows:

CPU: AMD FX 8150 8-core (stock not OC)
Mobo: ASUS Sabertooth 990fx (latest firmware flashed, shows all system correctly)
RAM: Corair Vengence 1600mhz (cmz16gx3m4a1600c9)16gb 4x4gb
GPU: Gigabyte GF GTX670 OC 2gb (as factory, not OC)
PSU: Antec HCG 900w (SLi down the track)
SSD: OCZ vertex 3 240gb
Hdd-1: WD Green 2TB (WD20EARX)
Hdd-2: Old Hitachie 300gb 2.5inch (as per cutomer request)
ODD: LG BD-DVDRW combo (CH12LS28)
WiFi adpt: TP-Link Wireless N pci-e(TL-WN881ND)
OS: Win7 pro 64bit with SP1 Retail with key(not burnt,DLed or USB)
Aftermarket CPU cooler: Corsair H80

So i went through quite abit of ram testing, each dim and each slot tested with win7 memtest, clear with 10 passes each.
Done all win updates, 3 .net framework updates failed(could be a lead)
Device list shows all driver working, (no(!))
I dont want to rant but there are other details that could help so just ask for the specific info/data/spec and ill post.
I checked out the SF tool files but...
So if a few minidump & debug gurus could jump in here and take a look it would be great.
Thanks in advance and happy computing

Ronyart

A:New Build, Bsod at randow. Stop:0x1a sub:41790 table page corrupted

A few extra details:\

Temp:
CPU: Idel 30-35 Load 42-46
MoBo: Load 36-42
GPU: Load 36-48
Collected using Asus Ai Suit(UptoDate)

All Bsod are Memery_Managment, stop:0x0000001a
with almost all 1st sub codes being 41790-table page corrupted

The GPU driver has me worried, everytime i go into device manager and hit the auto update button for the GPU the screen flickers and jumps but to generic stock resolution and fails to even see the driver, just shows generic driver,to resolve this i must uninstall then reinstall the driver but the same thing still happens with the update button even after the reinstall
Lets Go SF, hit me!

Read other 4 answers
RELEVANCY SCORE 48

2012R2 box won't join the domain, tried reseting computer object, tried deleting it/recreating it...  
Any ideas on where to fix the currupted policy table?  


Eventxmlns="http://schemas.microsoft.com/win/2004/08/events/event">
-
<System>
 
<Provider
Name="Microsoft-Windows-DNS-Client"Guid="{1C95126E-7EEA-49A9-A3FE-A378B03DDB4D}"
/>
 
<EventID>1023</EventID>

 
<Version>0</Version>

 
<Level>2</Level>

 
<Task>1023</Task>

 
<Opcode>0</Opcode>

 
<Keywords>0x4000000010000000</Keywords>

 
<TimeCreated
SystemTime="2020-04-30T22:00:24.021435100Z" />

 
<EventRecordID>181636</EventRecordID>

 
<Correlation
/>

 
<Execution
ProcessID="1052"ThreadID="3892"
/>
 
<Channel>System</Channel>

 
<Computer>dcmitvmlgc002</Computer>

 
<Security
UserID="S-1-5-20" />

 
</System>
-
<EventData>
 
<Data Name="RuleName">{b76ed7a8-be84-4713-9504-6fb495209d03}</Data>

 
<Data Name="ErrorCode">1018</Data>

 
</EventData>
 
</Event>

Read other answers
RELEVANCY SCORE 48

 Event viewer displayed an error message Master File Table contains a corrupted file record . This system has no other symptoms.  I have run chkdsk /f and it did clean up/moving of the files it did not fix the MFT.  Can this been done with utility Dell Backup and Recovery or do I need a 3rd party program such as TestDisk?

Read other answers
RELEVANCY SCORE 47.6

https://gist.github.com/TrueToonatio...fe4795caf4f73e

Hi I've ran a mem check through windows and it says my ram is fine. I was thinking of re-flashing my motherboard.
The story:
A week and a half ago I had to go back to windows 7 from windows 10. I did a clean install with a boot drive everything seemed fine then this blue screen happened. Updated it and everything the blue screen happened again. So... I reinstalled windows 7 again from my CD this time and wanted to upgrade to windows 10 and I got Safe OS error. Tried it with a boot driver had the same error again. Then it blue screened again. So I reinstalled windows up Updated it completely and it messed up with the updates.
I reseatted my ram switched slots reseated my gpu etc. I do not know why windows 7 is being so unstable when everything was fine when I had windows 10. I'm thinking its a driver issue but I do not know where to look.
Currently this version of windows 7 SP 1 I have only has a few updates. IE 11 has direct x stuff etc.

Win7 on SSD
two secondary hard drives
M4-CT1128M4SSD2 ATA Device
ST10000DM003-9YN162 ATA Device
WDC WD101EZEX-00BN5A0 ATA Device
Sapphire 7950 as gpu
i5 3570k cpu
biostar motherboard B75MU3B LGA 1155
Ram Patriot Gamer 2 DDR 3 PGD38G1600ELK 8GB

The computer can run hours at a time without blue screening
TLDR: installed windows 7 around 4 times still same problem

A:Blue Screen: A page table page has been corrupted win7?

Hello Toonation and welcome to 7forums!

Please run this as it will help us help you:

Blue Screen of Death (BSOD) Posting Instructions

The dump files are a good start but to reach the finish line we need more!

Cheers, Boris

Read other 2 answers
RELEVANCY SCORE 46

I have a database that i'm creating that has 3 different tables. Its for safety violations at work. One table is the innitial one that has all the pasic information on it. I set it up so that it automatically assigns a number to each complaint filed. The other two are for follow up. One is for how the problem is going to be fixed and who is supposed to do it, And the other one is for verification to make sure that the problem has been fixed. My problem is that i want the two follow up tables to automatically import the complaint number when a new complaint is filed. I tried to set everything up myself, but had no luck. Can someone please help? Thanks.
 

A:Solved: update the column in one table based on the column of another table

Read other 16 answers
RELEVANCY SCORE 43.2

hi,

Just wondering if anyone could tell me if and how i can revert back to an older version of a table.

I had a table saved contain product details
whilst i was away a work mate accessed the table deleted some colums and saved over the table.
i was just wondering if the was anyway to undo this save, or if a back of the previous table could be found somewhere.

using Access 2000 on Win XP (no restore point available).

thx in adv.
Dam
 

A:Access 2000 table backups? / undo a save to a table

No.
Not unless it's on a drive where you have been backing up the entire database or have specifically set up for the database to backup the data...
 

Read other 1 answers
RELEVANCY SCORE 43.2

If I move a table row in Word 2007, it seems to split the table at the point it is inserted. The row above gets the table bottom formatting, the row I insert gets both table top and table bottom, and the next row gets table top. If I hover the mouse at the start of the inserted row it offers me the table start marker, as does hovering over the next row. This happens whether I drag and drop or cut and paste.

What&#8217;s going on, and how can I insert the row as part of the existing table, or at least re-merge the tables back to one again? I never had this problem with 2003.

Thanks,

Ian
 

Read other answers
RELEVANCY SCORE 43.2

I would like to populate an excel sheet with the values that are there in another adjoining sheet (The excel file is the same). The issue here is the data in the adjoining sheet table is pivoted. So what I want is:
Sheet 1 (Columns): Server_Name, Oracle - Category backup etc
Sheet 2 (Columns): Server_Name, Monitors only and the monitors here have different values for each server.

Sample for Sheet 2:

Here is an excerpt from the first pivoted data sheet. This is my sheet 2 (the pivoted table) and my first sheet is the same as above.
sDisplayName sMonitorTypeName sMonitorTypeDescription (Placeholder?)
AQUA3 AQUA3 - AOL Jobs Monitors the ETL jobs on AQUA3
RPC Service NT Service Monitor
SNMP Test availability of SNMP
AQUA4 Oracle - Category backup Active Script Monitor
Oracle - DataPump backup Active Script Monitor
Oracle - DBA account created Active Script Monitor
Oracle - Keep Cache Active Script Monitor
Oracle - locked accounts Active Script Monitor
Oracle - RMAN backup Active Script Monitor
OracleDBConsoleORCL NT Service Monitor
AQUAMARINE3 RPC Service NT Service Monitor
SNMP Test availability of SNMP
BASIL3 RPC Service NT Service Monitor
SNMP Test availability of SNMP
BERYLLIUM1 Beryllium 1 - Eon Incremental Monitors the ETL jobs on Beryllium 1
RPC Service NT Service Monitor
SNMP Test availability of SNMP
BERYLLIUM2 Oracle - DBA account created Active Script Monitor
Oracle - Keep Cache Active Script Monitor
Oracle - locked accounts Active Script Monitor
OracleDBConsoleCBORC... Read more

Read other answers
RELEVANCY SCORE 42.8

Hey there folks...
I am in need of some assistance. Obviously!

I need a form which allows a user to select a record from one table and completely move the record to a totally separate table in the same database. I need it to transfer all the data for the selected record.

AutoNumber will not be an issue as each record has unique identifiers.

I found this article online but it seems it will append ALL data and doesn't allow a user to select the correct record. This uses an Append Query which makes sense but again it seems as though it will transfer ALL records. All I need is for it to transfer a specific record depending on the user's selection in the form.
 

A:MS Access 2007: Moving a record from one table to another table...

Is this to "Archive" the record?
It is not normally necessary to actually "Move" a record, as you can just have a tick box called archive or similar that can be used to exclude that record from normal display and to display it as an Archived record.
There are 2 ways to do what you want, if it is really necessary, one is using an Append query, you can Identify the currently selected record on the Form using
forms![Form Name]![name of Key Field]
in the First Criteria row of your Key field, where Form name is the actual name of your form and name of Key Field is the actual name of your Key Field.
The other version is to use a VBA recordset Clone to do the same thing.
The
 

Read other 1 answers
RELEVANCY SCORE 42.8

Hi there,
I am not that cluey with access vba programming and I need some help please.
I have a Table called (Parts) with columns (PartName), (PartNumber), (PartCost), (Quantity)...
I have (Parts) table linked to (Repairs) table in one to many relationship.
I have a Form linked to the table (Repairs) with different fields to enter different repair details.
Among these fields is: combo box (PartsNameCombo) where you can select the Part Name from values listed in (PartName) column in table (Parts), and I have used the following codes to populate the selected part's cost accordingly:

Private Sub PartNameCombo_Change()
'Auto populate Part cost based on Part Name
Me.PartCost.Value = Me.PartNameCombo.Column(2)
End Sub

I have repeated the above combo box three times (in case different parts used in one repair).

My Question: I would like to add code to automatically subtract (1) from part's Quantity in (Parts) table whenever a particular (PartName) is selected in the combo box.
so for example, if in a repair, I selected: (front case) in the first combo box and (display screen) in second combo box, I want the cases quantity to drop by one and also screens quantity to drop by 1?
Any one can please help?
 

A:Updating table value when different table form field updated

Read other 16 answers
RELEVANCY SCORE 42.8

I'm trying to run a clear table query (to keep the table, but delete the data), and then an append query to repopulate the table, and it's not working.

...any idea what I'm doing wrong?
 

A:ACCESS clear table/append table not working?

Read other 11 answers
RELEVANCY SCORE 42.8

hello,
I have created a make table via a parameter query. The parameters are defined correctly and I am prompted each time to enter them. the DeptNo does work as my query is filtered based on a value entered, but when I enter the tablename parameter, the make table query always saves the table as @tablename, and not any text i enter for the @tablename like "mynewtable" or something. Here is the SQL code.
Any ideas? Ignore the complexity of the query, my main concern is being able to loop through some VBA code and continually change the tablename each time (along with the DeptNo. I think this will save me time vs creating a new sql statement each time and doing a docmd.runsql ...
Thanks.

PARAMETERS DeptNo Text ( 255 ), [@TableName] Text ( 255 );
SELECT AUMaster.Lawson, ChgMstr.DEPT, ChgMstr.[CHG CD], ChgMstr.[REVENUE DESCRIPTION], [Prior and Curr Year Revenue - Qty].Price, ChargeCodeProfile.[Count per Charge] AS Weight, [Prior and Curr Year Revenue - Qty].[2006 Projected Quantity], [Prior and Curr Year Revenue - Qty].[2006 Projected Revenue], [Prior and Curr Year Revenue - Qty].[2007 Projected Quantity], [Prior and Curr Year Revenue - Qty].[2007 Projected Revenue] INTO [@TableName]
FROM ((ChgMstr LEFT JOIN [Prior and Curr Year Revenue - Qty] ON ChgMstr.[CHG CD] = [Prior and Curr Year Revenue - Qty].ChargeCode) LEFT JOIN ChargeCodeProfile ON ChgMstr.[CHG CD] = ChargeCodeProfile.[CHG CD]) LEFT JOIN AUMaster ON ChgMstr.DEPT = AUMaster.Affinity
WHERE (((ChgMstr.DEPT)=[D... Read more

A:Parameter Make Table Query-passing the table name - HELP!

Read other 10 answers
RELEVANCY SCORE 42.8

I put a table into a doc file and decided later I didn't need it there, so I used the Control key and down arrow to highlight it then hit Delete. The table disappeared, BUT now, every time I open the .doc, I get the following warning.
How do I get rid of it without having to print out the entire 5 page document then retyping it?

 

A:Wodrd2K fives warning about corupted table in a .doc, but there's NO table!

Try saving the document as a text file (*.txt). This will get rid of all the formatting, leaving just the text. Hopefully, this will get rid of the reminants of the table. Take it back into Word and then redo the formatting.
 

Read other 2 answers
RELEVANCY SCORE 42.8

Hi there,
I am not that cluey with access vba programming and I need some help please.
I have a Table called (Parts) with columns (PartName), (PartNumber), (PartCost), (Quantity)...
I have (Parts) table linked to (Repairs) table in one to many relationship.
I have a Form linked to the table (Repairs) with different fields to enter different repair details.
Among these fields is: combo box (PartsNameCombo) where you can select the Part Name from values listed in (PartName) column in table (Parts), and I have used the following codes to populate the selected part's cost accordingly:

Private Sub PartNameCombo_Change()
'Auto populate Part cost based on Part Name
Me.PartCost.Value = Me.PartNameCombo.Column(2)
End Sub

I have repeated the above combo box three times (in case different parts used in one repair).

My Question: I would like to add code to automatically subtract (1) from part's Quantity in (Parts) table whenever a particular (PartName) is selected in the combo box.
so for example, if in a repair, I selected: (front case) in the first combo box and (display screen) in second combo box, I want the cases quantity to drop by one and also screens quantity to drop by 1?
Any one can please help?
 

A:Updating table value when different table form field updated

At least two ways to do this but I wouldn't make it automatic. What if the wrong Part name was inadvertently selected? I would ad a button to the form "Take one from Inventory" and execute an update query that basically does Quantity= Quantity-1 . This query would need to link to PartNumber on the active form.

The other way would be to write the SQL to do the update in VBA and run the EXEC SQL command under the new button.
 

Read other 2 answers
RELEVANCY SCORE 42.8

I have different mailing lists that I want to add to a mailing list in my database. There may be duplicate addresses in these lists. I want to only add an Address, FirstName, LastName record once. So how do I combine these lists with my original list without adding a duplicate Address, FirstName, LastName record?
 

A:importing data from a table to another table without adding duplicates?

Read other 6 answers
RELEVANCY SCORE 42.8

http://www.mediafire.com/?8bbfjsbun24m74z

In this database, i have a data entry form called "Information Requested" and all information in this form when entered are added into table Information Requested. In the form, 3 fields Names, Business Units and Emails are drop down lists based on table Contact List. However, what the form does now is i have to pick the name, business unit and email manually. It's not really efficient this way. what i want is when i pick the name, the corresponding business unit and email of that person will automatically show up in the box. How can I achieve this?
 

A:[Access 2010] How to append record from one table to another table.

The data should NOT be transferred to the table, only displayed on the Form, as it should only be entered once.
You can display it on the form by including the data in the Combo as a "Concatenated" field or you can transfer the data to "Unbound" fields.
 

Read other 1 answers
RELEVANCY SCORE 42

Hi, i'm new in using excel macro and vba. In my workbook, there are large amount of uncluttered data in many table in one worksheet. I need help how to combine/merge/join multiple table in one worksheet into one master table into another worksheet using userform? i'm sorry if my explanation is confusing because I'm not so good in English. thank you for any help.
 

Read other answers
RELEVANCY SCORE 42

Hi there,

I have excel 2007 and I am trying to delete a table I put in. (Insert > Table) The problem is when i do this it deletes the data within the table. I dont want to have to delete the table and put in all the information again. Is there an easy way to do this? I looked at a similar post and it said to press the filter button on the data tab. This does nothing.

Any help or suggestions would be greatly aprreciated.

cheers.
 

A:Removing a Table without deleting the data within the table!

Read other 16 answers
RELEVANCY SCORE 40.4

Okay i am a self teaching HTML person... I get the jist of the tables but for some reason I cannot get this one to work for me. The location i am working at is
http://www.geocities.com/sweetcheekies2/
I cant get the main name to center from the blue side line and the links on the left to stay within that small space on the left.
i know i will prolly have to resize the SweetCheekies Suite Name that i can do no problem.. just need to know the table or tables to keep the rest centered or withing bounds of what i am trying to do.

thanks
Sweet
 

A:[SOLVED] table help

Read other 13 answers
RELEVANCY SCORE 40.4

Can someone take a look at my two pages?

Notice index.html has light blue tables that are 90% width.

Pools.html is also 90% width but looks much smaller. It does't appear that it's covering 90% of the dark blue table.

I am trying to make them both the same but I can't quite figure it out.

Any ideas anyone? Thanks in advance.
 

A:Solved: Table help please..

It seems OK with Mozilla Firefox (see the attachment).
But with Internet Explorer, you're right. The Microsoft HTML is not standard.
 

Read other 3 answers
RELEVANCY SCORE 40.4

Hello!

I am new to the IE Forum!

I would like help with IE 7 keyboard/mouse commands for choosing tables and table elements (i.e. <TD>). I know this is no problem in Firefox. If I want to choose a <TD> element in FF, all I have to do is point to the element I want and press the Ctrl + <left mouse> and the element is chosen. If I want to choose a whole table in FF, all I have to do is place my mouse beside the table and press the Ctrl + <left mouse> and the complete table is chosen.

My question is, can I do something similar with Internet Explorer? I hope so, I am running another application that works better in IE.

Thanks for any help on this matter!

Gary

Read other answers
RELEVANCY SCORE 40.4

I have two access tables I would like to merge data into one table. How to do?

I tried blank database importing one by one but result is I get two tables not one.
 

A:Importing data from one table into another table

You are going to have to write an insert query. If you view it in SQL mode it would look something like:

INSERT INTO MyTable1
SELECT *
FROM MyTable2;
 

Read other 2 answers
RELEVANCY SCORE 40

I'm trying to help out a friend long distance with a computer issue. I'm fairly certain that she has a bad hard disk. She can boot her computer and work on it but it is very slow and non responsive at times. Her HDD is a Seagate. I had her download their disk utility and it failed 3 out of 4 of the HDD tests. Windows XP refuses to run a check disk on it.

I'm assuming that this is an actual physical problem with the hard disk itself and not something that a repartition/reformat would take care of. She is going to replace the drive but I'm just curious for my own knowledge whether or not this could be something other than a physical hardware problem.

Any ideas?
 

A:Solved: Can a bad partition table cause this?

I've never had this happen to me but i would say you are correct in saying that HD is bad. I would try and replace it or if there is a spare try that one. Also and this is just a suggestion. I never had good luck in the past with seagate. Western Digital makes a real nice HD.
 

Read other 3 answers
RELEVANCY SCORE 40

You may have seen programs like this in outlook and other places but my boss recently asked me to write him a program that had a table that the administration staff could mark their positions on. ie, In, Out, Office, Do not disturb. things like that. They also have to be able to log on and change thier location on separate accounts and everyone else has to be able to open it and view the table so they can find people. I honestly have no clue where to begin. any hints or pointers would be nice. (and do you think it would be better to just buy a program that does it instead?)
 

A:Solved: Location Table

Does your Company have Access?
 

Read other 1 answers
RELEVANCY SCORE 40

friends i made a pivot table report but its layout is not as my requirement i uploaded the sheet so please tell me how to make it as following
first i want to remove all plus and minus buttons and second when i expand the field it shows the records in "ledder" shape while i want that it show the records in front of each field as a simple excel table
please reply soon
 

A:Solved: Pivot table

Read other 16 answers
RELEVANCY SCORE 40

Aloha!! Using Access 2007 Im have a Form to capture caller information.

I need help creating a insert statement VB code to have Unique Case No inserted (write) into the tblComments table.
Currently the code is displayed =([UID] & [CaseNo]) MM100 on the form but does not write into the table.

Working:
Agent initials are recorded and a case auto number is assigned = example MM100
Simple fields look like this: UID=MM CaseNo = 100 (auto number)

NOT working:
The a Unique Case No is built by truncating =([UID] & [CaseNo]) ie.. MM100 NOT WRITING INTO TABLE.
 

A:Solved: Insert into a table?

Read other 9 answers
RELEVANCY SCORE 40

Hi All,
I am running a query which adds up scores like a league table. I then open a from which is linked to the query showing me the league table. The form is set to continuous form.

The form shows my data sorted from top to bottom like this.
Client A...........34
Client F...........23
Client Z...........20
ETC

What I want to do now is to add an index to show the leagure position:
1.....Client A...........34
2.....Client F...........23
3.....Client Z...........20
ETC

How do I add these number 1, 2 and 3 to my continuous form?

Simno
 

A:Solved: League Table

This might be to simple so it might not be what your asking, but just add the field to your table, and then add it to your query and then to your form.
 

Read other 3 answers
RELEVANCY SCORE 39.6

Hello,

I am trying to record a macro that will create a pivot table based on a
spreadsheet.

I am receiving error Num: 1004

Unable to get the PivotField property of the PivotTable Class.

The code that recorded is below. I am much more familiar with coding in
Access, so don't even know where to start here.

ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"tempPO_ExpSumm!C1:C4").CreatePivotTable TableDestination:="",
TableName:= _
"PivotTable4", DefaultVersion:=xlPivotTableVersion10
ActiveSheet.PivotTableWizard TableDestination:=ActiveSheet.Cells(3, 1)
ActiveSheet.Cells(3, 1).Select
With ActiveSheet.PivotTables("PivotTable4").PivotFields("Expeditor")
.Orientation = xlColumnField
.Position = 1
End With
With ActiveSheet.PivotTables("PivotTable4").PivotFields("LS_Date")
.Orientation = xlRowField
.Position = 1
End With
With ActiveSheet.PivotTables("PivotTable4").PivotFields("PO_Type")
.Orientation = xlRowField
.Position = 2
End With
ActiveSheet.PivotTables("PivotTable4").AddDataField
ActiveSheet.PivotTables( _
"PivotTable4").PivotFields("PO_Count"), "Count of PO_Count", xlCount

Thank you,
Roger
 

A:Solved: Pivot Table Via Macro

Read other 12 answers
RELEVANCY SCORE 39.6

I am constructing a pivot table, and all the columns are summing the data correctly, except one is showing numbers there are way off and like it multiplies.

I checked the value field setting and it is set correctly to sum like all the other fields.

Anyone guess what's happening?
 

A:Solved: Pivot Table problem

Read other 8 answers
RELEVANCY SCORE 39.6

hey guys i have a strange problem
the program that i need to code needs to have a value from the next record in the current record.

Pls see the attached pics to get a rough idea of what i need



i have tried to export the current table into temp table using
SELECT * INTO temp FROM table1

then delete first row of the temp table
then trying to append back
UPDATE table1, temp SET table1.nextn = temp.num;

what i get is just the last record value(see attached pic actualresult.jpg)


What can be done is to use manual coding to read betwwen records but the db i have is HUGE and going back and forth to get next records is going to kill my app.
pls help
 

A:Solved: Add Selected Fields from different table using sql

Read other 16 answers
RELEVANCY SCORE 39.6

Hi All,

Does anyone know if there is a maximium amount of records that are allowed in an ACCESS table. I am currently working on a database which has 20,000 different sales orders in a single table.

Thanks
Simon
 

A:Solved: Maximium table Size

Simon, as far as I can see from the Access Specifications in access help there is no limit. So it is limited by the overall database size of 2 Gygabytes and how slow you are prepared to allow the database queries etc to get.
 

Read other 2 answers