Search results

Solved! By uppdating refernces THanks

Hi I am trying to extract text from a word file, but when running the code, i get an error: Compile error: User-defined type not defined and the following line is highlighted: Dim myDoc As Word.Document I am not sure how to solve this, any ideas? Best regards

Hi using the inStr function returns the position of the first word in a text. So let us say that I am excuting InStr(1, myString, "word"), then I will only get the position of the first word in the text Any idea of what to do if I wanted to find all the positions of the word in the text if the...

Hi I need to write a VBA for searching through the content of an external word file then import the sentence containing a certain word to a table in access Any idea please? Best regards

Hi all I am writing a VBA code, this is th first step of a lrage project WHat I am trying to do is to put all the content of a word file (.doc) into a cell in access using this code: Private Sub Command0_Click() Dim app As Word.Application Dim objDoc As Word.Document Dim sVal...

Hello again Bob I have done what you suggested, strangely i did not get the UNC, rather a path that looked like this: G:\myfoldername\mysubfoldername Any suggestion? Cheers

Hi Well, I would not say that I am the most experienced VBA programmer, I know a bit, and I can look through the internet on how to use those commands I know I should not ask others for easy solutions, but you wouldnot happen to know where I could find a similar VBA code that I could modify to...

Hi All! First lots of thanks to this wonderful forum and to anyone who would be able to help me in this difficult task Here it comes: I am now working on my PhD thesis, in one project I have received a CD with about 1000 separate word documents. Each document is about 30 pages long In each of...

Thanks again Bob, you really made my day. I really dont know how I would have maanged to so this project without the help from this forum Bob, I am going to post another very challenging question today, I hope I would get an answer from you Regards

Realy appreciate your answer, I will try that with our IT, hope they will give me the full UNC path (they are quite paranoid!) Regards

Hi and thanks everyone for the great answers So here is the dilemma: I work at a large "company" with an excess of 10000 PCs. Our "fantastic" IT has introduced this new PC environment (which actually only makes it easier for the IT department to manage all those PCs centrally, the thing is that...

Hello, My apologies if this question was asked before I have myself created an access database (with great help from this forum), then split the database into frontend and backbone tables. During the last months thousands of data have been input into the table Now, because of changes to the...

Hi all I am really desperate for help... I worked on a project in 2008 and it took me about 6 months to finish the access project, alot of VBA programming invloved, and just to protect "my own masterwork" I protected the VBA modul with password Now I need to make som changes to the database, and...

Thank you for the reply I was more into using the left mouse buttin instead of the right mouse button when clicking, the answer you gave means users must right click the button, but i mean opening the menu through clicking the left key

Hi Guys Is there a way to build a button in access which when clicked showes likes a small menue which the user can chose from? ex clicking on "Export" button brings up a minimenu on the button with 2 options: Export to Word Export to Excel I Appreciate all your help guys

Hi Guys I have a Questions please In my DB, One of the buttons exports a query result to an excel file using the follwong command line: DoCmd.OutputTo acReport, stDocName, acFormatXLS, , True my problem is that one of the fields exported is a 12 numerical digit... When exported to excel the...

Hi Guys I have a Questions please I have created a DB and a help file to it (.chm) i am rying to make access open this file whenever F1 is pressed no matter where the user is, it seems a bit tricky, any suggesntions about how to do this?? I Appreciate all your help guys

Hi Guys! Thanks to the help of everyone in this form i have now finally completed my project... There is the final problem: Multiuser access.. According to what i read in the internet, the way to do this is (to Split the database file into a front-end application database, consisting of the...

Hi Guys I have 2 tables that i need to process with MS Access The first table (PatDB) has, among others, 3 columns called Dx1ID, Dx2ID and Dx3ID Those columns contain numerical data from 1 to 30 I have another column (Statistic) where i want to do some statistics about the occurens of each...

Hi Guys I have a medical database in which there will be tables holding about 3000 x 20 enteries (ie about 60 000 records), information will be stored like patient age, sex, diagnosis, ..... Is there a ready way to get good statistics easily form the table? t ex total patients number, mean age...