Recent content by Cruz

Print it to the Adobe Writer PDF Printer. Voila, brand new pdf :)

Here is my problem: whenever I create a report for a record other than record #1 there is a big gap (whitespace) between the header and detail section of the report. This does not occur for record #1 only 2 and up. Any idea why this is happening and how it can be fixed? Thanks!

Yes, you are correct. I feel very dumb after that one :rolleyes: :p :o Unchecking the print to file button solved all problems :)

Here is my question. When I want to print my report to PDF, I check the Adobe PDF Maker as the printer and then check "Print to File". I save it as a PDF file however it refuses to open. Perhaps I am missing a very big point here; is this how you are supposed to do this or is there another step...

Currently my query looks like this: SELECT tblClients.numTransactionID, tblClients.numDirectAccounts, tblTransFTE.numFTEID, tblFTE.numFTECatID, tblTransFTE.numVolume, tblFTE.numPMO, Sum(IIf([numVolume]=0,[tblClients].[numDirectAccounts],[numVolume])*0.2/12/[tblFTE].[numPMO]) AS [Call center]...

How would I go about doing that later option? Hiding the option is not a big deal, I just need to prevent duplicate entries.

Are these possible to create in Access? For example, say the list is populated from a select statement that selects all the products from a table. SELECT * FROM table. Now, in a continuous form, when the user selects product #1, the next dropdown box does not contain product #1 for selection...

Which tblAssumptions am I replacing?

Have you tried summing all of the days and dividing it by the total number of days? that would give you an overall average which is the same thing!

This is my original code which selects all the assumptions that ahve not been chosen by the user: SELECT tblAssumptions .* FROM tblAssumptions LEFT JOIN tblTransAssumptions ON tblAssumptions.numAssumptionID = tblTransAssumptions.numAssumptionID WHERE (((tblTransAssumptions.numAssumptionID) Is...

I have a table that holds a list of products and services offered. What I need is a form that will dynamically produce a list of checkboxes that will update another table with their values of being selected or not. Is this possible? The purpose of the database is to help speed up costing for...

Are you pulling this value direct from the database or is it being stored in a textfield?

Amazing :D And I adapted it to the listbox, works perfectly :) Thanks for your help!

Is it a text field? I have had similar problems that were fixed when I did: DoCmd.OpenForm "PhoneContactTracking", , , Forms!FindPolls!PollingPlacesResults.Form!PollID.Text

I would like to have a combo box/dropdown box that would allow me to select a Parent category, and based on what category I have selected, display the child products for that category. I have the table tblFTEParents which has numParentID and strParentName and then tblFTE which is linked via...