Search results for query: *

Hi, I have taken the HD out of my fried laptop and used a HD adapter to hook it up with my desktop so that I can recover the data. The desktop sees the drive but the folders will not allow me to access them. I keep getting a "access is denied" message. How can I get around this? Thank you...

Thank you very much all of you for all your help.

Is there an adapter that will hook a laptop HD up to another laptop? Could you tell me a little more about what the PCB is for?

Ok, laptop had a spill of water in it. Yes it fried and smells lovely. I pulled the hard drive out, can I use a cable to connect it to another laptop to pull the data off of it. If so what cable is this? Also is there any real danger to this laptop that I will be using to get the data from...

how do I do a count of the milestones that are in each status category. I'm sorry but I am new to access and I don't quite understand how to do this.

Hello everyone. I am trying to create a main report that shows the count of each milestone in each possible status catagory and then calculate the percentage for example: Total Milestones: 204 Milestone Status Total Milestones Percentage COP Underdevelopment 61...

I don't know if anyone is still interested in helping me out with this one but here are the select statements again. Main Query: SELECT MilestoneStatus.Id, Milestone.MilestoneStatus, Count(Milestone.MilestoneStatus) AS CountOfMilestoneStatus FROM MilestoneStatus INNER JOIN Milestone ON...

Ok, I just wanted to know is there a way to have drop down list in a cell, so that a user clicks in the cell and options drop down that they can choose from for that cell. I am trying to create a sheet where certain cells have to be chosen from a approved list of options. Thanks for all your help.

PastDueQuery SELECT MilestoneStatus.Id, Milestone.MilestoneStatus, Now()-[PDDMSDate] AS Expr1 FROM MilestoneStatus INNER JOIN Milestone ON MilestoneStatus.MilestoneStatus=Milestone.MilestoneStatus GROUP BY MilestoneStatus.Id, Milestone.MilestoneStatus, Now()-[PDDMSDate]HAVING...

Main Report SELECT MilestoneStatus.Id, Milestone.MilestoneStatus, Count(Milestone.MilestoneStatus) AS CountOfMilestoneStatus FROM MilestoneStatus INNER JOIN Milestone ON MilestoneStatus.MilestoneStatus = Milestone.MilestoneStatus GROUP BY MilestoneStatus.Id, Milestone.MilestoneStatus...

My appolagies I pasted the wrong control source. Sorry. =Round(([CountOfMilestones]/[TotalPastDueMilestones])*100) this is actually what I meant to paste in there.

Control Source for Percent text Box: =Sum([CountOfExpr1]) CountOfExpr1 is the number of milestones in each status. Yes there is only one record for each status.

Well I have a main report that is counting how many milestones are in each status and then calculates the percentage that is of all the milestones: Total Milestones: 204 Future start: 53 26% COP underdevelopment: 61 30% and so on down the list of possible status options...

I assumed that this was just a very simple problem, that it happens often. Being that I am so new to this I thought that it was probably easy to fix I just don't know enough about what I am doing. I didn't expect you to solve all my problems, just maybe give some possible reasons why this...

Hi, I have two reports. One is a subreport of the other. They are simple reports that are calculating totals and percentages. The problem is that the subreport is showing 100% on all of the data. When I view the subreport by itself it shows all of the correct percentages. Why are the...

I'm sorry I havn't been vary clear. I am not trying to generate the titles. I need to figure out how many milestones are in each range. And then take that and figure their percentage. The titles can be static in report.

The "days past due" ranges will not change those will be the ranges that they will always want to see. Table Name: Milestones MilestoneNum PDDMSDate P02-MS-01 11/28/2004 P02-MS-02 11/28/2004 P02-MS-03 3/28/2005 P02-MS-04 1/28/2006 P02-MS-05 2/28/2006 P02-MS-06 3/28/2006 P02-MS-07 6/28/2005...

Hi, I have a table with milestone info. In this table I have a date that I want to create a report based off of. This is what I need it to look like: Total Past Due 73 Up to 7 days past due 3 4% 8-30 days past due 13 18% and so on...

So, I have built a database and I have set all the users and passwords and such. Now the powers that be have changed their minds and say they don't need security. How do I get rid of all the security? I am the owner and admin user.

Yes, that took care of it. Thank you for all your help.