Search results

Here is the output. The count field shows how the value increments as it sums up all recruitment up to and including that month, but for Jan to March (the latter part of the UK financial year), the increments stop and it starts afresh. AYear is the YYYY part of the month date AMonth is the M...

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

Thank you for your replies and suggestion of using conditional formatting. I have it working via that method. It hadn't crossed my mind at all, so many thanks.

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

Sorry Plog - was in a rush and didn't remember to (force) change the date stamp. I have done so now (in the Recrt_Data_DateStamped and Recrt_Data_DateStamped1). New zip file attached. Apologies, sparkes84

OK, here are two documents within one zip. Re-the db (only 1 table will be imported from Excel, the others have been created in my attempt......!) Word doc shows example output. All yours to change things. I'm no whizz, by any means. Thanks for your help, sparkes84

Thanks. I have to log out in a minute. If it is easier, I could attach a copy of the database with info anonymised? I'll attach it tomorrow, if you're agreeable? Thanks, sparkes84

Hi Plog, Thanks for taking the time to reply. 'Order' is made up of three original table fields, then joined via a Make-table query, e.g. Order: Val([Order1] & [Order2] & [Order3]) where Order1 = StudyID Order 2 = SiteID Order 3 = DateStamp - DateStamp is from: Date_Stamp...

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

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

Dear GalaxiomAtHome, That's very kind of you, to reply to swiftly! The data that I have been supplied with is from a really terrible database which I have no control over, nor does it have any unique id which enables you to categorically state that the record belongs to that particular "study"...

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

Thanks David. This particular bit of programming will eventually (with hope!!) be neat enough to create the fields within an import button, and then have the other part of the code as part of another button. This will need to be rolled out to various places around the UK, so it's important...

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

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

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