Recent content by ImStuk

Does anybody know where I might get some information on exporting a multi page report to Excel? A link or thread that can give me some idea's. I have a report of clients and a list of contacts for each client etc. Each client starts on a new page of the report. I want to export this report to...

I actually found an easy Solution to my problem. I just put a filter in the Query That is the Report Record Source. However, if somebody knows how to insert a filter into the send object string I would still love to know.

I am trying to use the following with a Command Button to send a report via email. I want to use a where condition to open/send the report so that only the current record is on the report. Where can I insert the Criteria filter I wrote in the Send Object string? Private Sub cmdemail_Click() On...

That helps...thank you.

The data come from a many part of a table. It is route stop times. Most have 1 AM Stop time and 1 PM Stop Time. Some have only 1 stop Time in the AM or PM. I am making labels and want both times in the same row. Right now I do the following, but I don't know how to add the WHERE part to this to...

Perfect, thank you.

I actually figured something out: Expr: Left([FirmName],InStr([FirmName]," ")-1) However, when the FirmName on file is only one name already I am getting an error. Where have I failed?

I have a table that has Law Firm names in it like the following: Jones Jackson & Johnson etc... How can I have a text box on a report only show the first name (Jones). I would assume there is a way of identifying the space between and stopping it there, but I just don't have the experience to...

That's it...thank you.

That's real close. Now how would I set it for the following expression: ="Page " & [Page] & " of " & [Pages] The way you showed me resets the page number, but still says the total number of [Pages]

I have a report that prints route stops. I have it sorted by routes so that each route starts on a new page. What I would like to do is also have my page # start from "1" again on that new Route page. I use the following: ="Page " & [Page] & " of " & [Pages] to display page 1 of 8 etc... If...

Bingo! Thank you.

I'm still struggling with this. 1. AM (Case 1) Eliminates every record am and pm. 2. PM (Case 2) Doesn't eliminate anything, jusst seems to requery or something, but stays the same. 3. All (Case 3) Brings everything back. Here is what I am working with right now: Private Sub Frame7_Click()...

Now I am using the following and I am not getting any errors, however, the filter is not working right. Does it need to be a "Between" or am I doing the time wrong? I am close... Private Sub Frame7_Click() Select Case Me.Frame7 Case 1 Me.frm_Routes_Sub.Form.Filter =...

Remou, I definitely like this method and have gotten this far, but am getting an error. My subform is frm_Routes_Sub. The time control source is StopTime, but the control name is Stop_Time. Here is what I have so far: Private Sub Frame7_Click() Select Case Me.Frame7 Case 1...