Search results

I’ve developed a bill of materials database for a client and it works well but I need to add on a facility for employees to requisition parts from various suppliers. Central to the database is a Parts table. The new part of the database with a reduced parts table and suppliers table is...

I had a problem with Office xp developer in producing a run time Access distribution to PCs with Windows NT. The set up would not run to a conclusion. This was cured by getting the Service Release 1 and after installation of SR1 the Access package will apparently install on the NT machine...

Thanks - yes I already did that in fact from 2002 to 97. I don't think it does anything for the VBA

I have a routine that creates an Excel 2000 or 2002 workbook, exports data from an Access 2000 or 2002 database and formats the worksheet. I used an example in the Access Cookbook to start and modified it. I now have to work back to an Office 97 version. Can anyone give me some guidance on...

I have an Access database that uses New Excel.Application to create a new Excel worbook and export data to the worksheet, format it etc. The database is being distributed using XP developer as a run time database. I obviously have Office XP and of course Excel 2002. It seems to be OK with...

Brad, Thanks for the clue. I tried it with the Win 98 and Win 95 PCs and it got me past that hurdle. However with 2 different Pcs the Win 95 install hit another brick wall. It went through a reboot part way through and then continued the install until I got Path / File Access error. Further...

Yes - I would think so. Presumably you have split to a front end runtime and want the back end on the server. So therefore the front end is set to link to the back end before you create the run time or use some VBA to allow a relink from the front end

John, Thanks. I think at the first attempt I did not scan to include Graph.exe and some system libraries. I've made a package which is now OK on my PC of course but is also OK on a Windows 2000 PC with Office 2000. The installation fails on a Windows 95 PC with Office 2000 and fails on a...

I have already distributed a read only database as a pilot to Office 97 and Office 2000 users by using a split front end and back end and having separate Access 97 and Access 2000 front ends as mde files. The database uses charts and therefore uses Graph.exe which has various versions from 97...

Thanks for the reply but I've tried RecordsetClone without success. Perhaps I should restate my problem. It applies to forms as well as subforms. Since asking the original question I've tried the same thing with a form. The problem is this. I want to be able to change for example the...

I have a subform based on a query that records the usage of equipment in a series of tests. Each equipment use or allocation is between a start date and end date. The dates are set using the calendar control and everything works well. I set a start date for the whole series and the first...

All charts or graphs are based on some underlying query so you change or reference the data in the query

Thanks - that solved it A rather late reply!

Can't find GRAPH in Object browser See the quote below I'm using Access 97 and also have Access 2000 installed - separate directories and everything works fine except I can't see anything about GRAPH in the Object browser. I've reinstaaled Access 97 and checked that the help files and...

David, Can you please explain what the references are that you refer to? Thanks Brian

I have an enquiries database on the server used by several people. It's split front and back end and I have 2 front ends - one for 2000 users and one for 97 users. The front ends are MDE files. Everyone's happy except one of the 97 users. There is a switchboard with buttons to get to various...

MSChart is probably THE worst graphing engine and I don't know why Microsoft can't improve its capabilities or produce a separate application that can link with Excel or Access. I think Jodi_MHS wants an alternative because MSChart is so poor. I have produced loads of reports with 3D charts...

Thanks, that worked

Thanks but I already know how to do that. I suspect that there are no straightforward SQL statements or wizards and its a VBA code route.

I have a query with 3 fields MemberID,CategoryID, ScoreID whereby a number of members have scored from 1-5 in several different categories. I want to select only those records where the members have the highest score in each category. Where 2 or more members have the high score,I then want to...