Search results for query: *

1. What is a file handle? A name or alias? 2. I added crystal rpt to the desktop info server. I'm getting "invalid file handle" when I try to "design" it from the info server. Is it because I gave it a title different than the report name? 3. I can design, print, etc...

With your form in design mode, dbl click on the little black box in the upper left hand corner of the form. This opens the forms properties. With the properties window open, click on the Event tab. Locate the 'On Activate' property. Click on the line to the right of it and click on the...

I had the same problem. Everybody complained about not having the lines, boxes, and other aesthetics on the report. I never considered generating a pdf file but I'm going to do that right now. In the meantime - I used color to differeniate between label names and data, etc.

You could have your form go directly to a new form when you activate the form. for the On Activate event sub type: DoCmd.GoToRecord , , acNewRec This way you don't have to hope that the user remembers to press the Add New Record button before they start selecting names, etc when they open...

I have a suggestion. In my form's "on open" I have it go directly to a new record. But I don't force it to assign a record num here-- I wait for them to enter some data . If you write code to add a record and assign a number in the "on open" or "on load&quot...

JDark,&nbsp;&nbsp;hmmmm, Did you try grouping?&nbsp;&nbsp;That way it will only reiterate the field labels when the employee name changes.&nbsp;&nbsp;Does your report look like a spreadsheet or a form?&nbsp;&nbsp;I'm visualizing a spreadsheet.<br><br>Sorry I can't be of more help

JDark,&nbsp;&nbsp;I assume the fields are horizontal and that there is not enough room for all 25 on one piece of 8 1/2 x 11 piece of paper.&nbsp;&nbsp;Did you try setting the margins to minimal and printing in landscape?&nbsp;&nbsp;Also, your report area shouldn't be larger than the print area...

I need help with printing the report using the data from the subform.&nbsp;&nbsp;I keep getting every record in the database in the printout and not just the ones in the subform.&nbsp;&nbsp;I've tried linking the report to the subform results but it doesn't acknowledge it.&nbsp;&nbsp;I have the...

I have a form &quot;main&quot;, that has a subfrom.&nbsp;&nbsp;A sql string, which has a lot of variables, is created from the criteria you choose from the &quot;main&quot; form.&nbsp;&nbsp;Those results fill the subform.&nbsp;&nbsp;I want to print a specific report using the data from the...

Thank you for the help you guys.&nbsp;&nbsp;There is something strange in this database.&nbsp;&nbsp;When I used Ricky's code, I saw the numlock led flicker on my keyboard.&nbsp;&nbsp;It didn't when I tried Ollie's code but I'm confident the problem does not lie within the code but within the...

I have been working with VBA to set the NUMLOCK to &quot;on&quot; when certain forms are activated/opened. I'm not having any luck. I'm trying to work with a database developed years ago by programmers who are since long gone from the company.&nbsp;&nbsp;It looks like they have code somewhere (I...

I know what you mean.&nbsp;&nbsp;Before I wrote my last thread&nbsp;&nbsp;-- I tried to accomplish the very thing you are [1 of 4].&nbsp;&nbsp;It appears Microsoft left that part out of their HELP file. <br><br>Any programmers out there know how to address this?&nbsp;&nbsp;&nbsp;

If you want the page number to be in the group footer, remove the reference to the macro resetting the page to 0 you put in the groupheader's OnFormat property.&nbsp;&nbsp;You can do only one or the other but not both.&nbsp;&nbsp;<br><br>

Maybe I'm misunderstanding the problem.&nbsp;&nbsp;In the group footer, create a text box with the following control source&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&quot;Page &quot; & [Page] & &quot; of &quot; & [Pages]<br><br>It was a long time ago -- I think I may have used some kind of wizard for that...

I link my tables through an ODBC connection and encountered a similiar problem once.&nbsp;&nbsp;I learned that when linking SQL tables to an access 97 front-end, if SQL prompts you to choose a unique field -- choose one.&nbsp;&nbsp;I didn't, even though I had one, and the table was not updatable...