Search results

Hi, I'm a bit of a newbie using Access 2013 I have a data entry form for New Patient Admissions which opens up from a New Patient data entry form and inserts the NHS Number (using OpenArgs) then sets the focus to the next control and positions the cursor with SelStart My Problem is that...

Hi bit of a newbie using Access 2013 I have several tables with Patient ID as Foreign Key related to a Patient table with Patient ID as Primary Key - the data type is set to text as the ID must have "SG" followed by a unique number 000148 for example For the Patient ID controls in my data...

Hi everyone, Newbie alert!!! Can anyone suggest what is wrong with my code please? I have this code in a button on my Patient Form: DoCmd.OpenForm "frm_Admissions", acNormal, , , acFormAdd, , "NHS Number|" & Me.[NHS Number] And this in my Admissions form LoadEvent: Private Sub Form_Load()...

Hi I am trying to create a form in Access that does the same as the spreadsheet shown in the attached doc My initial problem is that I don't know how to get all the Item Numbers into a cross tab query - each item is a field in a table From what I can see cross tab queries have a maximum of...

Hi I'm trying to open a form in datasheet view using the following code Private Sub Run_Activity_Duration_Totals_Click() DoCmd.OpenForm ("frm_Activity_Duration_Totals_25_Hours"), AcFormView = acFormDS End Sub I keep getting a message saying Compile Error: Type Mismatch and the equals...

Hi I have a query with a calculated field (Duration: [End Time] - [Start Time]) When I run the query the result appears to show the duration as a percentage of a day i.e. End Time 13:00 - Start Time 12:00 = 1 Hour Duration Shows 4.166666666666666E-02 If I format the field 00:00 I get...

Hi folks I am trying to get the Primary Key value from one form to auto-populate the foreign key value of a second form I have tried the following code in both the second form's Load Event and the Foreign Key Control Got Focus Event but nothing doing... Me.[NHS Number] =...

Hi On my data entry form I have a tab control with three pages At the bottom of the first page I have a sub form with 3 fields Currently, when tabbing, the focus runs through the fields as per the tab order BUT Once it gets to the subform (datasheet view) it jumps into the first field of...

Hello I am creating a patient database that has a vast number of Lookup tables which may well need new options adding in the future (these tables all have 2 fields; Code & ??????(whatever the list of options is concerning) I was hoping to use an update query which asks the user which table...

Hi everyone My name is Rob - I used to teach A Level ICT but have left teaching and now do Information Analyst contracts etc I'd say I was a beginner looking to cross over into intermediate at Access so looking for a good support site and "this is it" Thanks