Search results

I need to embed a PDF file into my DB. Based on the client's business rules I cannot maintain the document outside of the DB. I cannot therefore link to a given location outside of the database. The code that I am using, which I have confirmed from several different sites, is as follows...

Hi Filo65 Did you get a response/answer to this puzzle? I have the identical problem. T

Hmm...:confused: Perhaps I misunderstand - or perhaps I have been too short in posing my question. There is a FaxDocument object that comes with the Fax Services bundled in XP, Windows 2003 Server and Vista. One could use a piece of code such as the following to send a test document. Dim...

How do I output a report from Access 2007 directly to a Fax Server residing on Windows 2003 server? The idea being to run a "mail merge" like application that sends the correct document to the correct recipient. I do not want Outlook installed on the client machines though, so the solution...

goto: http://www.access-programmers.co.uk/forums/showthread.php?t=155752

Zoe, I have included just the relevant bits of the relationship diagram as a quick point of reference. The problems are as follows: 1. Master Table has PF manually set The Master Table (costume item) has a Primary Key set, but you are expecting to manually input a unique value in here. By...

I have just received a rather nice piece of code from Metra Christofferson at SQLServerCentral. You can can click on the link here to see the complete thread. ( http://www.sqlservercentral.com/Forums/FindPost560449.aspx ) I am copying his code here - after a little bit of cleaning up for...

I guess here is about as good a place to start asking questions as anywhere. The chances are pretty good that you will come across someone who can answer your questions - even if you have to wait a while for the world to turn to accommodate everyone's time zones:cool: I would love to spend...

Try the file I just created for you. Pop me a question if it doesn't make sense. T

Well, it is not so much a question of what is missing from existing managers as much as it is a question of what is missing from my applications. It would be nice, when building a large solution, to have a completely integrated management interface dropped into the app, you know - like an...

Thanks a million George. The question is: Can I generate a T-SQL statement like the piece of SQL code in the attached txt files, then execute it on the backend server using ADOX? Or is there another way to do it?

How do you write a purely T-SQL state such as CREATE VIEW, ALTER TABLE, GRANT/REVOKE CREATE DATABASE within VBA. The idea being that I wold like to build up a dynamic sql string, based on user input, then EXEC that string via Access/VBA on the SQL Box. This is part of the SQL Admin project...

With XAMPP in the PHP world, you can install PHP, Apache, MySQL and all of the tools needed to manage a complete solution from a single installer. All of the ADMIN for this environment is then run from a PHP driven front-end, which I reckon is pretty cool. So, I want to recreate that kind of...

Excellent! it is working like a dream. Some things I needed to do initially are: Changed the routine to be a boolean function so that I can trap successful operation Pulled the Username & Password from the form Made sure that the users were created in SSMS and that they had the permissions...

Thanks a million. I have been trying the code, with the various addendums. Getting "random" errors about tables that are not found. Busy debugging & fault finding. Will give a detailed breakdown when it all eventually works. Thanks again.

Banana you have just opened a whole world for me:D I had never put the time aside to actually look into DSN-Less connections, because I felt that, if I need to go to that much trouble I might as well get the job done in VB, ASP or something else. And there i thought I knew Access! You have...

Well, in SQL Server i can set up an OnUpdate, OnInsert or OnDelete trigger on a set of tables, pull out the current user and write the username, table affected and table changed into an audit table. The only thing is, I need to ensure that the user is logged in using SQL Authentication and not...

Howzat Banana, do you mind taking a look at my latest post. If I don't find an answer to my problem soon I could end up spending all night writing more expositions. Sorry I don't have any Gorillas to help you with your addictions though. Sean

I kinda like thinking that if I can create a query that can see exactly which records I need to delete first, then change that query to a Delete Query, run it with a docmd.OpenQuery "QueryName", followed by a Form.Requery that it is a lot cleaner. It is faster and it does not cause as much...

Anyone got any ideas on how to re-attach SQL Server linked tables please? I need to re-create a connection with a different user after clicking a LOGIN button. I have been running around in circles now trying to figure it out and am at the point where I need to ask for help. I have tried the...