Search results for query: *

Hello, I'm trying to compile yield figures for a product, by week and then quarterly. This is fairly straight forward SUMming in Excel but as always there's something!! On occasion, a particular product might not have been tested and therefore the yield is zero (0)!! Because a percentage and...

I need to create a chart in Excel(not that difficult, I know!) which will graph weekly yield totals. I've set up several spreadsheets linking daily outputs to Pass/Fail totals, from which a graph is created. However (the problem!), the boss would like the graph to automatically change on the...

I was sent a db, built by someone else and which I now need to change around for ourselves here! The problem is that the toolbar and the toolbox cannot be used as they are 'shaded out'!! For example I want to delete a combo box and replace it with Find Record, but I cannot get at the Command...

What is a Junction table and what are it's uses and benefits? I've never heard of them before so any info would be appreciated!

Anyone know how to set the data type in a table to 'Double'? I've been asked to do this with the recommendation of using an Input Mask. The field is 'Revision' as in the revision number of a document and takes the form of 2 digis (eg)Rev 00; 01; 02 etc. any ideas, anyone?

I'm building a db under someone else's instructions! Some of the things they suggest are a bit new to me. Basically there's 4 tables and some links between them (I'm not sure if he means linked by relationships!?) For 1 table (tblJunction) there are three fields and this is what I've been...

Need help on something that's probably quiet simple! I need to try documents held by users at a time! how do highlight the fact that a user would have several docs at once, in a drop-down / combo box type thing without having their info entered in the d/b each time they have a document???

I need help with a security problem! The problem is that my d/b is to be placed on a read-only (to others)folder on the NT server. When this was done first the permissions for the folder hadn't been set-up right, so I went messing with security on the d/b using the Workgroup Administrator...

The data in the d/b I've created is uniquely numbered. (ie) document number needs a unique value for each document!! So when someone adds a new record, anywhere on the server, there needs to some sort of command button which will confirm that the new number is unique (I'm not using AutoNumber -...

This problem arose after taking advice from an earlier thread....<br>I've created admin and user accounts.<br>The Workgroup Administrator file is creating diffuculties in that it asks to overwrite the existing file if someone tries to join it...<br>Now, with Shared Access ticked the databse can...

I've created a database which can be 'doctored' by me and 'Frank'. I want to create an exact copy on the server, except info cannot be added, edited or deleted by others.<br>Do I have to make changes in 'Users / Groups' thingies or what happens?<br><br>Administor: me('Paul') and...

I know this might sound a bit basic, but the method for querying for numbers in Access 95 is not working in Access 97 (eg) to search for all numbers beginning with a 1, I would have used 1*. <br>The problem is this doesn't seem to work for Access 97.<br>Any ideas?