Search results for query: *

Hi all i have query which looks for patients under 18 and i would like them to be grouped between certain ages? for eg. ages howmany 0-4 5-10 11-18 the sql code i have got is this so far.. SELECT PATIENTS.Hospital_no, PATIENTS.firstname, PATIENTS.Surname, TREATMENT.TREATDATE...

Hi all, I have 2 tables... (table1 and table2) i would like to compare them and show records that dont match? could some1 show me an example or something regarding this... many thanks

Hi all, I would like to make append query which adds dates for the next 2 years but also adds slot 1 to 3. But does not include sundays. basically a query that creates dates monday to saturday and each day has 3 slots. e.g DiaryDate Slots 19/02/2007 1 19/02/2007 2...

Hi how do i include a where clause so it adds up the value between ReqDate. e.g RunningTotal: Sum(DSum("OrderValueIncVat","tblpreorder","PreOrderID <= " & [PreOrderID]))where between reqdate Startdate and endDate. many thanks

Hi i have this query where i would like to show all private patients and group them by year for e.g year patients 2006 15 2005 26 etc so far i've got this SELECT PATIENTS.Hospital_no, PATIENTS.firstname, PATIENTS.Surname, TREATMENT.TREATDATE, TREATMENT.PrivatePatient...

Hey all i have this subform with a check boxbut also u can maximise this subform to see all the form. Now about the checkbox i want it to do the same functionality in the after update if it was maximised or if it was in a subform... can this be possible? i.e check if u r in subform and do the...

Hi all, For some apparent reason when i go to a new record it says that there is a duplicate record. When i check my autonumber field theres about 7000 records. now every time i click on a new record the autonumber has started at 1156 and so on and these records have been already done. its not...

I've all ready have code to flash label every 1 second or so... but what i would like to do have another timer event to flash another label every 5 seconds. Can this be done... is it posible to describe it in easy steps and a sample code will be very helpful many thanks.

Hi all is it possible to bring up a record by 2 criteria's e.g ' Set rs = Me.RecordsetClone ' ' stLinkCriteria = "Treatment_ID = " & Me.txtTREATMENT_ID ' rs.FindFirst stLinkCriteria ' Bookmark = rs.Bookmark this shows how to bring up a record based on treatment id How would i...

Hi all am sure this might be a simple one... but am abit slow today how would i show the dates of all patients who have been treated in the past two years to now! do u know what the criteria would be? many thanks

Hi all! I have this letter which is mail merge but when i try to display more than 1 record the last record does not appear. The mail merge fields am using are «LESIONNo» «Next Record If»«Sided» «PATHOLOGY» «PDose» «PrescripCont» «LESIONNo» «Next Record If»«Sided» «PATHOLOGY» «PDose»...

Hi all i recently exported my project in vb to vb.net. However everything seems to be ok so far, but on certain lines of code its undelined with blue line. When i mouse over it says suchas "type DNSTools.NowPlayingInfo is not defined" I think theres a reference that may have been missed out how...

Hi all, I get this error msg when i compile my code Compile error - Procedure declaration does not match description of event or procedure having the same name. it highlights this line of code Private Sub DgnDictEdit1_PlaybackNowPlaying() ' Updates the visibile text selection...

Hi everyone! I have this code that was written in vb.net and i've nearly converted it all to vba. There are few minor codes that i don't know how to change in to vba. They are shown in red. This will be greatly appreciated if someone could have a look and help me finish it off. *Its long piece...

Hi all... Is there anyway to make a record uneditable. i.e using code ... so when it comes to this patient the record cannot be edited???

Hey up everyone! Is there way to flash a label without using the ontimer event. Since am already using the ontimer event for something else???? Any sample code or examples will be very useful many thanks

Hi all in my query i have a field called sided Sided: [Side] & " sided" Now in the side field it will say left or right or sometimes midline. However it does not make sense if you put down midline sided. Is there anyway to check if it comes up as midline then do not include sided. e.g left...

Hi all, I get an error msg path not found,the line highlighted red gives me error! Any suggestions how to sort this out! ' 'Move folders to m:\ Drive where the snapshots are kept sfol1 = "C:\ImageTransfer" ' change to match the source folder path dfol1 = "Y:" ' change to match the...

Hi all i have continuous form. It has an order number e.g 0012312345. This order number has files in certain location "Z:\StockSystem\CopyOrders" which are saved in the format 0012312345.msg is there anyway in the continuous form have a checkbox to show whether each order number has a file...

Hi i get this error msg saying runtime error 438. The code points out to line highlighted red.... any suggestions how i could solve this? Dim fso As Object Dim myFolder As Object Dim AllFolders As Object Dim curFolder As Object Set fso = CreateObject("Scripting.FileSystemObject") Set myFolder...