Search results

Thank you Rich... Works like a charm

I am trying to build a query that would filter record that have an quote expiration date between the current date and a date that the system prompts for. I want the system to automatically use the current date as the Start Date, and prompt for the exp date. What I am trying to do is avoid...

In searching the posts..I haven't came across a similar problem yet. I have modified the switchboard of my db wiht some graphics and buttons and such. The opening page works fine, but once I select one of the choices, the new switchboard opens with the uttons visible, but the text on them is...

Yes. I am in Design View / Page Setup. I don't know what else to try :-(

I am very UNFAMILIAR with vba programming. Would it be a difficult task to format the report on entry? Can it be an automated task, as the users are DANGEROUS if I give them formatting control :-)

Thanks for the suggestions. Unfortunately, neither works here? I cannot understand why this report will not keep it's formating...but who knows

I have several reports that have a unique problem. When I access the report on my system (design mod's, etc) and I go into page setup, I save the margin and paper layout settings without a problem.....but when the user I created this system for opens the report, it reverts back to 1 inch around...

Sorry for the lame question, but does Access allow you to create external functions via macros (print to file, etc)like you can in Word and other Office apps? I would like to have a report print out to a file so that I can use Adobe's distiller and create PDF's from it? Any thoughts?

I have created a report that contains a group footer WITHIN a group footer. I don't know if that is the cause, but when I trey to generate the report as a Data Access Page, I get the following error: "Database is unable to create the data access page- the file you attempted to load was not...

Thank David... During the "in-between posts" there.. I figured that part out and I think I may have it. But I am having a heck of a time trying to create a data access page from this report. Lots of errors, but since it is separate, I will begin a new thread. Thanks again

Great....another step towards ACCESS GODism....ha maybe in another life perhaps Thanks David

I don't know if it will help you...but check this topic out.. http://www.access-programmers.co.uk/ubb/Forum5/HTML/002749.html

KKilFoil seems to be on the money on this one. I had a similar question and the proven response was to build a query that is based on an unbound combo-box form I created. The user selects the appropriate value from that box and the query runs. Since you explained that all the fields are the...

Is your report based on a query? If so then you should be able to incorporate an expression into it that will hide it if the value is NULL

Here is my situation. I am designing a report that will show projected closings in a particular month. These closings are grouped by individual builder, and then group by project name within the builder group. Can a report have a group footer within a group footer? I want to use the first group...

I wish I could say I understood what the statements did, but I figured there seemed to be 1 too many Start and End-Sub comments....was that correct and what do they do?

I don't know if I have done more bad than good.....but I deleted the 2 lines of code that were already in there...and the rest is now working OK??

I am receiveing a compile error - EXPECTED END SUB The first line of code is highlighted when this error comes up

Looks great :-) But unfortunately, I do not have a grasp on SQL coding yet. Where in the system do these commands go?

My question is (I hope) fairly straight forward: I want lines around each field within my report. Basically I want the data to be similar to a datasheet (with the lines around each field, like a chart) That way data is more easily read accross the report? Any way to do this?