Search results for query: *

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...

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...

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...

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...

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

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...

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

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...

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

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...

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...

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...