Over 1 million tech questions and answers.

Adding and Total Up Numbers in a Table

Q: Adding and Total Up Numbers in a Table

Hi All,

Anyone know how to add and total up numbers in a table cell? Thanks.

npd

RELEVANCY SCORE 200
Preferred Solution: Adding and Total Up Numbers in a 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: Adding and Total Up Numbers in a Table

Read other 6 answers
RELEVANCY SCORE 64.4

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 59.2

I have a table / spreadsheet price list that's a full page... I want to double all of the numbers either by percentage or just double everything as a total.

For instance: 240.00 afterwards should be 480.00

I want to double everything at the same time.
The prices that need to double are in C through R, 8 through 52 and everything inbetween.

Is there a way to highlight the entire square table and just double the numbers? or off the page put the percentage of how much you want to increase the totals by? I've looked at templates but can't figure out how to apply the formula to what I'm doing.

When responding, please be very elementary in explaining on how step by step... I haven't worked in excel in many years and have had a stroke since.

Thank you,
 

A:Excel: How Do I Double the Numbers in the Table?

Welcome to the board.

In a free cell, enter the number 2. Then copy that cell.

Select the cells you want to double, then Edit > Paste Special > Multiply > OK.
 

Read other 1 answers
RELEVANCY SCORE 58.8

   HOW DO I  TOTAL A COLUMN OF NUMBERS?

A:How do I total a column of numbers?

KMV2 wrote:HOW DO I  TOTAL A COLUMN OF NUMBERS?Hi, Which software do you use ? You need a software to do that, for example: Microsoft Excel. Otherwise you have to do manually using a calculator OR using the built-in calculator under Windows 7: (a) Click Start,(b) Click All Programs,(c) Click Accessories,(d) Click Calculator. Regards.

Read other 1 answers
RELEVANCY SCORE 58.8

I am trying to run a Pivot Table when I get the results some lines displays a number in others it displays what looks like a number with E-11 or another number after E. If I try to change format to number I get 0 I tried formatting the entire column where the data is as a number before I run the Pivot Table same results. The file is large over 185,000 lines. I am using Excel 2013, Windows 7 Enterprise. I attached screen shot. if I go in data and filter just one of the lines like PIFY16 I get a number.

Row Labels Sum of Transaction Amount
MATCH15 2480195.12
MATCH16 2353353.51
MATCH17 985627.83
PETFY15 -304116.01
PETFY16 30350
PETFY17 194834.93
SPIFY11 0
PIFY12 1.45519E-11
PIFY13 -8.73115E-11
PIFY14 -5.82077E-11
SPIFY15 8.73115E-11
PIFY16 1.45519E-11
BASICFY12 -7.23003E-09
TRGQFY14 2.72848E-12
 

Read other answers
RELEVANCY SCORE 58.8

Hi,

I am creating a long document in Word 2007. I have chapter numbers and I have set the table numbering system to show chapter number and table number e.g. Table 6.1. All this was going well, until for no apparent reason I got this.....Table 0.1. So it is not recognizing the chapter number any more and it has started number the tables from scratch from this point.
Can anyone suggest what the problem might be, please.

Regards
Ryanf1
 

A:Word 2007 Problem with table numbers

Does nobody know how to fix this problem. I'm getting desperate

Regards,
Ryanf1
 

Read other 1 answers
RELEVANCY SCORE 58.8

I've never worked with MS Access before, just Excel, so I'm not sure exactly how to fix this problem. I have a file that has a few tables in it. Each entry has an "ID" field, which basically numbers the rows starting at 1. Before, each time you start a new row, the ID field would automatically be filled with the next consecutive number. Now, it just gives 0.

I've looked around a little bit, and I think I know where to start. If I put the table in Design View, and then put the right expression into the Default Value box, I think that will do the trick. However, I don't know how to write the expression I need. In Excel, there were row/column labels...can anyone help me with what I need to do?

If there is any difference between how to accomplish this in Access 2.0 & Access 2002, I'd like to know that too.

Thanks!
-mati
 

A:Access - auto-generating numbers in the table

Read other 7 answers
RELEVANCY SCORE 58

I changed the formula in column a source data worksheet so that it returns some negative numbers.

A pivot table using this data source, doesn't include these negative numbers in its sum total.

Not sure why its not included in the sum total.

If I highlight the entire column in the worksheet, the total does include these negative numbers.
 

A:Solved: Pivot table not summing negative numbers

Read other 11 answers
RELEVANCY SCORE 56.8

When I send an email that has a Word 2003 document attachment with a Table of Contents, the page numbers in the Table of Contents all change to the same number even though I have about 10 pages in the document. I am opening the document from within Outlook. Strangely I am able to Ctrl click on each 'same number' and link to the correct page. I'm using Outlook 2003 for email.

Note that I have refreshed the Table of Contents before sending the document.

Hope someone can help. I don't want to send out proposals with the Table of Contents looking so wrong.

Thanks for any assistance! spinningjennie
 

Read other answers
RELEVANCY SCORE 56

Not as easy at it sounds!

I have a cell with the following:

C16W45Y108

I need excel to calculate the total of these figures e.g =
16
45
108

this should give me a total of 169.

These figures are random e.g.
Y189
F2C77W10Y177

in each of these i would like the totals to be show eg:
Y189 - is 189
F2C77W10Y177 - is 266

Im stuck....

Read other answers
RELEVANCY SCORE 56

I have a company that sends people out into the field, the job may take more than one day and they may sell the same and different items each day. I am looking for an easy way to total these things up. I know Excel pretty well, but I can't figure out macros. What I would like to do is;be able to input Item #'s, have it look up the Description (which I know how to do), then I enter amount used, then on the side somewhere have it "auto sort" and "auto total" in either format as shown in Option #1 or #2 (I would really like it to show Option #2 & 1) Then I can review it with each item listed in order and give it to my secretary to enter into my invoicing program.

Item # Description Amount used
101 Truck 1
102 Pencils 6
205 Paper 8
215 Eraser 4
318 Envelope 10
101 Truck 3
319 Paper Clip 2
102 Pencils 5
318 Envelope 8
101 Truck 5
217 Ink 2
319 Paper Clip 8
205 Paper 2
215 Eraser 4


Option #1
Item # Description Total Used
101 Truck 9
102 Pencils 11
205 Paper 10
215 Eraser 8
217 Ink 2
318 Envelope 18
319 Paper Clip 10
Option #2
Item # Description Total Used
101 Truck 1
101 Truck 3
101 Truck 5 9
102 Pencils 6
102 Pencils 5 11
205 Paper 8
205 Paper 2 10
215 Eraser 4
215 Eraser 4 8
217 Ink 2 2
318 Envelope 8
318 Envelope 10 18
319 Paper Clip 2
319 Paper Clip 8 10
 

A:Adding numbers from jobsheets

Read other 10 answers
RELEVANCY SCORE 56

Could somebody help me . I need to print a Word file, but every print has to be numbered. There surely must be some way of doing it automatically. HELP
 

A:Adding Numbers to a Printout

print out of what in what program
adding what type of numbers

assuming word
assuming page numbers
assuming XP

on the top menu
Insert
page numbers
 

Read other 3 answers
RELEVANCY SCORE 56

Please can you tell me how to add page numbers to documents in Libre Office Writer.

Thanks
 

Read other answers
RELEVANCY SCORE 56

I need an Excel formula that will add a column of numbers by the date in which they (each number) occurred. The dates and numbers in sequence (which helps). For example, to add all of the monthly payments (by month) that will occur between 10/1/04 and 10/1/05 (in this case one payment per month) what could I use as a formula?

Help would be appreciated as Hurricane Francis blows right over my head here in Orlando.
 

A:Adding numbers between know dates

Here ya go: http://www.dicks-blog.com/excel/2004/03/sumif_between_t.html
 

Read other 1 answers
RELEVANCY SCORE 55.2

Is there some way to make it so page numbers display on the printed pages of an Adobe .pdf file? I converted a Word document to .pdf, but the Word document did not have the numbered pages. I now want to add the numbers in Adobe Reader, but it looks like I'll have to go back to the original Word document, add headers which include the page number, and then re-convert it to .pdf. Is that correct? If I could do it within Adobe Reader, that would be preferable.
 

A:Adding Page Numbers to .PDF document

The file is a creation from an original Word file, the page numbers would need to exist in the Word file.

It would be a nightmare if in creating a PDF it was able to assign new printed page numbers as these would often not align with the original document and TOC's would be incorrect.
 

Read other 1 answers
RELEVANCY SCORE 55.2

Hello,

I am having trouble with Excel 2003 automatically adding the last digit in a Postal Code. For example, when I type in "R3R 4K5" in A1 and then click the corner of it and drag it down a couple of cells it goes from "R3R 4K5" to "R3R 4K6" and "R3R 4K7" and so on.

Is there an option that you can disable to prevent this?

Thanks!
 

A:Solved: Excel adding numbers

Read other 10 answers
RELEVANCY SCORE 55.2

Im using windows 10 totally updated version and the problem im facing is that windows keeps adding numbers after my WiFi name/SSID and the number keeps on increasing. It aint causing any trouble with network usage but I still wanna fix it and wanna know whats causing this. Ive attached a picture with this thread where u can see the wifi name states Redmi 7 but my network name is just Redmi. This 7 was 2,3,4... some days ago. Please help me asap with this issue ill be grateful.
 

A:Windows keeps adding numbers after my WiFi name

I don't understand why that is a "problem" or why you are bothered, but I don't need to understand. In Network Connections you can right click on the connection name and select Rename and call it whatever you wish (within reason). I should add that you could do this in previous versions of Windows but I'm only assuming the ability has not been removed in Windows 10.
 

Read other 1 answers
RELEVANCY SCORE 55.2

I have a new 11e laptop, 3rd Generation. Everything was working good. All of a sudden, the keyboard when typing only the middle row letters of "a,s,d,f, j, k, l, ;" a number will be added in front or to the back of the letter. All other keys are typing fine. I have checked for anything NumLock that could be related to causing this. Nothing in BIOS Set. Checked keyboard settings - the correct language is set. I tried to press FN+F11 and nothing. I turned on the online keyboard and clicked on NumLock there and turned it off, that did not fix it. I attached an external keyboard, that types fine. Turned on and off num lock, that did not fix it. I did a restore back to a date before it happened, that did not fix it. I just reimaged the laptop and that did not fix it. Any suggestions would be much appreciated!

Read other answers
RELEVANCY SCORE 54.8

About a year ago, I created an input form that contains a subform in which are listed all the contributions of a member of the organization. Under the subform -- IN THE MAIN FORM, not within the subform -- I had placed a field that summed the contributions for that individual, and another field that displayed the domain sum (DSum) for all contributions. Both have worked perfectly every since.

The field that sums the contributions for the individual used the formula "=[Contributions subform].[Form]![ContribSum]". The field that does the domain sum is "=DSum("Contribution","Contributions")+IIf(DSum("MatchAmt","Contributions") Is Not Null,DSum("MatchAmt","Contributions"),0). I removed the field "MatchAmt" from the table, and changed the DSum statement to just "DSum ("Contribution","Contributions").

After doing that, both field yield only "#Error". Part of my puzzlement is the field "ContribSum". It is not a field in either table, and is nowhere in either form. I haven't the foggiest where it is or why the formula refers to it. I tried using just "=Sum([Contributions.subform].Form![Contribution]), but that for some reason reports only the first contribution; doesn't add all of them up.

So my question is, how does one sum number fields in a subform in a field OUTSIDE of the subform/in the host form?

Help!
 

A:Adding numbers in a subform (Access 2000)

Put the "=" back in front of DSum, so that it says this:

Code:
=DSum("Contribution","Contributions")
The "#Error" means that Access is trying to do some sort of operation that it can't pull off.

As for your sum question, it's cagey, unless you can program a little. The workaround is this:
In the subform, show the form footer. There should be a control there called ContribSub, I'm guessing, from your post. If not, make one.
Set its control source to

Code:
=Sum([Contribution])

Once you're sure the subform sum is working, you can set the Visible property of the form footer to false. That way you don't see your total down there.
Now you can build a control source on the master form whose control source is set to

Code:
=[Contributions subform].[Form]![ContribSum]

As for why your other attempt wasn't working (the one that goes like "=Sum([Contributions.subform].Form![Contribution])"), you must remember that Access maintains only one "active" record at a time, per form or subform. So your control wasn't lying; I'll bet changing records in the subform would prove that. But it's only adding the total of the active record--this is the big difference from a report, where there are no active records.

Hope this helps. Let us know.
 

Read other 2 answers
RELEVANCY SCORE 54.8

Is it possible to add two currency Fields in a table and have that sum reflected in a Field in the same table?

For example here are the field names (Item cost $
Item Tax $) and I would like a field in the same table to be called (Item total$) containing the sum of the other two fields.
 

A:Adding fields in a table

Well...if you're talking about Access, it's definitely NOT advisable to put a calculated field in a table. You do that in a query, then base a form or report on your query, or do it directly on the form or report.
 

Read other 1 answers
RELEVANCY SCORE 54.8

Hi Techguy,

Have attached a access database. Once you click "New WF", you can see the fileds listed.

In the field "Amount" that has to be in "Currency format" also it has to be reflect in the front sheet.

requirement 2 :

In the field "Remainder" i need a list has to be pop up as "Remainder 1", "Remainder 2", "Remainder 3".

As i just created both "Amount" and "Remainder" column but its not working, can you please amend the database and help me to get this done.

I could not be able to attach database tool..... i would appreciate if you could count provide me clear comments on this, so that i can amend the tool.
 

Read other answers
RELEVANCY SCORE 54

Hello All,

I am using batch manager in Omnipage Professional 17 to convert batch of PDF files to text files using Omnipage.

Now the problem is i want to add some indicator specifying page numbers to separate different pages of PDF files in my text file.

as an example suppose there is an PDF file with 5 pages getting converted to a single text file using Omnipage then i want to add page number in my text file to separate each page content available in PDF file pages.

I went through help docs of batch manager but do not find any configuration option to do this.

Please let me know if anyone have solution for this.

Thanks,
Piyush.
 

A:Omnipage + Adding Page Numbers to PDF File pages

Maybe this will help you http://www.a-pdf.com/number/ . It's a free utility to add page numbers to pdf files.
 

Read other 2 answers
RELEVANCY SCORE 54

Hey!

I don't know it it's appropriate subforum to ask it, but as i'm under Windows 7 i thought it might've been a right place to start with.

Technically what i mean is i've got a row of numbers in notepad, like:

555555
543434
645454
454545
etc

What i'd like to do is automatically put a syntax in front of these numbers, like:

thisdoesthat?id=555555
thisdoesthat?id=543434
thisdoesthat?id=645454
thisdoesthat?id=454545
etc

I've got tens of thousands of such numbers, thats why it has to be done automatically.

Can you do it somehow with CMD perhaps? Or do you need any external program. If so, which one?

Thanks!
 

A:Adding random syntax in front of numbers automatically?

Read other 11 answers
RELEVANCY SCORE 54

Good morning,

I have the code below, which includes comments:

"

Sub AIRLog()

' AIRLog Macro

'Names the worksheet "AIRLog"
Sheets(1).Name = "AIRLog"

'Insert new column at Column O. This is to concatenate Columns L-N for the "Actions / Impacts / Resolution" column.
Columns(15).Select
Selection.Insert Shift:=xlLeft
Range("O4").Value = "Impact / Action / Resolution"

'Removes the Table Style previously set by exporting AIRLog from SharePoint
ActiveSheet.ListObjects("Table_AIRLog").TableStyle = ""

'Formats the table to create customized Table Style
Rows("1:1").Select
Selection.Insert Shift:=xlDown
Selection.Insert Shift:=xlDown
Selection.Insert Shift:=xlDown

Range("A1:T3").Select
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
Selection.Merge
Selection.Font.Bold = True
With Selection.Font
.Name = "Arial"
.Size = 12
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ThemeColor = xlThemeColorLight1
.TintAndShade = 0
.ThemeFont = xlThemeFontNone
End With
ActiveCell.FormulaR1C1 = "Actions - Issues - Risks Log"
Range("Table_AIRLog[[#Headers],[ID]]").Select

'Changes all ... Read more

A:Solved: Adding Columns to a table using VBA

It may be that when the macro starts, more than one column is already selected. What happens if you put Range("A1").select at the beginning?
 

Read other 2 answers
RELEVANCY SCORE 53.6

Hello group,

I wasn't quite sure how to word the subject line. I would like to be able to add a number to column A everyday and have the cumulative sum of column A show in column B in the adjacent cell so I can chart it. So it would look something like this:

1 1
1 2
1 3
2 5
-1 4

I think it's something to do w/the SUM function but I can't quite figure it out. Any help much appreciated.

Harold
 

A:Solved: Excel: Adding Numbers in a Column on a Daily Basis?

Read other 7 answers
RELEVANCY SCORE 53.6

I am using a query in Access to clean up some unneeded text from a table, then create a new table with the cleaned up text. In addition, I need to add a column to this new table that is boolean format defaulting to a "no" value. I have successfully created this query except for the new boolean column. I can get the new column to default to a value, either no or 0, but it is in text format. If anyone knows how to do this I would appreciate the help.
 

A:Access-Adding a field to a table with a query

This query will do it:

ALTER TABLE TableName ADD COLUMN NewColName bit
 

Read other 3 answers
RELEVANCY SCORE 53.6

Hi,
I've been playing around with this and can't figure it out...
I'd like to add a sold versus capacity percentage (I call it Load Factor) to a pivot table. I have attached my sample file with my notes. Could someone please try to help me out?
Thank you so much.
Fern.
 

Read other answers
RELEVANCY SCORE 53.6

Hi-

I would like to add a field to the end of my table called Timestamp. I want this field to be populated with the current time if a record is updated. I know I can set the default to =Now(), but that only sets the time and date the record is created. If I go in an update this record, that time or date does not change. Is there a way to inset a time and date that would automatically change? If not, is there an easier way then to just type in the time and date manually? Any suggestions would be appreciated. Thanks!

Ian
 

A:Adding a timestamp field in a table in Access

Have you tried =Date() ? That is what is used in the contact management database that comes with Access 2000.
 

Read other 1 answers
RELEVANCY SCORE 52.8

Hello...

I've created an automatic table of contents in Microsoft Word 2007. So far so good.

Once the table was created, I renamed all of the content lines to make them shorter and catchier, especially as some of the headings were actually paragraphs.

I have now added a little section right in the middle of my document. I'd like for this to show up in my table of contents.

When I ask it to update the numbers only, it doesn't add in the new section into the contents list.

When I ask it to update the whole table, it changes all my lines back to the originals.

Honestly, all I want to do is add a new section. Can I insert / link it manually? Can I automatically update without changing all the line names? Any other magical and/or mystical methods to do this?

#despair

Many thanks in advance :)

Nathan

Read other answers
RELEVANCY SCORE 52.8

Hi there
I've googled but I can't seem to find the answer here

I've got an EXISTING table in a document and need to add some more Rows (Word 2007).

In Word 2003 it was easy - you just put the cursor into a cell in the table and pressed the TAB key -- extra row appeared. Even in the menu there was a facility INSERT ROW / Column.

Word 2007 seems to makes a nightmare of a simple task (I'm normally an EXCEL user so Word isn't my main Office App).

I googled -- but couldn't find anything.

I got this info -- very good at what it does but FAILS because it omits what must be the obvious question -- Adding Rows / columns AFTER you've created the table.

How do I... Create and format tables in Word 2007? | Microsoft Office | TechRepublic.com

Cheers
jimbo

A:Adding ROWS to an existing table in Word 2007

Right click a row and insert:row above or below

Read other 5 answers
RELEVANCY SCORE 52.8

Hi! This is probably a pretty basic question, but I can't find an answer anywhere here or on the net. How do I add new fields, using VBA, to an existing table in Access? Without destroying thd data? My process: I initially import, using VBA, an Excel spreadsheet into a new table (this table is replaced each month by a new spreadsheet.) To facilitate my analysis of the data contained in that table, I need to add several fields to that existing table. Those fields will be used to store the results of several automated processes using that data. Because the table is created from the spreadsheet provided by another department each month, I need to add the new fields each time I import the spreadsheet. I am trying to do everything in VB because the final user needs to perform all functions by merely pushing buttons on a "Switchboard" My version is MSAccess2003. Thanks for your help!
 

A:Solved: Adding a new Field to an existing table in Access using VB

Read other 12 answers
RELEVANCY SCORE 52.8

I have an old database with customer info in it. I am working with a new database however, that has some of the old customers in it. The old database has some customer details about these customers that I would like to have in my new database. I am having trouble adding the data from the table in the old database to the table in the new database.

So far I have imported the old table into my new database and have tried to Insert Into the New Customers table the CustDescriptions FROM the Old Customers table WHERE FirstName=FirstName And LastName=LastName And Address=Address. This did not work it just added new rows to my table instead of inserting the data into the current rows where the criteria matched.

Any help on how to make this work would be great! Thanks ahead of time.

swebster
 

A:Access 2000 - adding additional data to a table

Hi - firstly are you using different or the same versions of Access? Secondly I would just cut/copy and paste the records from table to table but you must ensure that the properties for the fields are identical.

stepheno
 

Read other 3 answers
RELEVANCY SCORE 52.8

I'm trying to build a template in Powerpoint that involves several tables on one slide. After I complete a table and have it resized and positioned where I want it...any time I try to add a new table to the same slide, the existing tables in the slide get resized and repositioned to some default size/locations forcing me to resize and reposition everything again. Is there anyway to stop this from happening?
 

A:Powerpoint: adding table resizes existing elements

What version are you using? Are you starting from another template design? If you are using 2003, try starting with a blank slide for the layout, then insert your tables seperately and you should be ok. In 2007, you should not be having this problem.
 

Read other 1 answers
RELEVANCY SCORE 52.8

Hi everyone,

I have a macro that retrieves some data to excel and populates an excel table (listobject) using vba. The table is large (8000+ rows and 6 columns). There are another table that does some calculations based on the first table. Although the calculations is set to manual, when I send data to the table , I have an impression that the second table is recalculated too, because it takes a lot to add the data (but if I remove the second table it takes just a few seconds compared to 1,5 minutes).
The same is with the table resize.

Can somebody to advice on how to set excel so it calculates everything at the end of the code and not when the data is added to the table. Currently this settings are in place:
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Application.EnableEvents = False

Using Excel 2010 and 2007.
 

A:Solved: Adding data to excel table (listobject)

Read other 16 answers
RELEVANCY SCORE 52.8

You guys have been a huge help in the past with issues I've had with Software Licensing database I created in Access, so I'm hoping you can lend a hand with a new issue I'm running into:

i copied some data from a table to do some comparison and clean up in Excel. I realized a little late that I should have pulled more fields than I did... I have done the clean up and now I'd like to get the additional fields to finish the job. I've imported the cleaned up data as a new table (Table A) and want to run a query against the original table (Table B) to pull those additional fields. Not all of the records in Table A are present in Table B, and vice versa.

In the query design, I show Tables A and B and join the First Name, Last Name and Application fields. The Join Properties are to include all records from Table A and only those from Table B where the joined fields are equal. Table A has 1606 records, so my hope is to have the query return 1606 records with the missing fields added. I'm bringing in all of the fields from Table A and adding the missing fields from Table B.

The query returns 1899 records. I ofound one user who only has four records in Table A, three records in Table B, and the query is returning 12 records for them.

What am I doing wrong?
 

A:Access 2010 - Adding fields to a table using a query

Read other 16 answers
RELEVANCY SCORE 52.4

I need to add an field to an index in a table using VB but I keep getting getting

Run TIme Error 3376 Cannot Append. An object with that name already exists in the collection.

Below is an example to try. What I ultimately want to do is add a field to an existing index but in this example I simply try to create anew index and add fields to it.

In this example, I create a table named "t New Test" then try to create an index that would be appended into the TableDef Indexes collection for that table (if I could get as far as adding Fields into the new Index in question.
Code:
Sub TryCreateTableWithIndex()

Dim CDB As DAO.Database
Dim TDFS As DAO.TableDefs
Dim TD As New DAO.TableDef
Dim F As DAO.Field
Dim NewIndex As DAO.Index

Const NewTableName As String = "t New Test"

Set CDB = CurrentDb()
Set TDFS = CDB.TableDefs

'Check to see if there's an existing table with the name we want...
'If already exists then quit
For Each TD In TDFS
If TD.Name = NewTableName Then
Beep
Call MsgBox("Cannot proceed.. a table named " & NewTableName & " already exists", vbOKOnly + vbCritical, "Table Already Exists")
Set TD = Nothing
Set TDFS = Nothing
Set CDB = Nothing
Exit Sub
End If
Next TD

TD.Name = "t New Test"
Set F = TD.CreateField("R... Read more

A:Solved: MS Access having trouble adding a field to an table index in VB

This appears to be a case where you have to know the "magic incantation" to make things work.

I was under the mistaken impression that you could just get a field definition from any convenient source (like the TableDef.Fields Collection) and append it to the Index.Fields Collection.

Rather, you MUST apparently use the Index.CreateField method on the Index object
and then append the resulting field to the collection.

In the example above, replace
Code:
'''''''''''''''''''''''''''''''
'This is where the code fails...
'says there's already an object with that name in the collection
NewIndex.Fields.Append F
with
Code:
'''''''''''''''''''''''''''''''
'This work nicely now
Set F = NewIndex.CreateField("Rec No", dbLong)
NewIndex.Fields.Append F
I don't know what havoc might be wreaked if the field definition appended to the Index.Fields collection is different from the field definition (of the same name) existing in the TableDef.Fields Collection.
 

Read other 1 answers
RELEVANCY SCORE 52

I began noticing that it was a problem after it started rapidly climbing past 70% today (before it was lingering at 60% for months). I have been researching the problem for a few hours and most of the problem solutions I have found do not work for my current problem. It currently is lingering at 94% and causing my computer to run slowly. I am not sure what to do from here on.

A:Task manager - memory usage not adding up to total used

Welcome to the forum.
Post a screenshot of Task Manager - Performance tab so we can see the situation.

Adding up the memory usage in the process list will never equal total memory usage. It was never intended that it would. The default configuration of Task Manager does not show all process usage and there are major users of memory that are not processes, not all of which are shown in Task Manager.

Read other 2 answers
RELEVANCY SCORE 51.6

I'm very much a newbie at using Adobe Live Cycle Designer (only got it a couple of days ago) so please bear with me.

I am using the trial version of Designer ES2 v9 and Action Builder to create a form with buttons to allow users to dynamically add new rows to a table. That part I have managed to fathom out on a test form I'm playing with but the problem I have come across is that when I test out the function in Preview PDF, anything below the interactive table (i.e. other tables, text boxes etc.) are not being moved down the page in sync with the new rows. Eventually, if enough rows are added, the interactive table overlaps anything else below it.

Is there something I can do to make objects below the interactive table move down the page as new rows are added?

I have attached the test PDF which I hope illustrates my problem.

 

Read other answers
RELEVANCY SCORE 50.8

I have built a query that subtacts time in and out on a daily basis and gives me the number of hours worked for the day.

Day1: ([tblTimeSheet]![Day 1 Time Out]-[tblTimeSheet]![Day 1 Time In])*24
Day2: ([tblTimeSheet]![Day 2 Time Out]-[tblTimeSheet]![Day 2 Time In])*24 ,etc.

My problem is: I want to add the times together to get a weekly total but I haven't been able to figure out how to do this.

Any suggestions?
 

A:Solved: Timesheet issues, adding daily totals to get weekly total

Read other 8 answers
RELEVANCY SCORE 48.4

I am using outlook contacts and would like to add phone fields to the phone numbers in the detailed address view e.g. another mobile , home 3 , business 3 , packet 8 etc...
I tried everything and consulted every book , but no way . The addition will show up if I switch to phone list , but not in the detailed view .
Any suggestions ???

Thanks ,

M.K.
 

Read other answers
RELEVANCY SCORE 45.2

Hey everybody.

I don't know if the title is a good one for this problem, but here goes.

I have a column that has numbers in this format: 54321-1234

Now, I want to take off the last 4 numbers, and the dash, from all the numbers in the column, using a formula. So that the output would be: 54321.

I want it so the first 5 numbers stay the same, but the dash and last 4 are gone. Is this possible?

Thanks.
 

A:Solved: Excel 2003: Replacing Large Numbers with Smaller Numbers

Read other 13 answers
RELEVANCY SCORE 44.8

This was asked before by KlausdB:

"I have 4 x HDDs on SATA AHCI (Intel Controller) in Native Mode and 1 x ESATA on Win 7 Pro X64.
I noted that looking in Admin. Tools\Computer Management\Storage (as an example) the 1st HDD (Port 0 in the AHCI BIOS) is showing as "Disk 2" instead of my expectation of


"Disk 1".
Selecting the Drive's Properties correctly shows the "Location 0 (Channel 0, Target 0, Lun 0)".
I also note that the Disk Number allocation in Windows will change randomly after some reboots/startups - going anywhere from "Disk 1" to "Disk 4".  I can force/replicate this


behaviour by removing the ESATA drive.
Is this expected behaviour?
It doesn't appear to create any operating issues at this stage, however, is there a way I can force the Drive to always map to (eg) Device 0 --> Disk 1, Device 1 --> Disk 2,


etc?
Thanks."


 This was answered by Nicholas Li:

"As far as I know, how the disk is plugged physically and the order it is displayed are not related. For a simple example, if a drive is plugged to SATA interface 4 and it is the only disk, it will be displayed as Disk 0. If there is no related issue about
the disk order, I think we can safely ignore this."


 Because the topic was closed I want to ask a new question here:
 What happens if one of the 4 HDD drives or 5 has an OS installed on it? I ask because windows always write some bo... Read more

Read other answers
RELEVANCY SCORE 44.4

I have three SATA hard drives :
Main system/boot drive , WD Caviar Black 1 TB, connected to the SATA 0 port
A backup drive, identical WD Caviar Black 1 TB, connected to the SATA 1 port
Another dirve, Hitachi 1 TB, connected to the SATA 2 port
When I installed Win 7, only the main drive was connected... and it remains the only drive with active/system/boot partitions.

QUESTION 1.
All three drives reporr correctly in the BIOS, and in the right order, but why is it that only one of the drive (the one on SATA port 1) has a "SATA:" prefix and the others have a "HDD:" prefix ?

QUESTION 2,
Why is it that the assignment of Disk #0, 1, 2 ( as seen in Disk Maanger or DiskPart) does not seem to have nay rhyme or reason?

I would have expected:

- the hardrive connected to SATA port O, to be assigned as Disk 0
- the hardrive connected to SATA port 1, to be assigned as Disk 1
- the hardrive connected to SATA port 2, to be assigned as Disk 2

but instead, I have:

- the hardrive connected to SATA port 2, is assigned as Disk 0
- the hardrive connected to SATA port 0, is assigned as Disk 1
- the hardrive connected to SATA port 1, is assigned as Disk 2

Just curious why that is.

I am assuming there is no way to chagne this. Its not something I would dream of reinstalling Windows 7 to correct ( even if it did correct it).

A:SATA port numbers vs assignemnt of Disk numbers/

Best advice, leave it alone. It may bother your (and others) sense of order but it won't affect how anything works, and no re-installing Windows won't change it.

Read other 9 answers
RELEVANCY SCORE 43.6

I was checking my program and software list and at the top of the list I noticed two (2) sets of numbers that I have never seen before. I checked the internet to see if I could find out what they were. It kept taking me to sites for spyware, adware,etc. I could not find out what they were or why they are on my system. I do not want to remove them until I know what they are. I have not noticed any problems with my system, but I do not know what might be going on behind the sceen. The numbers are listed as follows:
{684CB795-C157-4E15-93D4-E26015FEF1EA}

{F850707C-B6A0-4B56-8709-F89CF8F9AC6D}

ANY HELP?

A:Found Numbers Unknown Numbers In System

The first one > http://www.acresso.com/products/is/i...d-overview.htm

The second one > http://eraser.heidi.ie/

Both are legit and not malware.

Read other 1 answers
RELEVANCY SCORE 43.6

I have been given four transcripts of telephone calls recorded at a call centre. All at different times on the same day. Two have the same callID number. The sequence of the numbers attributed to each call are odd. The first call has a higher number than later calls and the last two are also out of order. I am not sure if this is the right forum but i am desperate for some help. The transcripts are VERY important and I cannot be sure that they are the real deal because of the callID numbers. Any suggestions? Thank you in advance.
 

Read other answers
RELEVANCY SCORE 43.6

I have Windows XP, with Wordpad v5.1 and Notepad v5.1 as well. In Notepad, if I toggle off Word Wrap, I can then toggle on the Status Bar, and it shows me the line and column number in the status bar. It does not look like Wordpad has the ability to show line and column numbers. Does anyone know if there is a way to show that in Wordpad? Thanks.

Read other answers