Search results

Paul, No, there is no filter on the Report, should there be? and even with the changes I am receiving the comment"no record to save" ???

Thanks pbaldy, been a long week. I will make that work on Monday. I appreciate your time.

pbaldy, I cannot wrap my mind around this, the OpenReport did not work either; DoCmd.RunCommand acCmdSaveRecord DoCmd.OpenReport sDocName, acViewPreview, [RequestNo]=Forms![LeaveRequestForm]![Text2] DoCmd.SendObject acSendReport, sDocName, acFormatSNP, sToName, sCCName,,"Leave Request"...

pbaldy, i have tried the criteria in the query, code in the open event, but not the where condition in the Openreport, I will give that a try. Thank you

How might I generate a single record from a report using SendObject?

:confused:Does a form need to be linked to a Query, or can it be linked directly to a table to run SendObject?

If you create a report in Access, you can export in Excel. So start by creating the report you would like in Access

You will probably need to compile all info on one table or 'link' the tables

How many User Groups can be associated with one BE database in Access 2003? CoachPhil

PDATE Your_Table_Here SET Your_Table_Here.Date_Column = IIf(IsDate([Date_Column])=True,[Date_Column],CVDate([Date_Column]));

Rural Guy, Yes, they can scroll through all records but, I want them to be able to scroll through only the records in the yes/no checkbox which reads no. Gemma, I will try your suggestion. Thanks to both of you for your time. CoachPhil

Rural Guy, Are you displaying the search in a SubForm that is in Continuous Form mode? How many records does your query return? Yes, it is in continuos form and right now I have about 30 records, probably go up to 2000. CoachPhil

In a form that I developed

I am trying to create a search function which would allow the user to scroll through the records in the program based on their status in the yes/no checkbox. I have developed to the point where it will scroll to the first record with a 'no' status, but it will go no further.

Sorry, it is Jet

Access 2003, and MDB and yes

Is it possible to use the FindRecord to scroll through records using a yes/no checkbox as criteria? I've really been at this a while. CoachPhil

Hi all, Silly question, but.........what is the best or most accepted way to document a completed program? ie: if I get hit by a bus on Tuesday, someone may want to continue with the program after I am gone(or recuperating) CoachPhil

Bob, Yes, thank you, sometimes we look for the difficult answer when it isn't there. CoachPhil

Bob, I have a form that I populate with client info including time called in. The time is coded as Now(), which populates with the current time. Is it possible to save the recorded time on this record so that when I print a report, the related caller time will be reflected in the report...