Search results

  1. S

    DSum not working after December in Financial Year

    Hi everyone, I have the following in a query: Count: Val(DSum("Num","Google_export_1Cancer_Target_Prea","DatePart('m',[StudyEntryDate])<=" & [AMonth] & " And DatePart('yyyy',[StudyEntryDate])<=" & [AYear])) Our Financial Year runs from April to March. The formula works fine up to, and...
  2. S

    Greying out/disabling field based on other fields on form/sub-form

    Hello everyone, Really need some help as I have tried for quite some time now without success. I am wanting to grey out/disable a field on a form based on entries in two other fields being the same. One of these fields that contains the data to be referenced in on a sub-form. The form is...
  3. S

    If previous record field is same as previous, do n+1

    If current record field is same as previous, do n+1 Hi all, I haven't been on here for AGES! Do apologise if I don't use the correct formats, but I'll try! I should note that I am not good at VBA ! Basically, I need a way in Access of looking up the SumofCount of a previous record where...
  4. S

    Calculation using a value from a form and a sub-form.

    Hi everyone. I have a calculation that requires me to use a field from a sub-form. The calculation needs to sit in the form called, "frmCSP_PenCLRN_Specific_1". It needs to calculate how many days it took to start the clock after the trust has been advised ie. Dateclockstarted -...
  5. S

    Copying rows of data to other rows within a table using vba

    Hi, I haven't a clue how to start; therefore any help would be appreciated (seriously!). I've attached a basic example of what I'm trying to do. So lost and confused! sparkes84
  6. S

    Functions within a Private Sub Command0_Click() and help with logic

    Dear all, If somebody could help me, then I'd be so grateful! All due to sheer inexperience of vba programming. I would like all of the following to occur at the click of a button on a form, hence my private sub command0_Click() but when I started to put together my 'If' logic, all started...
  7. S

    MsgBox vbOKCancel Problem

    Hello everybody. I'm so stuck! It's most likely very simple, but I'm tearing my hair out here. On the On Click command of a command button to open a form, I want a MsgBox to appear (which is does) and if OK is clicked, then I want it to open the Information Manager's form, else, when they...
  8. S

    Exporting from Access into Excel - but only new rows

    Hello everyone - this is my first post! I really do hope that somebody can help me. I have set up a bit of vba: Private Sub Command1_Click() DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel2003, "Tbl CI Details", "z:\specialty groups\specialty groups for portal.xls", HasFieldNames...
Back
Top Bottom