Search results

:D - Nicely Put :D

Re: Embed PDF file in bound control - Final Okay, after a week of frustration I have worked out all of the possible reasons for my code not working and have a documented process for moving forward. To recap: The scenario is that I want to embed a document (could be RTF, PDF, DOC, etc)...

Why don't you look at SQL Server? You get a free copy that can cope with all of your current needs. Access will be able to upsize to SQL Server seamlessly. During the upsize process choose the option to create a new Access Data Project and get used to using that method from the outset as...

Have you tried attaching the A95 DB tables to A2k3? Once attached you can create any queries needed in A2k3 without requiring changes to be made to A95 apps. This query process is also a lot more intuitive than MS Query. Base on what you have said I think that you would be able to realize the...

Stephen Lebans does a brilliant job. Download the zip file from his site and it has all of the DLLs required as well as sample code. In essence you import his modReportToPDF module into your app, copy 2 DLLs into your %systemroot%\system32 folder and call his function as follows...

@PBaldy DEAD Right my man The SUM() will not work without the group by clause. Haven't test it yet, but makes absolute sense.

I have not recreated your table in my system, just did a quick syntax check. This is how I would probably construct the query. -- ******************** Select -- I have prefixed the fields with the aliased table (p) here p.[Part Number], p.[Invt GLG], Sum(p.PYUsage), Sum(p.CYUsage) from...

where convert(char(10),[Trans Dt],101) > N'01/01/2007' should give you a better result than where [Trans Dt] >= N'1/1/2007'

Re#2: Subquery Help (WRT Date formats) Does the year() function you are using correctly return a string value and does the [trans Dt] field contain the expected string values that you are filtering by? Should you not be CASTING or CONVERTING these fields to string values?

Re#1: Subquery Help (WRT Syntax) WRT syntax: try case When Year([Trans Dt]) = '2007' Then [Qty] Else '0' End as PYUsage, case When Year([Trans Dt]) = '2008' Then [Qty] Else '0' End as CYUsage

Just as a matter of interest, the HR apps are the select few that effectively require tables to be designed that are related to itself recursively. The classic HR personnel table will hold FName, LName, {Contact Details}, SupervisorID,RoleID,DepartmentID The SupervisorID for the President...

Take a look at this app. I have not factored in the the various job roles because I figured that you can learn more by trying to do that yourself. There are several ways that you can handle the relationships, but this was the quickest (I knocked out the entire app within +-30minutes) Given...

Sample embedded application Okay, this is awkward. All of the code works. In other words, the sample code that I first posted all works :rolleyes: The problem is that the varFile variable I created was not well formed and so broke the app. I have put together a quick sample app with the...

Has anyone tried the code that I posted originally and looked at the .Class = "AcroExch.Document" section? The problem as I mentioned was with regards to the class of document, which confirms what I found out with the RowSet() exercise mentioned earlier - that I need to push some kind of class...

Mike375 The core of your solution lies in your FileToBlob function, which also calls your ReadToBinary function or ReadToText function, depending on the type of data being transferred. The relevant portion of the code is: ====== Case adLongVarBinary If FileSize > Threshold...

Yes, the method has been removed from Access 2007. The preferred method is to use the file system object. Use the following: '=============== Sub GetFIleNames (StrPath) Dim FolderLength As Integer Dim fName As String Dim objFSO As FileSystemObject Dim objFolder As Folder Dim objFile As File...

Hmmm. That was stupid, I should just have posted a text file that could have been downloaded instead of placing the code here to read through. Sorry guys

@DCrake The application.filesearch method used in the [FrmFilesIn] form is no longer used in Access 2007. I have modified the code to read as follows: '=============== Amended FindAllFilesInFolder Code ========== 'Amended By: S. Achim 'Amended Date: 17 Dec 2008 ' Comment...

Thanks Mate. Appreciate the effort. Problem is I have spent the better half of this day trying to track down a working example. Working within Word, Excel, JPGs and GIFs do not represent problems. Doing it manually is also a no-brainer. Getting the darn thing to work with VBA is a pain that...

Thanks Rabbie, Due to the business rules behind the app I am forced to store the document in the database. I have also rephrased the question along with the code I am using and posted it as a new thread. Could you visit: http://www.access-programmers.co.uk/forums/showthread.php?p=787028 and...