Search results

Hi guys I have a select case statement to send a report via print or email from the active form "AccidentOnly". I am having problems closing the form within it and would be very grateful for some advice on how to resolve this. I need to place these two lines somewhere after the 'sendobject'...

Hi guys is it possible to spell check a combo box before the NotInlist event triggers? I have the following code in the event Private Sub cboPatientOccupation_NotInList(NewData As String, Response As Integer) 'Checks occuptaion typed in against current records and adds it to table if user...

Could someone please advise me how to hide a form if a text control on it is null? At the moment I have the following code Private Sub Form_Current() 'Looks up current Patient Name and DOB to show on forms Dim strFirstName As String Dim strSurname As String Dim strDob As String...

Hi I have a small issue with list boxes and wonder if ther is a fix for it. I have two list boxes on a form 1 for Gender and one for Title. At the moment, if a user types in 'M' in gender Male comes up which is correct, but if they typed in something like Mail or even '123' that stays in the...

I am a bit puzzled by this one so would appriciate any advice that can be offered.. I have done a test split on my database and set it up on my server at work. It is on 2 desktops and one laptop with dual monitors. All of the monitors are the same make model size etc but on two of them the...

Whilst testing my DB I have stumbled across an issue that is confusing me !! I have a Cbo for occupation - as it is not vital data the user can add to the list if a new occupation is required and not there. The issue I have is that if someone puts in "painterr" the notinlist event will fire...

Is it possible to disable the 'File' tab on the ribbon through code? At the moment I have a login form set up and depending on the access rights of who logs in the whole ribbon will either show or not show. DoCmd.ShowToolbar "Ribbon", acToolbarNo Whilst going through some testing it has...

Hi Guys I am getting confused trying to code a button after dates have been entered in two boxes - Start Date and End Date On opening the form the cmd button (View Reports) is disabled. The user enters dates in the Start and End date boxes, once this is done the cmd button enables. However if...

Hi guys Is it possible in Access 2010 to create a new ribbon to show when a particular report / form is open? I have read loads about being able to customise the ribbon and very easily added my 'test' tab but when i go back into Access all the other default tabs - Home, Create, Database Tools...

Hi Guys - seems ages since I was last on here but am back to finishing off my DB and need some advice again !! I have a Access Navigation form, with subforms within each 'button' one of these buttons is called 'Treatment Menu' (NavigationButton19) On the 'Treatment Menu' subform (called...

Could someone please tell me how I can handle responses to various msgbox's. At the end of a from the user is presented with a yes / no msgbox. Depending what the response is relates to what happens next. So in my case if they answer Q1 with yes they get Q2 if they answer Q2 with Yes...

Hi Guys, I have a form that on completion needs to ask the user a couple of questions to determine where the process goes. I am getting a bit confused with how to write the responses and hopefully someone can guide me in the right direction. The code I have at the moment is as below...

Hi Guys For the life of me I can not work out why I can't get a report to add all the products on it. On a test report I have 4 products with values of 50,60,60,80 but the Subtotal box only shows 50 when it should be 250. Any help or advice would really be appricated !! many thanks

Hi guys could someone tell me if it is possbile to requery a listbox on a main form, from the afterupdate event of a Subform? I have a form called 'Vaccination' with a listbox called 'lstVaccinations' On the mainform is the subform called 'VaccinationConsumablesSubform' the last control on...

Hi guys Is it possible to restrict a certain value in a combo box through code? E.G I have a table called tblNames one of the values in this is table is 'Not known' This table is referenced on various forms but on some of them I do not want the user to be able to choose 'Not known' from the...

I have just noticed there is a naming problem with one of my tables. Can I simply re-name the 'field name' and rename the relevant forms / code where this applies or am I walking into trouble doing it this way I would appriciate your advice please Many thanks

Hi guys i am tottally lost with this one, so would really appriciate some help please sorry if this is posted in the wrong area but not 100% sure what is causing my problem! I have a navigation form with a few command buttons one of which opens another form called "FindPatientTreatment". the...

Hi guys - hopefully someone can point me in the right direction as to why this is not working please? I have a table called PatientDetails I have a form called SearchPatient In my form I have a textbox called txtName and A listbox called lstSearchResults The rowource for the listbox is...

Hi guys, could someone tell me if it possible to do the following please (also if it is practable!) I have a form with a combo box called cboFindPatient and a listbox called lstpatients. What I would like to happen is as the user types a letter in the combo any patient whose name begins with...

Hi Guys could someone advise me how to resolve an issue I have with the following please. I have a subform set as continueous. I have various controls of which two are cascading combo's. I have a case function on one of the controls to show the dose numbers used for a particular vaccine as...