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: indyaries
  • Content: Threads
  • Order by date
  1. indyaries

    Horrible Excel File Woes

    I have a large Excel file formatted thus; COLUMN A 1 Full Name 2 Full address 3 City State Zip Columns B and on have other information for the employee in Column A, and is located on the same row as the City-State-Zip. I need to get the employee information in Col A into a tabular form, such...
  2. indyaries

    Form-Subform Referencing

    Greetings, I need to have something that happens on a tabbed subform to change the value of a textbox on the main form. ********************************************************* MainForm = f_Employees MainForm textbox = txtCount Tabbed Subform = fSub_Personnel_Actions_subform_2 Tabbed Subform...
  3. indyaries

    Getting time into crosstab?

    Greetings, Management wants to see who is doing what type of input in a given period of time. I've gotten the information saved to Excel, which returns the timestamp that the employee input a certain document into the system (document types can be PO, INV, RR, MOD). I've managed to split the...
  4. indyaries

    Table & Relationships questions

    Greetings, Have questions on Table design and Relationships. Using Access 97 SR1. I have Time & Billing info that I'm working with. Every 2 weeks, I receive a new batch of data. It arrives as an Excel spreadsheet, which I convert to CSV. I then import into Access using an Import Spec...
  5. indyaries

    Query Emergency !!!!!

    Using Access 97 SR1 Greetings, I've inherited an emergency that I cannot seem to resolve in a payroll database. The DB is run strictly from Macro's. Hoping someone can help with this ASAP, as this process must be run this morning (Now 08:20 in Indiana) I need to add two APC codes to the 3...
  6. indyaries

    Multiple IIF statements in Query

    Work-Access 97 SR1 Home-Access 2000 Greetings, Apologizing for the long post. Analyzing Time and Billing. I receive a flat file in Excel every two weeks, which I append to an Access file. A large portion of the analysis is capturing errors between the HourTypeCode and WC5. As of now, I have...
  7. indyaries

    Parse a field

    Access 97 SR1 Greetings, I have a field that I'm trying to extract a portion of the text. I'm using this expression, but it's not returning what I need. WC1...
  8. indyaries

    Printing PAGE FOOTER only on 1st page

    Greetings, I have a form that display an employees Performance Plan, which is based on the employees job description. I have created this report to match the actual paper form this info normally appears on. The report is set up thus: The PAGE HEADER contains generic Form information, plus...

Part and Inventory Search

Back
Top