Recent content by fijufiic

Suggestions, anyone?

Blank pages I was able to export the report to PDF file and now I have a quick question. After each page in my PDF report I have one blank page - how do I get rid of the blank page? I played with margins but that did not seem to solve the issue. Any suggestion would greatly appreciated...

Pat Hartman, Thank you for your response. Are you saying that there is no setting in Access that will allow me to maintain text formatting after exporting the report to Word? As for the second part of your response - could you please specify what setting in Detail section of my report...

Hi everyone, I have a form with textual fields. The fields are enabled for formatted text (i.e. bold, bullet point, etc.) and I can run a report that pulls the data from this particular form containing formatted text, and it looks great. The problem starts when I try to export this report to...

cardgunner, Not one button on your cstfrm works for me :confused: Also, I tried the old database I was mentioning in my previous post - same disappointing results. I'm gonna have to check the security settings... Thanks, -f

Yes, the db code was blocked before when I would first open the db but I turned it off... the toolbar would appear on top, and when I clicked on it, the new window popped-up and I checked 'do not ask me again' and proceeded to open the dB. There is an old database on our departmental drive...

I have other forms and I tried creating buttons on those forms - if the button is coded, it does not work. I'm not sure if re-doing the form(s) would help me -- it seems that I would have to re-do the whole project which, of course, I do not want to do. cardgunner, what version of Access are...

It is strange :) Only coded buttons on my form do not work - my code is possessed :D I have deleted and re-created the button many many times - same result. And yes, the macro works fine - I just don't like that the records are pulled in the table rather than the form itself. Could there be...

Yes, my form is bound to a query and I would like to have a button that runs another query (this query would not be bound to the form - it would run on click of the button on the form). Hope I did not confuse you. -f

I tried your suggestion - and my button is still dead! Hmmm... I do not know why my button won't work! It's so frustrating. -f

Hi everyone, Thank you for replying. cardgunner, I tried the code you suggested but my button is still dead. Again, if I use macro instead of the code, I can pull the data I want but it will appear in the table format rather than within the form. CyberLynx, I will try your suggestion once I...

Suggestions, anyone?

Are you working in MS Access 2007? I have the same problem.

Hi missinglinq, The query name is spelled correctly - I checked multiple times; I'm working in MS Access 2007 (& I do not like it for many reasons); I do have other working buttons on my form but none of those are dealing with the queries; In design view of my form, I created a button and right...

Basically, I created a query in Access which includes the fields on the form that I would like to display (approximately 7 fields) when I click the button on the form. This query includes Status field (with Criteria: "Final") and IA Number field (with Criteria: [Enter IA Number]). Then, created...