Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: gearhead03
  • Content: Threads
  • Order by date
  1. gearhead03

    Will not boot, invalid system disk

    This morning my computer gives me an invalid system disk message and will not boot up. Windows XP Home edition. Ran System Mechanic recovery console and it didn't find any issues with the MBR or Partition tables. Then I put my Ubuntu boot disk in. Ubuntu is NOT installed in this PC. At the...
  2. gearhead03

    Group and Sum in Excel

    I have a spreadsheet that on each row has a load number and rate columns. (among others) I would like to have the program sum the amounts in the rate column based on the load number cells being the same. For example if three of the rows have 9595 in the load number column it would sum those...
  3. gearhead03

    Sum a field

    I want to sum a field in a query without grouping by week, month, year, etc.... The field to sum is "amount" When I select "sum" on the total line it's not summing all the records in the query, it gives several lines and I am not sure what criteria it's using. what should I set the other...
  4. gearhead03

    Sees drive in BIOS not in windows

    Wife's CPU locked up last night. A restart would not get past the boot from cd.......... ChkDsk ran about 25% and gave a "corruption error" Installed in different machine with WinME on it as a slave. The BIOS picks up the drive but it's not found in Windows. Booted into DOS and the drive still...
  5. gearhead03

    Formulas used with Sum Function

    Excel 2000. I have a worksheet that I use to keep track of my truck driver's hours to make sure they don't go over. They can have 70 hours on duty in 8 days. I enter their daily "on duty" hours in column "D" and then in column "E" I sum them using Sum(d1:d8) and copy that down the page for the...
  6. gearhead03

    Update 1 table based on a different table

    I have a customer that send me a file once a month. I can import this into a table. It will have about 10,000 records. I need to write a query that will update two fields in each record in my table to the values from the table that I get from the customer. How is the best way to do this or what...
  7. gearhead03

    Is it possible to make an excel spreadsheet an access form?

    I have an excel spreadsheet that is an inspection form for trucks we have. Is it possible to make it an access report to make printing the reports out easier? Can it be imported into access? Mark A. Kale
  8. gearhead03

    Order by Multiple fields

    This should be simple (I think) I want to order my form by two fields; 1st: Cleared is not null 2nd: ClearedOrder ascending I can't find a reference on how to do more than one field. Thanks in advance for the help! Mark A. Kale
  9. gearhead03

    Excel 2000 Formatting issue

    I think it's a formatting issue. I have a file that I use to bill one of my customers. They built the file. Several columns are calculated. They have 459 rows set up. We usually use 35-40 rows. When I print, all 50 pages print. How do I get rid of the extra rows? I have tried to delete them...
  10. gearhead03

    Tab order on a subform

    I have a form (FormCheck) that has a subform (SubFormAppliedCatergories) on it. The subform has 3 fields on it. 2 of them have to be entered for every record. How do I include the 2 fields on the subform in the tab order so they get hit every time and then switch back to the main form. Mark A. Kale
  11. gearhead03

    Unable to call value in subform

    I am using this line to call a value. =[Forms]![SubFormAppliedCatergories]![CatergoryCombo].[Column](1) This works when the form is standalone. When I place this fomr in a different form (FormCheck)as a subform I get a #name? error. What am I missing? Mark A. Kale
  12. gearhead03

    Simple coding giving me a fit

    I am trying to set up an IF statement. I have done this type thing before but for some reason I just can't seems to get everything to work correctly. The fields are: Miles - Numeric Weight - Numeric Rate - Currency RateType - Text The first Condition is: RateType = "Flat" then BaseRate = Rate...
  13. gearhead03

    Per record, running sum, on a tabular form

    I have been working with this for several days. I am attempting to make a check register in an existing database. I would like a tabular form that shows the amount of the check or deposit and right next to it the running total. I can't figure how to make it happen. I am not a code wizard. I have...
  14. gearhead03

    PC takes a long time to boot up

    My brother has a Dell Diminsion 3100. P4 256MB RAM Windows XP SP2 It takes a very long time to boot up. I have checked the start up items and there doesn't appear to be any spyware. It has also had SpySweeper running on it since it was new. He also runs McAfee anti-virus and site watch. I turn...
  15. gearhead03

    Power Point 2003 - Video Clip

    I have a Power Point presentation that has a video (.wmv) file in it. The presentation is going o be sent to someone else and then to someone else. I have just found out that the video doesn't go with the presentation! So when it ismoved from CPU to CPU the video portion doesn't work! Is there a...
  16. gearhead03

    Most used file list in Excel 2000

    Is there a way to "sticky" files in my most used file list? Once a week, I have to open several files and it pushes the ones that I use most often off the list! Thank You! Mark A. Kale
  17. gearhead03

    Conditional Formating

    In Excel 2000, I am trying to highlight a cell based on the value of another cell. Example: cell A1 will be highlighted (regardless of the value within it) if cell a6 is not null (or empty). I can use conditional formatting for values contained in a cell but can't find where to set it up from...
  18. gearhead03

    Can I attach a file?

    Is there an easy way to attach a file to a record in Access? I have a database of Drivers that we use and I would like to be able to attach the .jpg files of there drivers license, medical card, and others forms. Thank you for your help Mark Mark A. Kale
  19. gearhead03

    How do I use Access application on HP 2200?

    I have an IPAQ HP2200 I want to be able to use and sync Access applications on this unit. Active sync give an access option but the files do not seem to work on the PPC. Am I missing something? What is the best way to do this? Mark A. Kale
  20. gearhead03

    Dead after windows intro screen - Win XP

    I have a Dell computer with P3 and SATA hard drive. When you boot, the Windows XP intro screen comes up, then the monitor goes blank and nothing else happens. I have tried the following items; Booting in Safe Mode - Doesn't work. It goes through the long string of white writing and then stops...

Part and Inventory Search

Back
Top