Search results

Is it possible to print a report that is based on a text box that is coded now()? CoachPhil

Would this do it? .PatternStartDate = "#Text30#" .PatternEndDate = "#Text42#"

Hi all, Answer is probably right in front of me but I have been looking at this so long I am brain dead! I am connecting to Outlook from my DB, setting a 'reminder date', I have the following code in the cmd button, Set objRecurPattern = .GetRecurrencePattern...

Gents, Worked like a charm, thanks to all. CoachPhil

Hi all, Not sure how to word this (part of the problem), I have a form with 3 comboboxes- 2 for dates and 1 for employee name. I need all three items to call the report correctly, a report on a specific employee for a specified time period. I am callimg from a query and all the info is...

Gemma, You are a genius, worked like a charm. Thanks for the refocus on the real issue. CoachPhil

Hi Troops, I have a Report, driven from a query that gives me employees, the number of transactions in a time period, and the number of seconds in total. I have summed and averaged the total transactions-no problem. The total seconds I was able to convert to hh:nn:ss. But.............. I...

Bob, after the changes, the report calls all info from the query, not just the specific employee- I get a 5000 page report. Any ideas to narrow the search to employee specific records? CoachPhil

boblarsen-you are my hero, I will try this on my program and give you an update tomorrow CoachPhil

Hi All I have a report where I am trying to pull an employee and all related info in a query between selected dates. I am using one combobox for the name, a second for the start date and a third for the end date, SURPRISE---I can't make it work. What would be the best way to proceed? CoachPhil

as always, you are on the mark, thank you George

I have a Division by Zero error when I run a report. I believe I have traced it back to a query, an expression in the query ‘ACHT: Nz(AgentDataByMonth!t_logged_in/AgentDataByMonth!n_incoming,0)’ returns an 'Error' on lines where there are zeroes in the calculation. Am I on the right track...

Gemma, Turns out that I had a bang in my code, thank you CoachPhil

I am getting the error message ‘Out of Stack Space’ when I run one of several reports from my DB, but only on one report. Any ideas why? CoachPhil

Paul, Its a TimeConvert() function and I am using the same query and parameters as the other three reports? I will verify what is passing, thank you CoachPhil

Ladies and Gentlemen, Is there a legitimate reason why a function in a module would work in three reports on a db app, but not a fourth on the same db? CoachPhil

Thanks Gents, I got one and am working on the others. CoachPhil(football)

I am trying to relate a calulated amount in a report as a percentage. How possible is this from a text box in a report? CoachPhil

raskew and namliam, you were both right, raskew your additional line of code; 'Here is an alternative method, which would display 1530 minutes as 01:01:30 'Format([Minutes]\(60*24),"00") & ":" & Format(([Minutes]\60) Mod 24,"00") & ":" & Format([Minutes] Mod 60,"00") and namliam, you were...

Namliam, You are the man! works perfectly, thank you CoachPhil