Search results

  1. N

    Customised chart built by Function: Report vs SubReport Problem

    [SOLVED] Customised chart built by Function: Report vs SubReport Problem OK so I've always been very disappointed with the limited capabilities of Charting in Access, so major review time for my database why not try and build a common function to build a customised chart (graph) for my report...
  2. N

    Number rounding error when pulling Double from Recordset

    I have 2 similar numbers in a table with the following parameters: Double, Fixed, DecPlaces = 2 One number (GLminor) = 0.10 Second Number (GLmaj) = 0.50 When i use the following code to create and pull the numbers from a recordset the (Gmin) is OK and displays as 0.1 but the (Gmaj) has a...
  3. N

    Negative numbers in calculations - help...

    Ok i know negative numbers can be a bugger in calculations bt i can't seem to wrap my head around this one: Function FEV1pred(height As Double, ClientID As Double) As Double Dim a As Double Dim Age As Integer Dim DOB As Date Dim TestDate As Date Age = DateDiff("yyyy", DOB, TestDate) +...
  4. N

    Subscipt / Superscript Characters in a Table

    Howdy all, looking to see if it is possible to store text in a table that includes subscript / superscript characters. As an example; need to indicate the units of measurement for some data and therefore need to be able to pull data from the table such as the following: kg/m2, m/s2 etc. In...
  5. N

    SELECT Between two Dates Troubles....

    Been having awful trouble trying to work out why the following line of code isn't working. Any assistance greatly appreciated: Set rs = db.OpenRecordset("SELECT * FROM tblCharges WHERE IsNull(InvCode) And CaseID = " & CaseID & " And ChargeDate BETWEEN #" & StartDate & "# AND #" & EndDate & "#")...
  6. N

    Multiple Value Lists DOING MY HEAD IN...

    [SOLVED] Multiple Value Lists DOING MY HEAD IN... Seriously massive thanks to anyone who can help with what i bet i a really simple thing that is currently doing my head in. I have a multiple value listbox for a survey with only 10 possible selections storing values 1, 2, 3, 4, 5, 6, 7, 8, 9...
  7. N

    Delete Record From a Subform

    Hi all, Like many of you i have to idiot proof my simple databases for the uninitiated. I currently have a main client form (frmClients) which i load with Allow.Deletions Allow.Edits and Allow.Additions all set as default to False. I then have a series of cmd buttons which toggle the...
  8. N

    Functions with multiple output?

    Hi all, I'm currently writing some fairly lengthy functions for a project to make things more efficient, but a lot of what i need to do can get quite repetitive. I would love to be able to create a function that had more than a single output. For example: (simplified) WHR = CDec(Nz(waist)) /...
  9. N

    Function Problem

    I have written the following simple function to determine the 'Best' score of three attempts. The number can range from -30 to +30 or so and are measured to 0.5 intervals. Function FlexBest(a As Double, b As Double, c As Double) As Double If CDec(Nz(a)) >= CDec(Nz(b)) And CDec(Nz(a)) >=...
  10. N

    writing functions - runtime error 6 overflow

    Hi all, I have recently started cleaning up some of my bigger databases by refining the rediculous numbers of wueries ans writing them as functions. I have written a number of functions that have all been successful so far, though this one is a bit more advanced than the others. This function...
  11. N

    Min/Max functions - Auto Decimal Places

    I have a stats query that i run on a collection of Waist to Hip Ratio's which are generally measured as a ratio to 3 decimal places as follows: waist = 89cm hip = 101cm WHR = 0.881 (to 3 decimal places) My problem is that the min and max functions that i am running on this set of data for the...
  12. N

    Form Close Problem

    I have a single lingering problem preventing me from moving on with my project. I have a single form with 3 command buttons on it, Delete, Edit, Save&Close. The form loads as default with: Me.AllowAdditions = False Me.AllowEdits = False Me.AllowDeletions = False...
  13. N

    Form Errors - Vista Issue

    Hi All, I have a simple form with 3 subforms. I have a 1 data field on the main form for each subtotal of the subforms as well as an overall total field. I have the following code in the subtotal fields: SETot=IIf(DCount("[ID]","qryExpenses")=0,0,DSum("[Reimbursment]","qryExpenses"))...
  14. N

    Charting Engine - MS Access 2007

    Does anyone know why MS Access 2007 does not use the same charting engine as the rest of Office 2007. I find the new engine in Office 2007 very nice indeed and a significant improvement over previous versions, both aesthetically and functionally, so why am i still left with crap options for...
  15. N

    charting multiple values from single record

    This particular database generally looks at reporting individual records as opposed to summary reports. So for a particular data record i have the following data [x1][x2][x3][x4][x5][y1][y2][y3][y4][y5] I need to chart (scatter) these figures as paired x,y variables for display on a feedback...
  16. N

    Appending Tables - Attachments

    Hi folks, I'm trying to append some data from one table to another table as i've had to slightly alter the structure of the table. I have an attachments field in both tables but it seems that i cannot append the attachments from one table to the other. I get the following error when trying to...
  17. N

    Unpredictable Print Sequence

    I have a niggling printing issue but some background first. First thing - my reports are NOT summary reports therefore i have no grouping levels etc etc. Each report is specific to a "Health Test". A full "Health Assessment" contains multiple Health Tests. eg Health Assessment A...
  18. N

    Chart errors on subsequent reports

    Hi there all. I have built a database that collects our clients Baseline health data which generates a series of single page reports for each type of health test that has been completed. So for example we take blood pressure and return a single page report with a chart containing both systolic...
  19. N

    Count Fields Within A Record

    I'm building a health data system that stores data from health tests as follows: [test01], [test02], [test03],.........[test25], etc etc. Each of these tests comprised of a "Pass"/"Fail" value. Now, i'm building my queries for a feedback report to hand over to the client that is based solely on...
Back
Top Bottom