Search results for query: *

once again thanks for your reply. your script will work for certain scenarios. However sometimes the users who write the filename may change the format of it. e.g the actual format(98% of times is this) 2345_dx3945_29_10_50_Blogs_joe the other 2% may write it like this dx3956_Blogs_joe...

Hi all, I would like to extract certain numbers and characters from string of letters and numbers e.g 3452_dx2443_joeBloggs what i would like to extract is the dx2443 which is the example patient hospital number it always starts with 2 letters then followed by numbers. i only know very...

Cheers PhV

...Dim strFolderName As String, strFileName As String Dim i As Integer strFolderName = "C:\Database\Images\" strFileName = Dir(strFolderName & "*.*", vbNormal) If Not IsEmpty(strFolderName) And Not strFolderName = "" Then Dim FileList As New Collection ' List of files in...

...Me("DetailHeight") = 0 strDirectory = "C:\Database\Images\" ' strTest = GetFileName(strFolderName) strFileName = Dir(strDirectory & "*.*", vbNormal) ' Me.txtFileHyperlink = strInputFileName ' If DBPixMain.ImageBytes > 0 Then ' Update the thumbnail...

Thanks PHV for reply, Me!ItemId & ".jpg" that just gives me itemID which is an autonumber that has been used in the folder. So each image has a unique id. What i would like to retrieve is the actual filenames for the hospno. for example in folder images, there would be 3 images and there...

...of files in folder (to prevent potential recursive calls to Dir) Dim strFile As String strFile = Dir(strFolderName + "\" + "*.jpg", vbNormal) Do While strFile <> "" FileList.Add strFile strFile = Dir Loop For i = 1 To...

cheers phv that worked. Heres star

...of files in folder (to prevent potential recursive calls to Dir) Dim strFile As String strFile = Dir(strFolderName + "\" + "*.jpg", vbNormal) Do While strFile <> "" FileList.Add strFile strFile = Dir Loop For i = 1 To...

Hi, I am currently using dbpix to load images to the database (the images are linked not embeded). However the sample database i got from http://www.ammara.com/downloads.html uses a button to load the images to the database and then stores them. The feature i would like in my database is to...

Hi all, I have created a mail merge document with suppliers address. I have a table called tblSuppliers which contains addresses for many suppliers. My question is, can it be done by code to press a button and it will loop through each address and print the letter off. There is only one...

Finally worked it out. lstClinicalDetails.Selected(0) = True nearly similar to yours but it helped.

thanks for the reply dean lstClinicalDetails.ListItems(1).Selected = True i get the following error on listitems "method or data member not found"

Hi, My situation is after person has selected a patient from a combo box, many treatments are shown in a listbox (1 to many relationship). What i would like to do is when a patient is selected from combo box i would like the first record on the listbox to be selected and highlighted. Can this...

thanks for the reply lupins46 Could you explain that more clearly, don't know what you said.

Hi, all Basically i am tryin to make a reference to control that is on a subform. The main form is called Patient4 the subform is called frmTreatmentSecton and the control (textbox) is called txtClinDet the criteria i came up with is this...

give it a go now it should work http://www.shef.ac.uk/~ns/Test/TreatmentDay.htm

Hi, this my first website i have constructed it displays well on dreamweaver and my computer when i run it. However when i upload to our server comes out quite messed up. Its particularly effecting the scrolling layers (when user uses mouseover to scroll up and down the web page layer would...

cheers

Hi all i get this error error parsing styles on this line of code. The "<a href" is underlined in red. <div id="down" style="position:absolute; left:942px; top:505px;<a href="javascript:;" onclick="return false" onmouseover="dw_scrollObj.initScroll('wn','down')"...