Search results

Hi I have a fome called 'AccidentOnly' which is quiet clearly in my navigation list it's main data source is from a table called 'Accidents' to get to this form the user has to navigate through to it by first selecting a name which then enalbes a command button. The on click event of this...

hi guys, could someone tell how I can add / show a new combo box to a form after the first one has been fill in? What I mean is I have for example a 'line' on a product form with cbo1, txt1, txt2 Once the users fills in data in these controls then another set of the same controls should...

Many thanks Byron - its been a long day !! Will speak to you soon

Apologies for what may seem a 'stupid' question but I think my brain has gone into sleep mode !! I have a 2 combo boxes on a form - ' cboProductCode' & 'cboProduct' If i enter a code eg. Dr001 in cboProductCode I want the related product to populate cboProduct with the item that code relates...

Hi David just wanted to give you an update on the problem you were helping me with... I have re-arranged some code in other related forms to the form we discussed. Specifically in how they open and close and in what order they close when they have been either completed or finished. It has...

Hi David nothing doing I'm afraid - I have tried on my machine and my partners (who has 2007 on it) it keeps saying unrecognised format. I can't even import the tables ect into a 2007 open db. So it seems we are stuck now - not sure what else to do? thanks again

i will give it a go and post back thanks

just read through a few posts on backward compatibilty and I don't think you will be able to open the DB even though it is created as a 2007 DB I must be using some of the 2010 'new extras' that stop you from opening it! not sure what to do now - any ideas as I really need to get this issue...

hmmm not sure why I have tried to use as save as but it is not giving me any options to use a different format ? it is saying .. .accdb Im assuming that is not compatible with your end?

I'm using 2010 but this db is in 2007

Hi David attached as requested - many thanks for your time I do appriciate it

not sure if it helps but if i go through the treatment form ensuring data is entered in the controls get to the last control (which is basically coded to do the same - close Treatment and open Navigattion - it works fine?

Using a select Query from the PatientDetails table as below SELECT PatientDetails.PatientID, PatientDetails.PatientFirstName, PatientDetails.PatientSurname, PatientDetails.PatientDOB, PatientDetails.HomeAddressPostCode, PatientDetails.PatientOccupationID, PatientOccupations.PatientOccupation...

sorry it is actually called "SelectPatient" was trying to abbriviate things for speed !

Hi David thanks for the reply and the revised code - sadly it did not work still get the same error on the same line? for further information the "Select" form remains open after intiailly going through the process to get to the Treatment form. If for example I try to open the treatment form...

Hi guys - Could someone please advise me why my form is not closing please -I am getting a Run-time Error 2585 "This action can't be carried out whilst processing a form or a report" The process I am using is I open a form called "Select" select a name from the listbox (which is populated from...

At last !! not sure if this is 'correct protocol' in VB but I added a line disabling the cboName after ctl.undo ( with the set focus cmd as well) and it works Many thanks David for you assistance much appriciated !

ok thats has helped a lot as the dreaded default message has now stopped but (there always is a but!) when I select 'Cancel' it goes back to the same cbo - I assuming because it has acDataErrcontinue. What I need it to do is go to the next control - cboDetails. Is there a way to add something...

Can I just confirm this please as it does not seem to be working !.... MsgResponse = MsgBox("There is no record for the Name" & vbCrLf & vbCrLf & Chr(34) & NewData & Chr(34) & _ vbCrLf & vbCrLf & "Please click Yes to continue.", vbQuestion + vbYesNo, "No Record Found") If MsgResponse =...

thanks David I will change it now and see what happens but in hindsight that makes sense ! thanks again - I will post back