Maximum rows and columns in an Access 2003 datashet

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Project
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Date help I am working on a project in which I need to provide dates to the same recurring set of tasks for different classes. The dates need to be a week before training delivery or 2 weeks before 4 weeks before etc. Is there some way that I can customize the task to provide dates in this fashion? -- Gina Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122923
  - 2
    - Auto e-mails linked to tasks & milestones I am using MS Project 2003 & Outlook. Is there a way in MS Project to have e-mails auto-send to assigned resources (as reminders for starting & finishing tasks & milestones)? Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122922
  - 3
    - Gantt Chart print range? Is it possible to print an entire schedule (all tasks) but self-select a date range for the Gantt chart? In other words, I'd like to print my entire schedule of tasks, but not print the first few years of the project's gantt. I hope this makes sense! Thanks, Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122920
  - 4
    - Current Date How can I choose today's date as the current date to perform filters? Harry Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122919
  - 5
    - Filtering Slipping Tasks with an Interim Plan I would like to create a filter that identified slipping tasks for an interim plan. My understanding of the Slipping Tasks filter is that it is based on the original Baseline. Thanks in advance for your time on this matter. Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122918
  - 6
    - Resource Assignment Information When you double click on the assigned resource, you will get a Assignment information window. In the assignment information area, under the work contour field, what is the difference between contour and flat? -- Jackie Duncan Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122910
  - 7
    - Project 2007 Trial How do I open the *.IMG file that I downloded and saved on the desktop for the trial. It does not open either from a disk or from the Desktop. -- Hagai Erel Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122893
  - 8
    - "Do you want to re-establish links?" nag screen upon open Using hammock tasks. I get the above nag screen upon opening the .mpp. Is there any way to edit the global settings in the app to accept by default and therefore eliminate that nag? Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122891
  - 9
    - Gant Chart bar colour by Resource Name In Project 2007, is it possible to automatically format the bar colour in the Gant Chart view to vary by the Resource Name allocated, thereby providing a visual overview of the task allocations and resource requirements? Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122890
  - 10
    - Graph generation.. We are aware that the function --- ReadStatusTimephasedData --- of the statusing web service can be used to obtain time-phased information about the Assignment work and the Assignment Actual Work. Is there a function in the PSI to return time-phased BASELINE work information? We need this time-phased baseline information in order to generate a graph of the way BCWS changes over time. Is there a way for this is to be achieved?? Yours Sicerely, Shishir. Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122886
  - 11
    - How to calculate weekly total Hi, Has anyone a way of showing on the usage table a total for the combined resources on a weekly basis? Basically, what I have is a table of all resources using peak units and require a weekly total on this at the base of the table eg: 1 CARPENTER +C 1,823hrs 1 1 2 3 3 5 5 5 2 JOINER +j 567hrs 1 4 4 3 . . . . (Here i want TOTAL) (1) (2) (6) (7) ......................... any suggestions...? Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122885
  - 12
    - Implications of using split versus reschedule I am wondering if anyone can explain to me the differences between splitting a task and rescheduling it. From what I have read, split is for task interruptions and reschedule is to change the time for work to start. When I perform both operations in Project, they look exactly alike. Any additional insight would be greatly appreciated. Thanks in advance. Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122882
  - 13
    - Iif statement in MS Project Could anybody can help me to use the "If" statements in trh Project shedule? MY objective is to have different alternatives for the same project in the same schedule. i.e some activities can be bypassed in some alternatives but have to be done in other alternatives. So anybody can help me on this ? Thanks & regards Reji Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122880
  - 14
    - How can I take the reports from the current baseline? Hi, I have a problem in taking the reports from the tool. I am getting the reports from the initial baseline. How can I take the reports from the current baseline? Thanks and regards, Varma Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122879
  - 15
    - Assign equipment to a task I've searched through several information sources and can't figure this seemingly simple problem out; My project consists of covering up an area with several layers of soil where each layer has its own specifications and volume. To do this, we use hydraulic cranes with a specific production speed per day (m3/d). The layers of soil (fixed work) are the tasks where I assign the specific soil types to (as material resources). Now I'd like to plan my project by assigning cranes with a fixed production rate (and price per day). Logically, by assigning more cranes the project finishes earlier. Problem is that I can't seem to vary the amount of cranes per layer to see what the effect is on the project's finisching date. Only way to find out the duration of the project is to assign a variable consumption rate to the material resource and fix the work. That way I can't easily change the amount of cranes and determine the extra cost. Thanks in advance Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122878
  - 16
    - Compare two tasks - Re-post Hi, as with a few others, my post has disappeared so im reposting the text, and responses so far from my query. Would be really grateful of any further help on this ! Thanks Steve ............................................................. Fair Point Jan !! I want to be able to calculate the difference in dates between tasks and show the output in a filed next to the task. For example Task ID 100 - Project Meeting 1/1/07 Taks ID 320 Project update 5/1/7 (Linked through various levels of predecessors to Task 120 not directly linked) So a custom field is required next to the tasks to show that there are 4 days between tasks 100 and 320. I understand that using VB this would not be dynamic, in that the coding would have to state the task id's and would need to be changed for each calculation needed, but this is fine. There are only 3 key milestones that i need to look at for this, so whilst it will not be a well used field, it's content is still worthwhile. Thanks Steve "Jan De Messemaeker" wrote: > Hi, > > It's hard to program a logic based on "e.g." > Is there a logiocal link between the tasks you want to compare? > > -- > Jan De Messemaeker > Microsoft Project MVP > http://users.online.be/prom-ade > "Steve268" <Steve268@discussions.microsoft.com> wrote in message > news:E25B15D3-B53F-4B20-9779-0E609F6C6195@microsoft.com... > > > > > > "John" wrote: > > > >> In article <F4115E28-1365-4452-9A2A-A3FB977207C6@microsoft.com>, > >> Steve268 <Steve268@discussions.microsoft.com> wrote: > >> > >> > Hi, > >> > this may turn out to be a really daft question and something covered as > >> > a > >> > basic, but i really cant find an answer to my perplexing problem ! > >> > > >> > I want to introduce a custom field, and compare the dates of TWO > >> > specific > >> > tasks within a project. > >> > e.g. Compare start date of Task ID 100 with Start date of Task ID 120. > >> > > >> > Is this possible? > >> > > >> > Any help on this would be appreciated, even if it's just a response to > >> > say > >> > that im missing the blatantly obvious ! > >> > > >> > Thanks all > >> > > >> > Steve > >> > >> Steve, > >> Yes this is possible but it can't be done with a formula in a custom > >> field, you will need to use VBA. Custom field formulas only work with > >> data in each task, they cannot work with data from different tasks. > >> > >> Hope this helps. > >> John > >> Project MVP > >> > > > > Hi John, > > > > thanks very much for the response. > > Do you have any idea what the VBA would be to sort this? or can you point > > me > > in the direction of where i can find it?? > > > > Thanks > > > > Steve > > > Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122876
  - 17
    - Resource display Would it be possible to display resources in different columns, depending on the resource group? Could I generate a report showing the different columns and tasks? Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122875
  - 18
    - Filter on Actual Work for a specific time range Is there any way to filter on tasks that only have actuals in them for a given week? I have tried multiple filters, and formulas but I have trouble in combining both of the actual work and the date range of the actual work. Thanks, Greg Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122872
  - 19
    - Title not shown once column hidden Hi, Why does the column name dissapear once a column is hidden and then shown? e.g. I named Text1 "team", then I hid it. When I inserted the column the title was gone but values are still there!!! Thanks in advance. Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122871
  - 20
    - Best MS Project 2003/07 hands-on training / techniques? I was wondering if someone knew of the best hands-on training of project 2003 or '07? This can either be a mentor, training vendor, on-line program, etc. I have basic usage down, but I need to know more hands-on advanced techniques. We do not have Project Server in our environment, but getting that solution in-house is not a big deal. However, I have an immediate need to make good with I currently have. Any suggestions and/or advice would be greatly appreciated. Thanks in advance for your help. Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122867
  - 21
    - Computer Based Training Hello: We are considering rolling out project server 2007 for the 1st time thru out the company. I need to evaluate the training needs and material. After quite some searches, I still couldn't find anything for project 2007 pwa. There aren't many books either since thr product is relatively new. Without training, we may not be able to successfully launch the deployment, any suggestions on good training materiaal is much appreciated. Thanks Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122863
  - 22
    - Resource Usage View not showing Actual Work or AWP This is in a Project Server 2003 environment. The time-phased portion of the Resource Usage view will display 'Work' and 'Cum. Work", and other fields, but will not display 'Act. Work' , Actual Work Protected or 'Base. Work' when they are added to the Details list. What am I doing wrong? Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122859
  - 23
    - Calendars and Duration I've set the default calendar in my Project 2007 project to a 6 hour day for internal resources and when I enter 6 hours, duration equals 1 day. I've added another calendar for Consultant resources that I've set working times to 8 hour days. How do I get the duration to equal 1 day for these resources when I enter 8 hours - right now it continues to use the 6 hour day. Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122856
  - 24
    - Burn down chart Does anyone know of a simple easy to use program that does burn down charts? I don't need a fancy package-but I need the capability of doing a burn down chart. Thanks, -- CJH Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122855
  - 25
    - Date format with and without Time in same project I would like to see all my dates without time ("7/03/06") in my Gantt, but, I would like a footer on my reports that shows the last saved date AND TIME for the file ( "C:\My Documents\Test ABC\ABC01 Project.mpp as of 8/25/06 2:11 PM"). "Tools>Options>View - Date format:" seems to control them both. Is there any way I can have different formatting in the footer? SigR Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122852
- Next
  - 1
    - Gantt Chart start date setting How do I have a Gantt Chart (the one that shows up in the right hand pane) begin with a date that I set? Right now it always starts from the current date. Thanks, -- CJH Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122851
  - 2
    - Timescale analysis Project 2007 has removed the timescale data analysis feature and resorts to Visual Reports for the same type of analysis. I was able to use timescale analysis to generate %complete "forecasts", but can't find a Visual Report setup that will include % complete, so I can't forecast and use the data to make useful charts in excel. -- RRickard Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122848
  - 3
    - Feedback about using Project to model Agile iterations I am considering the use of Project to model time boxed Agile Iterations. One of the challenges to this is that Agile is very team oriented. The team has reponsibility for completing several user stories (use-cases) in each iteration. Rigorously, I suppose this is equal to a single bucket task, modeling all the work done on the iteration, and a series of milestones, one for each user story, dependent on the bucket task. At the end of the iteration, either the user storeies were completed and tested -- or not. If they were completed, the milestore is set to 100% complete. If not, the milestone/user story is moved to the next iteration. Any Ideas? Any first hand experience? HOW Would Project Server 2007 help with this??? Can I assign resources to summary tasks in 2007 ??? Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122847
  - 4
    - edays How do I change days to edays, on the duration column, for summary tasks? Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122844
  - 5
    - Actual Cost greater than Planned Cost Hi all, I have one resource assigned to a task. The task duration is 8 hours and the resource costs $12.50/hour with $12.50 for overtime. The Planned Cost is therefore $100. After 8 hours of actual work being applied to this task we see that we need to apply at least 16 more hours of work to complete the task. When we complete 9 hours of work, we should have ACWP equal to $112.50, but instead it is recorded as only $100. Also, the BCWP should be $100. Instead, I have an ACWP equal to $100 and a BCWP equal to $0.00. Am I missing something? Shouldn't these values be $112.50 and $100 respectively? Thanks, Glenn Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122843
  - 6
    - Project 2003 & DCMA Has anyone yet had the experiance of having their project subjected to a DCMA evaluation? I'm curious as to what others may have experianced / learned from an evaluation. Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122842
  - 7
    - blank page I am using project 2003 when i try to open existing project file or even create new one i just get blank page. I have tried to repair the installation and have re installed but I still get the same issue. Any ideas anyone? Thanks in advance Ismial Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122833
  - 8
    - Project 2007 Crashes I just installed Project 2007 Professional. I also have Project 2002 and 2003 running on the same machine (I'm a developer and need them for testing). The machine has mostly Office 2003 components, XP SP2. The problem is that Project 2007 crashes every time I close it. Running Office Diagnostics ddid not fix the problem. Uninstalling and reinstalling Project 2007 didn't fix the problem either. Has anyone else experienced this? What else can I do? Thanks, Bill B Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122832
  - 9
    - Task Usage View-adding "cost" row Microsoft Project 2003 I am looking at the Task usage view and an example in a book (Show Me Project 2003). The example in the book shows an additional "Cost" row under the "Work" row. I only see the row "work" in my screen. How do I add a "Cost" row to the view? Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122828
  - 10
    - Why is Project 2003 Standard Crashing I am running 2003 standard. XP SP2, Office 2007 ... all applications are up to date with fixes, and updates. When I click on a resource to change the name... Project crashes. No other person has this problem, yet no one here is running office 2007 -- Frank D Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122824
  - 11
    - Move dates How do I insert a holiday in the middle of a plan, causing all dates to move forward the one day? Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122823
  - 12
    - Can I change the new Template dialog to use a list view over icons When our users click "File" >> "New" >> "On my computer.." to select an icon, it always defaults to showing the templates using large icons, making the names difficult to read. We must click on the 'list' button above the preview pane to display the templates as a list. Is there any way to configure Project to do this all the time??? Thanks RAS Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122822
  - 13
    - about Microfoft window XP Dear sir/Madam i have problem to open my Destok icon .pls help me. when i ckick it then message is coming like C: Documents and Settings\Administrator\Desktok\Disk clean up.Ink.is not a valid Win32 application.so i request to u plz help me. Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122818
  - 14
    - Synchronization problem of outlook 2003 with PWA Hello, I am currently using PWA of project server 2003 and outlook 2003. I have installed plug-in avaialble on PWA. I am importing tasks assigned to me in PWA with my outlook caleandar but all my PWA tasks are assigned based on USA calendar. Currently i am using GMT calendar in my outlook 2003. Can you please guide me about this problem? Regards, PS Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122811
  - 15
    - Outlined task Hello, I am using project server 2003 and project professional 2003. In PWA, I want to expand assigned tasks for each and every project along with the summary details under Task updates button. how can i do that? Is there any way to do it. Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122810
  - 16
    - Error open project Help please! A situation such! I keep the project on Project Server 2007, I close it and I return, all like perfectly in order but when I try to open it again it like as opens, the indicator but when it reaches the end is below visible, thinks a little and the message on restart Project 2007 stands out. Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122809
  - 17
    - Awesome Check it out: www.BrandonsMansion.com Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122807
  - 18
    - spreading a task over a longer period of time Hi, I have a task that is calculated to be 5 days and due to start on a given date, but it will not be done, done until another date one month from now. What is the right way to address this scenario? I don't want the task to show a start date of x and a finish date 5 days later, because it is 5 days over the course of a month. Thanks, -- Kari Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122803
  - 19
    - Unexpected results when importing assignments from Excel PROBLEM -- I import tasks, resources, assignments from Excel into a blank Project file. The resulting assignment units and work are unexpectedly changed by Project. Details of a test case to recreate this follow, as do my specific results. IMPORT MAP (Excel --> Project): Tasks: Task_Unique_ID --> Unique ID (merge key) Task_Type --> Type Name --> Name Resource_Names --> Resource Names Resources: Resource_ID -- ID (merge key) Name -- Name Max_Units -- Max Units Assignments: Task_Unique_ID -- Task Unique ID (merge key) Resource_ID -- Resource ID Resource_Name -- Resource Name Work -- Work Assignment_Units -- Units EXCEL DATA: Task (1): Task_Unique_ID -- 1 Task_Type -- Fixed Work Name -- Write code Resource_Names -- Bill[25%],Sue[55%] Resources (2): Resource_ID -- 1, 2 Name -- Bill, Sue Max_Units -- 25, 55 Assignments (2): Task_Unique_ID -- 1, 1 Resource_ID -- 1, 2 Resource_Name -- Bill, Sue Work -- 8, 12 Assignment_Units -- 25, 55 RESULTS: If I MERGE data: Task imports fine, resources are fine and the task has both resources assigned (no small event when I finally got that to happen!!). But the assignment shows: Bill at 55% and 12 hrs (should be 25% and 8 hours) Sue at 55% and 4.4 hours (55% is correct, but should be 12 hrs) If I APPEND data: Task imports fine. Resources duplicate, one set has the correct Max Units while the other has 100%. The assignments are doubled as well, both resources assigned twice to the task: Bill at 25% and 2 hrs Sue at 55% and 4.4 hrs Bill again at 25% and 8 hrs Sue at 55% and 12 hrs If I have Project CREATE a NEW project: It works!!! Which I just found out as I assembled this post! I will probably try to make that work, but appreciate any solutions for the Merging as that is what I originally intended. Help???! Please! Thanks! - Dale Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122802
  - 20
    - Changing Weekly timescaled data to show different date Our company works on a work week Sat-Friday. I do exports to excel that will show timescaled data, but it will show that Sundays date as the date for the start of that week. For Example this week it would show the data labeled 6/10/07. Ideally i would like my work week data to be Saturday-Friday and display this weeks data as 6/15/07. Is this possible ??? Thanks, J Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122799
  - 21
    - 2007 & LOE work Does 2007 allow a budget to disappear if not used? My client wants to forecast a resource at 10% level of effort for a maintenance role for 3 months. I used each scenario of the scheduling algorithms (Fixed dur/unit/work w/ & w/o effort driven) to allow unused work hours to disappear if not used. So far, each scenario only saved the unused work hours and pushed these unused hours ahead of the status date. We need this type of effort management to combine with each resource's budget when working both LOE and Project work. I am open to workable ideas.... -- Matt in Flower Mound Texas Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122797
  - 22
    - Linking Resouce Pools to Sharer Files I can't seem to figure out why I am showing duplicate tasks in sharer file and resource pool which is causing overallocations. When I open the resource pool alone, there is no overallocations. It will not allow me to remove the duplicate tasks ---- It gives me a message that it cannot remove because the project is connected to sharer file. --Jackie Duncan Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122795
  - 23
    - Error changing resource names Whenever I change resource names on my project. The system crashes and restarts Project. I loaded all security updates, and it does this regardless if Office 2007 is loaded or not. -- Frank D Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122792
  - 24
    - ntwk printing feature How do you add the timescale across the top margin of a ntwrk diagram? Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122790
  - 25
    - Summary Task Value and WBS Code not grouping I donâ??t seem to get much response so either the answers are already in the forum or they are just plain obvious but i would appreciate help with the following. In the resource usage view, i have the task summary name and wbs column inserted and it displays the appropriate value. However, when I group by these, it says there are no values. Any ideas? Thanks Tag: Maximum rows and columns in an Access 2003 datashet Tag: 122781

Is there a limit (like in Excel 2003) as to how many rows and columns you
can have in a datasheet?

Re: Maximum rows and columns in an Access 2003 datashet by John

John
Wed Jun 13 21:37:43 CDT 2007

In article <CF4FB1C5-BCAF-47BA-95D3-1F2407268D2A@microsoft.com>,
LambdaGirl1 <LambdaGirl1@discussions.microsoft.com> wrote:

> Is there a limit (like in Excel 2003) as to how many rows and columns you
> can have in a datasheet?

LamdoGirl1,
You have posted to a newsgroup that is dedicated to Microsoft Project, a
planning and scheduling application. I suggest you post to an Access
newsgroup.

John
Project MVP

Top