Recent content by Excorsa

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