Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ChrisHaynes

  1. ChrisHaynes

    Check file exist's on computers in network

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

    Check file exist's on computers in network

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

    Order By Highest First?

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

    Order By Highest First?

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

    Need help on table relationships

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

    Need help on table relationships

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

    Need help on table relationships

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

    Need help on table relationships

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

    Need help on table relationships

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

    Need help on table relationships

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

    Update record on 2 tables??

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

    Update record on 2 tables??

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

    Update record on 2 tables??

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

    Command button to open a word document?

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

    Command button to open a word document?

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

Part and Inventory Search

Back
Top