Sorry about the delay on this, but the code works perfectly!
Thanks Smiley!!!!
noclueforid
Last Activity: Dec 15 '11, 02:28 PM
Joined: May 19 '10
Location:
-
Thanks, Jim.
I tried that and it worked OK, but in the process came up with another solution to just output it directly to pdf using the following code:
Thanks for your suggestion!Code:DoCmd.OutputTo acOutputReport, "rptInvoicingIOC", acFormatPDF
Leave a comment:
-
Converting a Report to PDF (2007)
Hello again!
I have a report that contains information from four different queries. Each of those four queries prompts the user to enter a date range to find the records needed. When I open the report, it prompt the user for these date ranges, then populates the report accordingly. All is fine.
Now, when I go to save that report as a pdf document, it requests those same date ranges again. Is this normal or is there a... -
Ahhh..the effects of long hours of work......narro wed it down as suggested and one of the queries with date entry was the culprit. I forgot to put "Between" in front of the statement.
Thanks!!!Leave a comment:
-
Data showing in Layout View but not in Print Preview
I have a report with 4 sub reports on it. Each sub report contains a total from the related data in it. The expression I use in the report footer for each sub report is:
curJSRAmount is of course different on each sub report, corresponding with the related data.Code:=Sum(Nz([curJSRAmount],0))
I then total those 4 sub report totals on the main report footer using:
...Code:=Nz([rptTraining].[Report]![Text4],
-
Thanks for your post, NeoPa. I do fully understand how hard it is trying to decipher the questions asked sometimes.
Since I am fairly new to Access (only used for about 2 years off and on), it takes me a bit to go through the code and completely understand what it is doing. I'm not one to just copy/paste code in, I like to understand what it is doing and why its there.
Once I get through it, and if I have more questions,...Leave a comment:
-
Yes, I have looked at it. I'm sorry for not getting back quickly, other projects took precedent for a few days.
I am probably what you call a casual user of Access, so its taking a little bit of time to understand the code, but I am working through it! I thank you for posting it!
What I don't understand is what NeoPa is asking me though. I thought i was pretty clear in what I was asking, and I fully understand what I need...Leave a comment:
-
I'm sorry, yes, a button would initiate the code after the two dates were entered.Leave a comment:
-
Okay, let me try to explain this a little better. I have two tables, tblStudents and tblPayments. The student table contains all the students personal and contract info. The payments table contains all the payment information. The student pays once a week, with the payments due by Saturday. What I am trying to do is insert every Saturday date into that table for each student. With the Saturday dates calculated and inserted, there is less chance staff...Leave a comment:
-
One record for each date. The sub form is going to be for making payments every week. This way, auto-populating should prevent "missing" dates if the user has to manually type in all the dates.Leave a comment:
-
Populate a subform date control based on main form date range controls
Hello!
On my main form I have two date controls, dtmTrainingStar tDate and dtmTrainingEndD ate. On a sub form, I have a date control dtmWeekEndingDa te. What I would like to do is auto-populate the sub form control with all the Saturday dates between the main form date range controls.
If this is possible, how would you go about doing it?
Thanks!!!
Dave -
What's the best way to keep a user on a control...
I want to add some data validation to a control, and keep the user there until the data is entered correctly. What I am trying to do is force a user to enter a correct date, based on another date field.
...Code:Private Sub Training_End_AfterUpdate() If [Training_End] > DateAdd("d", 1092, [Training_Start]) Then MsgBox "The Training End Date is greater than 156 weeks from the Training Start Date.", -
Event that triggers when...
I would like to know what, if any, event fires when the record navigation buttons are used. I have to log every time a user views a record and I am having difficulties when multiple records display after a search.
Thanks!
Dave -
Error "Undefined function "Coalesce" in expression.Leave a comment:
-
The form that displays the results of the query is completely blank. If I do not have any payments for "State", its all blank. If I have at least one payment for each type of grant, its ok. But thats not likely to happen every year, so I need it to show even if there are no payments made to it.Leave a comment:
-
Okay, this is what it looks like, but it still does not work:
SELECT Payments.Grant_ Name, Sum(Payments.Pa yment_Amount) AS SumOfPayment_Am ount
FROM Payments
WHERE [Payment_Amount] Is Not Null
GROUP BY Payments.Grant_ Name
HAVING (((Payments.Gra nt_Name)="State "));
Where am I going wrong?Leave a comment:
-
Ok....pretend I'm not that good with Access...becaus e I'm really not....is that in the query itself, or in the form for the pop up window?Leave a comment:
-
Query question
I am having an issue with the attached sample database. It tracks payments made on a training contract. The user enters the students name, date paid, payment amount and a grant source.
The grant name field is a drop down list of available grant names. If the user double clicks the box, it will show a pop up window with the grants: amount total paid on them, amount of the grant, and amount left on the grant.
The problem... -
The back end will be on a network drive, the front end on the users private drive.
All the VBA code, which isnt really much, is compiled.
The accde file is a 4mb file.
I wish I could post a copy of the database, but due to security where I work, i am unable to.
If there are general areas that would make it slow, other than the ones you have already suggested, it could lead me doqwn the...Leave a comment:
No activity results to display
Leave a comment: