Search results

Did some research with your problem and my best guess is to use the following: create a QueryForm with 2 Textboxes which represent the beginning and end date/times you want to test against. Then in the Query use the following CRITERIA statement: Between [Forms]![queryformname]![text0] And...

sadie: can you attach it to a post or email to my office (vcs.jack@erols.com) and I'll have a look at it for you. JT

Not necessarily, I have also seen it occur if the data being appended is LARGER than the receiving field. Also have seen it burp on appending data to a Yes/No field where the data going in is BLANK. HTH JT

The property Newman is referring to in the U.S. version is "Display When".

Try this...enter a Textbox on the main form and use the following as the Control Source...=DSum("[ClientChargedAmt]","name of subform","[client # on main form]=" & [client # on subform]) substituting the appropriate field names from your forms. HTH JT

Just thinking from the top of my head...is the report always two pages ? and will all the page 2 textboxes be blank as a group ? then you might want to consider adding VB code to block the printing of page 2 (I did that a few years ago but can't put my hands on the code right now). Maybe if...

I was trying to get you you to Maximize the report and then you wouldn't need to min and max Access itself. Then you wouldn't get that error which I can't find details about. JT

Have you tried this code instead assuming what you're trying to do is maximize the Report Preview window ? DoCmd.OpenReport "report1", acViewPreview DoCmd.RunCommand acCmdFitToWindow HTH JT

Put this code on the LostFocus property of the last field on the first subform, which when the user tabs it will move focus to the frist field you have on the second subform... Forms![main Form name]![second Subform name].SetFocus HTH JT

Two things: 1) Always been taught to use mm/dd/yyyy even though the format might be different in your data look. 2) You could use a calendar to pick the dates but only if you built a form then fed the choices to the query from the form. JT

You had a couple of issues. See the attached database with the changes. Notice the readjustment of your Lease Info form (visually), also the properties of both combo boxes in question including the AfterUpdate property of the Complex combo. Think this should solve your problems. Good luck. JT

This may sound silly, but have tried testing as mm/dd/yyyy in your parameter questions and entries ? JT

If I'm reading you correctly --- you should be able to create a set of textboxes in the Page Header inserting the particular fields you want from the query feed to solve your problem. If not, attach the database objects needed (zipped)and maybe I can get you going, JT

I wholeheartedly agree they should only be needing to update in one place. But have you produced a report in Access to accomplish the printout they want ?

Someone from another forum once suggested this site to us: http://dgl.microsoft.com/ FoFa's suggestion of converting the images usually works once you've got an image you like. HTH

Yes you can have a button on a form to produce the report -- proabably a Command Button. The attachment you included is actually a spreadsheet not the database you're using. Withouth seeing what've you done already, how about creating the look-alike report in Access, generated from the button...

Could you be a little more specific ? Are you using the table to generate the data for the report or a query. Is it just one field of a record that you want in the header ? Are you producing one record per page in the report ? JT

You're welcome. Good luck.

You're right but check out the attached file. Specifically the code in the Open event of the Report. This should get you going in the right direction. Good luck.

Mark: True, but I was thinking and worrying more about the varying number of days in the months.