Search results for query: *

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

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

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

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')"...

Hi i get this error when i run my application. Could any of u hav a look at this code and check if theres something wrong. I think the error is within the sql section. strSQLContacts = "SELECT tblSupplierAddress.SupplierName, tblSupplierAddress.ContactName, tblSupplierAddress.Address1...

Hi all, My situation is to convert several images that are tiff from a folder to jpegs. Is it possible in access to call paintshop pro and do this conversion, since paintshop pro has batch processing facility incorporated. If so can anyone provide me with an example so to get me started. I...

Hi all, I have access 2003 on windows xp. My situation is i would like to convert a tiff file to a jpeg file. Has n e body done this before in access using vba code. Or is there code already done that i could use. Or something that could get me going. Cheers

Hi all, I have this code which checks the value on the listbox if true then it will display msg, if false will also display msg with different txt. If Me.lstClinicalDetails.Column(5) = "avm" Then ' Me.TrigemRC.Enabled = True MsgBox "trigem" Else '...

Hi all, I just upgraded to access 2003 and found that me mail merge (word 2003)is not working. It loads ms word but does not populate the data source fields. Previous version of access was 2000 and office 2000. Just got new computer from work and tried if database i created is working...

Hi all, My brother installed wifi on our pc (linksys) but he did not secure it. My question is how do u set a password otherwise our neighbours could have free internet access. This wifi thing is new to me so if you could describe it step by step how to secure our wifi it will be mostly...

Hi i hav code which found from this website to send attachments. My dilema is that i know the location of folder where the jpg files are. Is it possible by just supplying the folder path vba access can some how get all the files in that folder and attach it to outlook. So far this is wat i got...

Hi all i am tryin to zip a folder but it does not seem to work. The folder Path is C:\Documents and Settings\macca\My Documents\test2 the code am using is sZipName = "C:\Reports.zip" sFileName = "C:\Documents and Settings\macca\My Documents\test2" Shell "C:\Program...

Hi all when i click multi row for tabs, which appear on both rows. Is it possible if click on the top row tab, preventing it to move down ( the bottom tabs move up and top tabs move down). I can see this being confusing for clients. Is there way that the tabs don't move. cheers

Hi all i would like to know if some fields in the table are empty i.e not used. Does it occupy space (does the database increase in size) cheers