Search results

Hello, How can I check if a directory exist? I.e: I have a directory c:\database\photos\0. I want to check if this directory exist and then create a directory, called c:\database\photos\1. Can VBA create a directory? Thanks in advantage for helping me. It's becoming a serious problem for me...

Thanks a lot! The kill-statement works great Thanks again for the fast response! Albert

Hello, I want to delete a file (several files) with VBA. But i can't find anything about deleting files. Only copying files. Does someone know the code to delete a file from the harddisk? Thanks a lot! Albert Romkes

Thanks for the replys. I tryed both things and now it works great. The explanation from the_doc_man helps me a lot. Thanks again. Albert

Hello, I want to search in a table. In a textbox the user had to type the name of the name of the person he is looking for. In the table is a person called "Marinus". I want, when the user types "Mari" that "Marinus" is found. My SQL statement looks like this: Dim rstthumbs As Recordset Dim...

Thanks for the replys I changed the order of my references and now it works great. Thanks again, Albert

Hello, in Access97 I'm using this statement: dim db as database In Access2000 is doesn't work! Does anyone know what the right statement is? Thanks a lot. Albert

Behind the password texbox, in the onChange-event enter the next code: if nametextbox.text = "open" then DoCmd.Close acForm, "NAME OF YOUR FORM", acSaveYes else msgbox "Wrong password" nametextbox.setfocus end if Greetings, Raindrop

Try working with a textbox and then use the inputmask 'Password' Raindrop

Hello, I'am making a form that displays thumbnails. Access97 contains a thumnail viewer. (Wang Image Thumbnail Control) In my table are 20 or 30 pictures (references to pictures!). The form must show all the thumbnails. My question: How can I show all the thumbnails on a form? How can I copy...

THANKS A LOT DMC! It works great. Now I'm out of trouble! thanks again. Albert. PS. There was missing a 'loop'. The code below is how I use it now: Dim rstthumbs As Recordset Dim dbs As Database Dim Txtz As Control Set dbs = CurrentDb() Set rstthumbs = dbs.OpenRecordset("SELECT naam FROM...

hello, I have a little problem. I have one table and I want the user to search if a value already exist. He/she types the value in a textbox and then push a button what starts the code. However, my code only find the first record of the table. Can someone help me with this 'loop-problem'...

Hello, Is it possibele that a user select a file with a filechooser? (browse...) Is there a filechooser in MS-Access? The path of the selected file must be stored in the database. I hope someone can help me... thanks. Albert

Thanks! with some changes is works great. Albert

Hello, I'm trying to open a picture with microsoft photo-editor. How can I do that? The path to the image is stored in the database. Now, I want to open it by a command button on a form. Can someone help me with this code?? thanks a lot... Albert

The main question is: how can I show an image on a form, as a result of an search action. The user select some criteria, e.g. a date. Then the application must show all pictures of these date. The user must be able to print and te enlarge the picture or view it in an external viewer. (Microsoft...

I'am looking for a good book about VBA. who knows a good book for me? thanks, Albert

HELP! I have a problem. I'am designing a application to store images. These images are stored on a server. A user had to type some criteria in the acces application and the application had to give the results images on a form. Because the user had to pic out a picture, on the form must be a...