Recent content by jaxflorida

Thanks, but my problem is actually with the top/bottom margins.

Is there a way to change the margin size for a report so that page 1 has a margin suitable for letterhead and pages 2+ have "normal" margin sizes?

Thank you. You hit on the main point. I was trying to avoid rebuilding the report. Plus, in hindsight, I should have built it based on a query anyway.

Thank you for responding. However, the report is actually based off of two tables. The fields are already in the tables and the tables are linked. Any thoughts for this scenario?

I created a report using the report wizard. At that time I didn't anticipate needing another grouping by a field I hadn't chosen in my report. Now, I can't get the additional field to show up in the sorting and grouping area. Does anyone have some advice on this? Thanks

Thank you very much! J

Does anyone know how to run an update query from a macro (or any other workaround)where it doesn't stop the process to say "You are about to run an update query that will modify data in your table" and then "You are about to update 3 row(s)"? In other words, I want the...

Thanks. However, nothing seems to happen. When I change the current workforce number, the textbox field changes to the correct number, but when I look at the table, it hasn't put anything in the EMF field. J

I am not sure what it is you are asking for. (Like I said, I don't use access or VBA for that matter much.)So here is what is in the text box. =EMFCalc([CurrentWorkforce]) and as I understood it, the code up at the top of this post was the function. If it isn't, let me know and let me know...

Yes, the form is attached to the table.

jbehrne, Thanks for responding. No, the code works just fine and it gives me the result in a text field. However, I need to put this calculation into the EMF field in my table. Any thoughts? J

Hi, I am a only an occasional user to programming in Access so I really don't know much about the code area. I have been banging my head against the wall for some time now. This code was modified from a totally different database. I have a form that has a calcuation in its code shown here...

Go into the properties of the graph and then into the row source property click the ... button. This puts you into the query for the graph. Go into the SQL statement design view and when it says Select blah, blah, blah as [your legend description here]then look at your report. Hope this helps.

k, What do you think is causing it to not pick up both records that contain data in my memo field then? J

Oh No! Mr Bill. (Like you haven't heard that a million times):) The problem is that the memo field isn't listed in the equations. dgillz, I had manually put the field in the equation editor. I had two records that should have showed up with "not isnull". Only one did. The other...