Search results

  1. C

    Big gap between report header and detail section for no reason

    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!
  2. C

    Help with Printing to PDF (I have Acrobat Pro installed)

    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...
  3. C

    Calculation query question

    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]...
  4. C

    Combo box that doesnt allow previous selections [in a continuous form]

    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...
  5. C

    selecting the opposite of this information:

    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...
  6. C

    Dynamic Checkbox Creation + multiple insert query

    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...
  7. C

    using a combo box to find values in list box

    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...
Back
Top Bottom