@ADezii,
I'm thinking that may be a dead end. I am now trying to do this with an XPS document instead of a PDF. I will open a new comment thread. Thanks for taking the time to read.
RugbyKorn
Rugbykorn
Last Activity: May 6 '13, 08:47 PM
Joined: Mar 1 '12
Location:
-
Hi @ADezii,
Do you have any suggestions for how I can turn the entire contents of the PDF into a string so that I can then use the inStr function?
RugbyKornLeave a comment:
-
Hi Seth,
Again, thank you everyone for taking a look at this as I would love to figure this out. At the bottom of the code a MsgBox is displayed showing the value that was searched for, but as you said its not displaying the actual value found. I know what I need to do, which is to search for a value, and identify the characters next to that value, say the 10 characters to the right of it. However I don't now how to index the whole PDF...Leave a comment:
-
Hi Rabbit,
I appreciate you taking the time to review my post. I was hoping it would be that simple but here is what I ran into. The code I pasted usesto locate the string I want. However that function is simply a true false (0 or 1) as to whether the string I specify exists. What I need to do is search for the "string" and anything to the right of it, so something likeCode:gAvDoc.FindText("String", 1, 0, 1)...Code:"String"
Leave a comment:
-
Selecting text to the right of a specific string
Hi,
I am using some code I found online to find a text string in a PDF.
...Code:Private Sub Command3_Click() 'IAC objects Dim gAvDoc As Object 'variables Dim Resp 'For message box responses Dim gPDFPath As String Dim sText As String 'String to search for Dim sStr As String 'Message string Dim foundText As Integer 'Holds return value from "FindText"
-
Use VBA to pull data from text box in XFA form
Hello,
I am trying to do something relatively simple but as usual I am doing it using a new medium and have no idea what syntax I need to use.
I have an XFA Form (a PDF created using Live Cycle Designer) which has several text boxes in it. I need to reference a specific text box (in this case "textbox14" - I didn't make the form so the text boxes don't have meaningful names) and pull the text that is entered in... -
I cannot get MS Outlook 2010 to launch from MS Access 2003 VBA
Hi,
I am trying to get MS Outlook 2010 to launch when I execute some VBA in MS Access 2003. I am trying to keep this simple since I am just getting started on this project and like to go step by step. I expected this to go relatively smoothly but Outlook 2010 doesn't seem to launch properly.
When I execute the following:
...Code:Private Sub Test_Click() Dim Olook As Outlook.Application
-
Cannot attach mdf file named master
Hi,
I have some mdf files from a legacy system that I am trying to access. I have done this before by attaching them to an instance of SQL Server in MS SQL Server Management Studio. This new set of mdf files happens to have the same naming scheme as the system databases that are standard templates in SQL Server Management Studio (master, model, etc.)
When I try and attach the legacy mdf file named master I receive... -
Ok, that completely worked. I am going to incorporate this logic into my 11 sets of queries, bringing them down from 33 queries to 11 (each with subqueries).
Hopefully that reduces the amount of time the whole thing takes to run.
Thanks for your input. If your (or anyone else) has any other suggestions in the mean time as to how to reduce the run time please let me know.
Thanks againLeave a comment:
-
@Rabbit, I would like to know regarding the indexing of fields in a query.
Also, this is what I have so far. The problem I am having is that the HAVING clause of the sub query is being run after the subquery pulls its data. I think I would need to nest an additional query to limit the possible records to those dated on or before the prompt date.
Right now any records where the max is after the prompt date are being...Leave a comment:
-
How do you index in a query? Or are you referring to indexing the fields in the original table that the data is coming from?Leave a comment:
-
@Rabbit
I've been trying to combine the 3 queries into one but I'm not sure how to. I would think that I need to put a sub query in the WHERE clause but I'm not having any luck making one that works.Leave a comment:
-
The database is normalized. I don't have any data that is repeated in any of the tables, all of the tables have the simplest primary key possible, and all of the data in each table is dependent on its respective primary key.
I have 11 data sets, each with different data, with the only common attribute being the assignment number.
After using the 3 step query string, which is repeated in similar queries for each of the 11...Leave a comment:
-
I have attached a sample to show what I am talking about (thanks for the quick responses).
Import_Address is one of the 11 tables I have.
I then use the queries to isolate the maximum effective date (that is less then the prompt date) for each assigment number.
Current Address is the last step, which uses the dates which I determined in the Max_effective_d ate query in a left join to pull the 'current'...Leave a comment:
-
Many queries feeding into one big query runs very slowly.
Hi,
I have 11 tables each with a large data set. I then have have one query for each of the 11 tables (11 queries) that pulls the person ID and the data effective date for each line in the respective tables, using a <= prompt criteria.
This results in a reduced data set showing all of the records that started on or before the prompt date. For each of these 11 queries I then created a new query that pulls the maximum...
No activity results to display
Leave a comment: