Search results for query: *

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...

I have a form that has a subform in datasheet view. There are times on each record in the subform. I would like to have a toggle button on the main form, or something better if suggested, that would filter the subform by am or pm. Basically it is mail runs, and I would like to be able to...

Thank you. I didn't know it could work like that.

I will try that. The only reason I separate them is I have the date default set for Date() because most orders are the same day. And they need to be entered quickly, so I have input mask's for each field to let the user enter data fast. I've tried input mask's with the date/time field combined...

I have a form that has a separate Date and Time field. Under the date field's Before_Update event I wrote some simple code to not allow a future date. My question is how can I make sure the Date and Time fields together are not in the future? Say the date is today, but it's not 1:00 PM yet...

Thank you. I don't get a compile error now, but when I tab from the main form I am getting the custom error about "no data" before I get a chance to enter data in the sub form. I guess the main form is attempting to update before tabbing to the sub form. I am close though...