Don't know if this could be the problem but I noticed that you're also checking for an empty string (""). You could also check for NULL.
Ex.:
If IS NULL (Leaving_Date) then
Hope that helps
Miss Yu
I want to create some kind of summary report, basically like the Who Does What report but with subtotals of each project.
So, I would like a report that will show each Resource, list the projects they are working on, the hours they have worked so far (Actual Hours and not Assigned Hours)and a...
I'm using Access 97. Isn't the "Can Grow" property only so that a field can expand if the contents are bigger than the set size? Then, the "Can Shrink" will shrink if the field is smaller, but it stays a BASE size doesn't it?
These are Fields in a table. There isn't any code to show you unfortunately. Basically, I inherited this database and they want a custom report.
So I just went in and used the report wizard and generated this report. There are 10 table fields where I want to display the field name if that...
Hi,
I am trying to show a list such as:
Groceries:
Apples
Oranges
Bananas
Where all the listed fruit is actually different variables (ex. Fruit1=true, Fruit2=true, Fruit3=true). I know this is not the best way to do this however, this is the way it is set up and I must find a way to...
I am still reviewing this as an option. So far, I find it's ok as long as everybody is on a project. Since there is customizable "Non-working" (name is misleading, am currently using as Non-Project time) time, this helps but it seems cumbersome.
Katerine (& Rick),
You are AWESOME!! This worked beautifully. Rick's instructions were great but it was your step by step instructions that helped me set this up properly!
Thanks a million!
Thanks Gord,
But that did not work. The reason I don't close the form until after I open the report is because the form is passing values to the report. By closing the form and then opening the report, the report runs and then the dialogue box looking for parameters doesn't open up.
The way...
Hope someone can help me.
I've done this a million times but for some reason, it's not working. My code:
*************************************************
Private Sub cmdOK_Click()
If DCount("*", "qryRptAppsPerDept") = 0 Then
MsgBox "No data to report"...
Katerine,
Did this work for you? I'm using Access 97 and I'm having problems trying to use it. Do you just put the code that Rick provided above behind a button? (I'm trying to use it so that On_Click, I can browse for a file - is this the intent?) All I did was paste the code On_Click of a...
Disappearing Report!
Prompts user for date parameters, and then generates the report but then doesn't set focus to the report?
I use docmd.openrpt and then docmd.close form and this generally works but for some reason it: 1)opens the report, 2) closes my popup window and then 3) brings the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.