Search results for query: *

Hi, I would like to have a horizontal slider in an Access Report. So a horizontal scale of 0 to 25, with a vertical bar verticaly through the horizontal bar based on a field value. It would be nice if I could have three areas (red, amber, green) of background colour set at certain values. I...

Mike, Thanks for the replies. Yes - I need the application opening, file loading. I then - depending on the contents of a data record in Access, carry out various operations (opening up notes, highlighting key words etc....). Thay bit is easy - I just dont know why Acrobat crashes every other...

First of all - apologies if I have missed somethign obvious or mentioned in other posts. I have spent most of the afternoon trying to get this to work - with limited success. I am trying to open Acrobat (full - executable) and open a PDF file - using VBA from Access. I cant use hyperlinks...

Sorted it!!! nearly lost all my hair though. Regards Tim Function GetAnImage(str_FormTypeName As String, lint_IDNo As Long) 'Get a forms images from the network (if available) 'ShellWait str_ConvertAppLocation & " -out gif -o """ & str_LocalImageName & """ """ & str_NetworkImageName & "", 0...

Hi, First - I have tried to do a few searches regarding Shell and ShellWait etc... so apologies if this is simple and I have missed something. The problem - I am using a dos program called nconvert to convert tif images to gifs, so Access 2003 can display them within a picture object. Within...

Just wondering - can I import a query from an external MDB as a table through VBA? Is it the same code as importing a table?

Tom, I would suggest the following: 1. Create a blank MDB in Access 2003 on your system 2. Save, Close and reopen If it opens - then continue 3. Import just the tables from the Access 2000 database in question 4. Save, Close and reopen Repeat after importing the modules next, macros...

Thanks Zameer and Tom. The security pop sounds like fun. I have searched a bit on that. Cheers for the feedback. I have upgraded to SP2 but thinking about it, I bet the company will start off with vanilla 03!!! Regards Tim

Tom, Thanks - I dont have a problem migrating the databases. I have browsed around MS, TEKTIPs, googled several different iterations of Migrating to Access 2003. What I am after is some end user feedback on whether things like smart tags are worth the effort. Is there a magic option hidden away...

Hello all, The business I work for is migrating to Office 2003 next year from 2000. I was wondering if any Access 03 developers could point out any new features I should look in to, to improve my systems as I migrate them. I have tried to find 'whats new in 2003' etc... but would appreciate any...

Update - Using ShellExView - I have managed to get the file copying sorted. The only issue I now have is in the standard context window (ie. Right clicking in an empty explorer window) and selecting New ->. Takes 27s to then provide the window that allows selection of new objects.

I have a networked Windows 2000 machine that has been working AOK for the last 6 months. Suddenly, on this one machine only, any time I try and create a folder, browse the file system, copy files, it takes maybe 45seconds to 1 minute. At this magical point in time it then whips through and...

Hi all, Well I solved it in the end by reading through all the Outlook objects/methods!!! There is a resolveall method which you can call, returns true if all the emails To, BCC and CC entries are picked up and no problems reports. False is returned if the system is unsure about any one or...

Sorry, should have said a bit more in the beginning. I am producing the reports from Access 2000 and sending indivualised reports to individuals using table lookup and VB code to loop through all the people, producing the report for each one, attaching to an email and I hope sending the email...

Hi guys, I am currently using Access to send a few hundred management reports out in an automated manner. I am using the Mailitem object and setting all the fields, body To etc... The problem I have is that the company I work for has decided not to insist on indivdual Display Names. We are...

Hi all, I am running through changing all my DAO code to ADO. I have managed to remove all the help files from my laptop and my Office 2K disks are in the British postal system since I left them at another office. Q1. The Connection object, cnn.Open "Provide=Microsoft.Jet.OLEDB.4.0;&quot...

Hi, I need to be able to open Word, create a new Document and open the Insert Picture from Scanner dialogue. Creating an instance of Word and a new Document is easy enough but try as I might I cant seem to find anything in the help file about bringing up the relevent dialogue box. This is for...

HI, I have built a few Make Table queries to enhance the speed of various other queries and VB code. I would like to, once the make the table is run, set a field in the newly made table to be the primary key. I can do this manually but cant find any code to do this in in VB. Any thoughts...

Thanks Norris. I will be splitting the smaller systems to FE & BE but the larger systems need to be able complete a report run (using PDF Pro to produce a few hundred management reports). If I FE/BE the larger three systems the performance is dire while producing reports. Not the SQL fault...

I am using quite a few different objects (Word, Excel, Outlook, PDF) within my VB code. However the growth only occurs while I edit and re-edit the reports. Make a change, go to preview, go back to design and make some more changes. Small amounts of increase at first then it bolloons. Regards Tim