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...
...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...
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...
...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...
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...
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...
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...
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')"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.