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

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

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?

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

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

Hi all, I have a database (A2K) that when I edit a report a number of times in design mode can cause the MDB file to jump from a compacted 10Meg to a whopping 200Meg!! I have had it at gigs before. I have it set to compact on close and after a v.v.v.v.v. long time, it closes, compacted back...

Hi all, I have a query (Num_Ass) that looks at a list of staff in one table and returns the number of checks carried out against them (located in a second table. So Num_Ass returns a pay number and the number of 'check records' that have that pay number. I have added a where clause with...

Hello gents and gent-ess's, The company I work for has bought BO. Great that it has a VB library but without the deelopers guide and little time to play with it I have a question. I produce applications that work with the Office suite and our own business apps to reduce paperwork and manual...

Hi guys, I have a database that creates jobs in our business applications. The code I use contains this at the top of the module: Private KEASystem As KEA.System Private KEASessions As KEA.sessions Private KEASession As KEA.Session Private KEAScreenn As KEA.Screen When ever I want to use a...

I am currently wanting to drop all my vids on to CD. So I first bought an Asus 8200 card hoping its hardware MPEG captrue would work. Big mistake, never managed to get it to work. I then bought a WinTV PVR card from Hauppauge. I have used WinTV cards for years, ever since they bought out the...

Gents, I am not sure if this should in one of the other forums, but here we go: I have a table of jobs and want to generate a 'status' code for each job. The status code will depend how far a long an agreed procedure each job is at. This depends on whether certian fields have been filled, what...

Hi all, To all the UK users, hope the World Cup/Jubilee long weekend has not left your head too sore! I have an Access 2000 database that manages a process. A seperate database (Lotus Approach 3 & 97 versions) is used as a data gathering form for data that relates to the 2K database. The...

I would like to have an Access table of data, that anyone can access on a read only basis. Also though, I want it to be updatable by an administrator at any time. So a few questions: 1. Is it possible to make a table read only? (ie so that when people create a database they can 'link' in to...

Hi all, Graphs - Reports. Specifically sorting out the axis and grouping settings. I am in the middle of designing a Quality Assurance database. For any that dont know, quality assurance consists of guys going out and checking workmanship, filling in a survey form (tick boxes) and returning...

Hi all, Having built 101 smaller 1-15 user applications that dont need much upkeep, I am now producing a system that will require front end changes on a regular basis. I am therefore looking to use the DB splitter. If I go and split the DB will I have to do anything different? I mean this in...