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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by bdog2g

  1. bdog2g

    Help with Access and Automation to Excel Templates

    I have an access database that has many tables created by importing several txt files. I'm using access to manipulate and organize the data, but the final output is to be in Excel. The Excel output is based on several templates and each template is based on the txt file. I have a form in...
  2. bdog2g

    Need help with Access and Excel Templates

    I have an access database that has many tables created by importing several txt files. I'm using access to manipulate and organize the data, but the final output is to be in Excel. The Excel output is based on several templates and each template is based on the txt file. I have a form in...
  3. bdog2g

    need help importing .txt files into Access

    I'm using Access 2000 I would like to import a comma-delimited .txt file generated by another program into an Access Table with the first line of the file being the field name. I would like to do this with VBA code. My problem is I don't need all 40 columns in the text file. I've used the...
  4. bdog2g

    Crosstabs and Month Order

    I have a crosstab query based on a table created by a make-table query. The crosstab produces the output I want but the month colums are in alphabetical order not chronological. I can't use fixed columns because dates for task completion are based on a subform input and vary for each task (i.e...
  5. bdog2g

    A challaging issue with unbound fields

    Jim Thanks for the help, I got it working yesterday...come to find out I had the code in the wrong form event...funny how you can waste two days on one thing and fix it 15 min before you get off work
  6. bdog2g

    A challaging issue with unbound fields

    Jim I used a variation of your first code and it gives me the information I want to use in a CrossTab query however, if I cycle through the projects I get an error because the Sub is trying to add the same data again, is there a way to code it so that once the record is written the database...
  7. bdog2g

    A challaging issue with unbound fields

    Jim Sure thing. Thank you for takin the time to help
  8. bdog2g

    A challaging issue with unbound fields

    Jim I tried your code however I'm having trouble passing the values for StartDate, EndDate, and MonthlyBudget from another subform on the page. Also I forgot to add that the dates on this table are generated from an overall project date. What I wanted this form to do was fill in the text...
  9. bdog2g

    A challaging issue with unbound fields

    Jim Thank you very much for lookin at my problem, Ima give it a shot and see what happens, I appreciate the help and time Brian
  10. bdog2g

    A challaging issue with unbound fields

    I need some help/advice on how to go about this last hurdle in my database. I'm trying to create a budget forecast array in MS Access. It is based on different tasks TASKID, each task has a start date and a finish date, along with a budget. This is and idea of the array I want to set up...
  11. bdog2g

    Need help populating unbound controls

    Ok...Here's the situation. I have a subform that has 24 unbound text boxes in the Form Header that represent 24 months of a project. these boxes are filled in dynamically based on a Project Start Date and Project Finish Date. For each task of the project I also have a row of 24 unbound boxes...
  12. bdog2g

    Need Help Filling in Text Boxes

    I have a data base that has ProjectStart Date adn Project Finish Date, well on a subform, I have a row of 24 unbound text boxes named Date1, Date2, Date3, etc. Is there a way in VBA to fill in these text boxes with dates in increments of month-year between the start date and the finish date...
See more

Part and Inventory Search

Back
Top