Recent content by macca007

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

Hi i have this code which gets the filename and adds to the database. However the code to get the next file is: Me("hospno") = dir Which works but does not execute in my code. I used the msgbox dir which shows me next file in the folder. However this is not added to my database. Could...

Hi the code below gets images stores the id and filename to the table tExternal. My problem is highlighted in red, what seems to happen it only pics the first filename and copies that to the database. eg. id hospno 1 snap1.jpg 2 snap1.jpg 3 snap1.jpg What i would like...

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...

Hi all, I have this code which looks into the path of the folder of images and loads the images (one big image and the other a thumbnail). My question is, How do i get the filename from the file? (i have higlighted the code in red where i would like to store the filename) The code is this...

cheers phv that worked. Heres star

thanks phv for replying, The code behind the batch load button is this: Private Sub btnBatchLoad_Click() On Error GoTo Finish Dim strFullPath As String Dim strFolderName As String Dim i As Integer ' Display a 'Browse for folder' dialog - see 'BrowseForFolder' module...

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.