Search results

I would tend to agree with namliam.... example provided: Public Sub GetFileList() Const ArrTop As Integer = 300 'allow 301 files Dim strfile(ArrTop) As String Dim strdrive As String strdrive = "C:\pdfs" 'location for PDF's On Error Resume Next With Application.FileSearch...

Okay, I have been trying for a while now but am begining to get repeatingly lost and my code is up in the air at the minute! Basically, I have an on-click command that uses the .FileSearch Property to locate specific files in a specific directory. This works perfectly. If there is more then 1...

Hi All, I am trying to search for a string within a PDF using a VB function. Problem is that VB is looking into the PDF as you would see it in a notepad editor, which looks like a load of gooble-dee-gook!!! And hence the word I'm looking for doesn't appear...... I've got a work around but it...

Hello People, I want to use a combobox or a listbox to filter a report. I have a table (tbl1) that has a field named load. This field could be anything but is often the same for a number of records, generally there are 3 or 4 variations. So basically I would like a combobox to display these...

Any recommendations George??

Hi all, I am trying to put together a function that will perform the following function: 1. Search through a PDF and look for the word 'PASS' 2. Return a flag if the words are found and also the number of times they appear. The main problem is that I'm searching for a word in a PDF file...

Sorry u miss understand me.... I have coded a msgbox function in VBA that pops up on the click event of a button. I was wondering whether I could put a checkbox in the message box such that next time the button was clicked the message would/would not show depending on selection. Kind of like...

Hi all, I am using the standard MsgBox function in VBA and was wondering..... Is there a way of having a checkbox appear that allows you to suppress the message if it is checked. i.e. sort of like the messages you see in windows (do not show this message again). I'm sure this could be done...

Excellent, thanks for the response Cyberlynx. I didn't know about the SendKeys function very handy!!

Hey guys, Not sure where to start with this one. Basically, I want to open two pdf's on the click event of a button but have them appear in Adobe Reader side by side for comparison. This can be done manually when the PDF's are open by going through the various menu's in Adobe Reader or by...

Thanks CyberLynx, now works fine...! Could you possibly explain the logic behind the quotation marks etc. as it is a common problem I have? Thanx again.

Please can someone spot the errors of my ways, this is driving me nuts... I am trying to see if a record already exists matching the criteria used in the DCount function. I have used this successfully in other areas of my project but it doesn't seem to like this one!!! I am getting a Data Type...

Thanks for your response Neil, is there any way I can move forward with this. Perhaps add a PK in the query????

I think someone was asleep when they were teaching Access!!! Me! I have now solved my problem purely by using the Sort and Grouping Dialog to group by first character and then in the Order By property for the form I have set 'Sections' Excuse my lack of basic Access knowledge! Thanks guys.

Surely you can see my dilemma then.... I have Sections that can only be grouped by 1st character otherwise they are grouped individually i.e. ----------------------- Section 1a 1b 1c 1d etc. --------------------------------------------------------- Which doesn't bode well for my...

Hi, I have used the Sort and Grouping function in access to group records by a field in a table called 'Section', which can be 1a, 1b, 1c, 2a .... 5e etc. I have used the first value of the 'Section' to group them which works fine but I am getting something odd...... When I view the report the...

Ok guys this SHOULD be an easy one..... I created a Union Query that transposes the columns in a table to the rows. This works perfectly! I have used this query in the RowSource for a combo box I have on a form which displays the values in the query fine. Only problem is that I can only select...

Awesome work Cyberlinx!!!!! Still unsure how u think that is not difficult, but hey I appreciate the help immensly. Thanks once again.

See Earlier reply.....

Re: Cyberlinx Geez.... ouch! Ok, I've attached my table that I'm working with and here's the answers to your questions. - The file name located in the sub directory will be put into the Test field. But must only be the file name without the extension. i.e. 1a.01.10.GM not 1a.01.10.GM.pdf...