Search results

It is possible and not that difficult You could either do it as a web based login form, use ASP or ASP.NET to connect to the MS Access db Otherwise you can do the whole thing in MS Access, what you need is a form with drop down menu, linked to a table where you store all users names, and...

Hi! I wonder if it is possible to upload a MS Word file to MS Access db or at least put a link (like a hyperlink) in the db to the MS Word file, and how can that be done? Regards

Hi I really appreciate your answer, works like a charm for importing the table content, much obliged I wonder if you have an answer to the second question, ie linking the same word file to a record (theoretically like a hyperlink) or just loading up all the word file into a cell like an...

Hi I am trying to import text from different parts of several (1000) MS word documents. Most of the text is in Form Fields and is therefore easy to impost However, one part of the text is inserted into a table in the word document, you can see the attached file to see how the table looks like...

Solved! Changing Set app = New Word.Application to Dim app As New Word.Application solved the whole problem, now I can import text to Memo field type Thanks all for your help

Solved the problem! Thanks mate

HI Thank you for the advice I did set breakpoints, and went through the code The last line that the compiler marks as "yellow" and after which the problem starts is the following: Set myDoc = app.Documents.Open(FileName:=oPath & FileArray(i), Visible:=False) Now why on earth would this line...

THank you However, I get the same problem if i totally remove the application.echo, i.e. my DB locks up if i use the field type Memo.... don't you get the same problem if you run it without application.echo? Regards

Thank you for your answers Actually, the problem is not in the part you are referring to 1- if i remove the if statement and runn the following code only, it executes perfectly: Lab = .FormFields("labval").Result vRecordSet("Test1") = SearchForValue(Lab, "IN") vRecordSet("Test2") =...

Hi This is the code here, SearchForValue is a function i have written that looks for a string in another string. If .FormFields("labval").Result <> "" Then _ Lab = .FormFields("labval").Result vRecordSet("Test1") = SearchForValue(Lab, "IN")...

Hi A very basic VBA question about IF ... Else ..... End if What i need to do is do the following If "a certain condition is fullfilled" then do this and this and this Else do that and that and that End if However when i write this in VBA editor in MS access, I get an error, it seems...

The error occurs when I try to import fields containing large amount of data, I tried coping the data manually to the table field with the field type set to Text and I get a similar error "The text is too long to be edited", but if i change the field type to Memo and copy the same data...

Thanks again for your time and effort The only modification i did was in fact the following: Dim myDoc As New Word.Document Set app = New Word.Application Set myDoc = app.Documents.Open(FileName:=oPath & FileArray(i), Visible:=False) And changing Application.Updating to Application.Echo...

Hi again Well I am basically using the code from this site with modification as the code was originally created for use as a macro in MS Word, but I am using it in MS Access after modification http://gregmaxey.mvps.org/Extract_Form_Data.htm I'd really appreciate any help Regards

THank for the reply I did change it in design view, i can at least that much :-) As I said, even if I change the datatype to memo it dose not solve the problem, the whole DB freezes wen i run the VBA code with the datatype set to memo Regards

Hi I am using a VBA in access to transfer a large amount of text in a word file to access The records in my access table are all defined as "text" When i run the code i get this error: Run-time error 2147217887 (80040e21) The field is too small to accept the amount of data you attempted to add...

Hi I am trying to build a VBA modul, two lines with the command (Application.ScreenUpdating) are returning an error: Application.ScreenUpdating = False .. . . Some code here . . Application.ScreenUpdating = True THe error is Compile error, Method or data member not found Anyone has a clue...

Hi Just putting the entire code here, hope someone will give an answer Sub TallyDataInDataBase() 'Extract data from document form fields and store in Access database Dim oPath As String Dim FileArray() As String Dim oFileName As String Dim i As Long 'Requires reference to MS ActiveX Data...

Just a further clarification the error with ActiveX is occuring at this line Set myDoc = Documents.Open(FileName:=oPath & FileArray(i), Visible:=False)

Hi alla, I really need help with this I am trying to run the code form this web site to extract text from a word document http://gregmaxey.mvps.org/Extract_Form_Data.htm The problem is that I am getting lost of erros, many seems to be related to missing references 1- I am getting an error when...