Recent content by ChrisHaynes

Thanks alot for your help! I have decided to create a batch file instead, Regards, Chris

Hi all, I need help figuring out a way to check that all the computers on the company domain have a file existing in a certain directory (same on every computer). We recently edited the current login script to add this file to all of the computers, but need to know that it is definately there...

Hi Remou, that's perfect, thanks alot. Chris.

Hi, I have a form (frmRegistryFiles) and need to show records in order of the highest value first in one of the fields. The field is 'RegNo' and contains 4 digit numbers. I need the highest reg number to show first, then next highest and so on. I know there is an 'Order by' property on the form...

ItIshardToProgram, thanks, I havn't thought of that. I am going to place a table in the middle like you say and change everything from there. I think I'll do a copy of the db first because I've got a feeling this is going to be messy!! Thanks again, Chris.

Thanks for your reply again fneily, The only reason I have department in the scanner table is to filter and populate the computer name box. Not all computers have scanners, so if a PC didn't have a scanner, how would I know what department the PC is in?? Thanks, Chris.

Hi again fneily, Could I ask a favour and let me send you a copy of my database for you to check out? Because I don't think that this technique would be possible to incorporate into my database?? Thanks, Chris

Thanks fneily. That really helps my understanding of how tables work and I can see how to make my database easier for the user. I'll have a go at this technique and let you know if I have any problems. Thanks again for your help, It's much appreciated. Chris.

Thanks for your help fneily. I see your point I do have separate tables for: -Department (containing Department and Department code) -Computers (contaning computer name, model, spec, department, software etc) -Scanners (containing, department, computer name, model etc) I think I need to look...

Hi, I have 2 separate tables, the main table has a list of all the computers in the company along with details about them. I then have a scanner table which lists all the scanners and contains 'Make', 'Model' etc. along with a 'Department' field and 'PC Name' drop-down field (to show what...

Thanks mp9. I dont have the same records in each table. One of the tables only includes a select few, but if data in the field on the main table which includes all the records is changed, I would like the field on the smaller table to change to (if it exists). Is this possible? Thanks again...

Thanks for your reply mp9. I was looking at th relationship optons earlier but didn't really know what to select. I have tried selecting the 'Cascade Update Related Fields' option, however when I click OK, i get the error message 'No unique index found for the referenced field of the primary...

Hi, I have 2 separate forms, both have a field which I have created a relationship between. They both link to records on 2 serparate tables. However, when I rename the field on one form, which I often have to do, this doesn't update the record in the other table, which causes the data to be...

When I said 'form', I meant Word document. Sorry for the confusion. Cheers, Chris.

I used Trollbro's second code and it worked fine? To add to this topic, Is there anyway of opening a form in Read-Only mode?? Thanks, Chris.