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!

Register Log in
  • 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: peachmelba
  • Content: Threads
  • Order by date
  1. peachmelba

    Forms date format error

    Can anyone help with this. I have a field on a form which is a short date (dd/mm/yy) format. When I input 31/06/04 there is a check on the value to make sure it is a date using Isdate funstion. This returns true as it thinks that the date is actually 04/06/31. I can't think of a way to sort...
  2. peachmelba

    Missing commas in a CSV file

    I have a file that I have created in Excel which has 21 columns. This is saved as a CSV file. I then import this file into Access using the following Set rs = db.OpenRecordset(strTableName) Do While Not EOF(1) i = 0 rs.AddNew Do Until i = intNoImportFields...
  3. peachmelba

    Pivot Table Formating

    Has anyone managed to format a pivot table from code. I have managed to format the labels and the data but can not find a way of formating the totals. Currently I use for the labels:- pvtField.LabelRange.Font.Bold = True pvtField.LabelRange.Interior.Color = intcolGroupBy...
  4. peachmelba

    PivotTable formating

    I need soem help formating a dynamicaly generated pivot table in Excel 97 from and Acess 97 database. What I would like to do is change the back colour of the groups. For instance I have three levels of grouping b) Product, b) Scenario and c) Test Group. What I would like to do is give each...
  5. peachmelba

    Sendkeys "^@"

    Help Have an application that I am converting and it uses the following:- Sendkeys "^@" Does anyone know what this does?? Regs Peachmelba

Part and Inventory Search

Back
Top