Search results

Hi all, I have created a function that I feel is worth sharing although it isn't quite doing what I expect. Here's what I have in my database: I have a long list of Tests each with an assoicated PDF file Each of these tests has a specific ident but can belong to a specific section i.e. 1a...

Afternoon All! I have a function (activated through a Command Button) that opens up a PDF, copies the contents then tries to paste this into a field on the form. I am having trouble getting the function to return correctly to the open Access Application and hence the correct form field. Ive...

Morning All, I have been having issues with a number of functions trying to capture a 'Bad File Name' or 'File Does Not Exist' error (#52), before it occurs. I was wondering whether I am doing something fundamentally wrong as nobody else has seemingly struggled with this. There are a large...

Ok, I'm again at my wits end... I really don't understand why the following code isn't looping through correctly. The code is to pull out a string (path) for each element in the variables array. Then for each element in the three arrays, write the string to the given file i.e. elements 0 first...

Evening All! I am familiar with the DAO Openrecordset function when using tables. I know that the following code works when using a table but I would like to use it using a query I have saved away; as follows: Set MYDB = CurrentDb() Set TARGET = MYDB.OpenRecordset(stQuery) TARGET.MoveFirst...

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...

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...

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...

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...

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...

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...

Please guys I am begging for some help here ..... as I have no idea where to start. Basically, I have a list of tests each test is an individual record and within the record there are fields such as test name and test directory (which, using hyperlinks, is used to find the actual test files...

Hello all, I am trying to extract some data from a file so I can import it into a date field. The data lies on the third row of the file does anybody know how to grab it??? The data is as follows: Test: 1a Time: 14.02 pm Date: 3-Mar-08 Your comments will be greatly appreciated. Regards, Ashley

Hi, I have a report that shows all the records of a crosstab query. Basically I would like to split the report up into three section. My main field in the report is "Section" which runs from 1-6. In the report I would like to have Sections 1-3 seperate then section 4 on its own followed by...

Hi guys, I have a bit of a tricky one here and have no idea where to start. Basically, I have a list of tests each test is a record and within the record there are fields such as test name and test directory (which, using hyperlinks, is used to find the actual test files (PDF's in a...

Afternoon, Still climbing the steep learning curve that is Access and VB! Please could you help. I have a list box in one form (frm1) that displays information from a table (tbla), I also have another form (frm2) that has a combo box with the same information as tbla but can vary from record...

Hi guys, I hope this is fairly simple to do. Have looked around but cannot find the answer. I have a form which is opened from the switchboard either in add mode or edit mode as defined by the switchboard manager. Basically, if the form is opened in add mode (or a record is added in edit mode)...