Access Questions - HELP

[Guest]

So I am building an access database to track our projects at work. I have a
few questions, that I can't seem to find an answer for...

1. How can I make it so anything with a past due date display with a colored
background.
2. Can I set a button on the form to hide completed projects?
3. How would you be able to create a query of all uncompleted projects? For
all users, and per user.
4. Can I set a button on the form to hide completed projects?
5. Is there a way for access to automatically back itself up?
6. How would I pull up a report on any data within the records?
7. We have a field in the database that asks how long each project took; how
would I create a pie chart showing the person that requested the work and how
long it took to complete.
8. How can I set up the table to only display tasks by user.

 

[Jeff Boyce]

Juniper

I'll take a run at your questions ... see comments in-line below.

Regards

Jeff Boyce
Microsoft Office/Access MVP

So I am building an access database to track our projects at work. I have
a
few questions, that I can't seem to find an answer for...

1. How can I make it so anything with a past due date display with a
colored
background.

What will have a colored background? The entire form? Only the field?
(You ARE working in forms, right?)

2. Can I set a button on the form to hide completed projects?

If you change the underlying source of the form to include/exclude rows. Or
would you want to have the form ONLY display incomplete projects?

3. How would you be able to create a query of all uncompleted projects?
For
all users, and per user.

Without some idea of how you've organized your data, it would be tough to
suggest a specific way to get the incomplete projects back out. How do YOU
decide a project is complete or not? Could you tell Access that?

4. Can I set a button on the form to hide completed projects? Isn't this #2?
5. Is there a way for access to automatically back itself up?

Depends on the version you're using. On the other hand, to "back up"
Access, you could simply copy/paste the file. Or, if you have a split
database application, with the back-end (data) portion on a network, usually
the network has some form of autmated backup.

6. How would I pull up a report on any data within the records?

Whoa! ANY data?! You'll need to spend time learning how to create reports
to better understand that this is not an insignificant undertaking.

7. We have a field in the database that asks how long each project took;
how
would I create a pie chart showing the person that requested the work and
how
long it took to complete.

Pie charts depict portions, percentages of a whole. Something showing the
person who requested the work and how long it took to complete has neither
portions nor percentages.

8. How can I set up the table to only display tasks by user.

Don't. Don't work directly in the table, work via forms. If you want to be
able to see tasks-by-user, you'll have to include "user" as a field on your
"assigned task" records.

 

[John Vinson]

So I am building an access database to track our projects at work. I have a
few questions, that I can't seem to find an answer for...

1. How can I make it so anything with a past due date display with a colored
background.

With "Conditional Formatting" (if you have A2000 or later). Select the
textbox on the Form (if you're using table datasheets... don't; they
don't have enough flexibility, use a Form instead) and choose
Format... Conditional Formatting from the menu.

2. Can I set a button on the form to hide completed projects?

Yes, provided there's something in the table to indicate that a
project is completed (we don't know what that might be since you
haven't posted your table structure). In the button code set the
Form's Filter property:

Private Sub cmdHideComplete_Click()
' Hide or unhide the completed projects
If Me.FilterOn Then
' they're already hidden, unhide them
Me.Filter = ""
Me.FilterOn = False
Me.cmdHideComplete.Caption = "Hide complete projects"
ELse
' they're visible, hide them
Me.Filter = "[Completed] = True"
Me.FilterOn = Yes
Me.cmdHideComplete.Caption = "Show all projects"
End If
End Sub

3. How would you be able to create a query of all uncompleted projects? For
all users, and per user.

Using criteria appropriate for your tables, which you have not shown
us.

4. Can I set a button on the form to hide completed projects?

See 2 above.

5. Is there a way for access to automatically back itself up?

No. Backup is best done by backing up the entire .mdb file outside
Access, in fact while Access is closed.

6. How would I pull up a report on any data within the records?

By creating a Query that returns the data that you want reported. See
3.

7. We have a field in the database that asks how long each project took; how
would I create a pie chart showing the person that requested the work and how
long it took to complete.

See 3.

8. How can I set up the table to only display tasks by user.

See 3.


John W. Vinson[MVP]

 

[Guest]

You mentioned the conditional formatting. I was able to get to the point
where I think I'm supposed to be at but my question is, in this box, it
doesn't accept the firld name. So what I want to do is have something like
this:
If "today's date" is greater than "due date", and the "completed?" field is
not checked (false), then change form background (or due date field
background) to red.

 

[Guest]

To clarify the original post, There is a "completed?" field with a check mark
(true/false). I was able to create a button that you press that applies a
filter to only show records where the "completed?" field is false
(unchecked). Can I make the button change so when the filter is on, it
changes to Unhide which then removes the filter? If so, How do I do that?

2. Can I set a button on the form to hide completed projects?

Yes, provided there's something in the table to indicate that a
project is completed (we don't know what that might be since you
haven't posted your table structure). In the button code set the
Form's Filter property:

Private Sub cmdHideComplete_Click()
' Hide or unhide the completed projects
If Me.FilterOn Then
' they're already hidden, unhide them
Me.Filter = ""
Me.FilterOn = False
Me.cmdHideComplete.Caption = "Hide complete projects"
ELse
' they're visible, hide them
Me.Filter = "[Completed] = True"
Me.FilterOn = Yes
Me.cmdHideComplete.Caption = "Show all projects"
End If
End Sub