Search results

  1. P

    Link the tables

    Thanks work just right.
  2. P

    Link the tables

    Its stupid really but I always struggle to link the data together, would some one please show me how to link the following tables together Table 1 Customer Number Customer Name House Number House Name Address1 Address2 Address3 Postcode Contact Number Mobile Number Table 2 Accommodation ID...
  3. P

    Table linking

    hi, I could do with some help to link tables, can't seem to get it right. Table MAIN ROUTER Router No Router Address Site Contact Site Tele Table SITES Site_IP_address Site_Name Site_Contact Site_Address Table NETWORK Network_Number Network_Name It should work like this, Table MAIN...
  4. P

    Code to compare data between two DB

    We have a database that was designed for us and the data came form outlook. Not all the data was copied over so we have an incomplete DB . Is there any code that can check the origional copy of the data against the new one , see what is missing and copy it over Thanks for any help
  5. P

    Exam Questions

    I have a few questions from an exam. I sort of know the answers be would benefit some other views. 1) Advantages and Disadvantages of the client server approach 2)Dicuss factors that influence speed of a DB over a local area network, What stratagies could u employ ti maximise the...
  6. P

    tool bars

    I have to creat several versions of a menu bar, they all have the same basic functions which some added extras, it is possible to copy a toolbar once you have created it and just add bits rather than creating a new one each time
  7. P

    Quick one

    I understand an agree completely Thanks for the help (again)
  8. P

    Quick one

    no, it is just placed on a form to show some records it is not related to the form
  9. P

    Quick one

    How do you delete the current record out of a list box thanks
  10. P

    auto exec

    Sorry I was not very clear. I have created my own toolbar and I know how to disable them but I am not sure where to put the code so that the built in ones are disabled as soon as the application is started thanks
  11. P

    auto exec

    I have been told to put in an auto exec macro to start my application. Not sure what this means also I want to disable the built in toolbars when the applications is opened do i use the above that
  12. P

    top value

    Because i work out the values in the report (Calculated fields) is this still poss
  13. P

    top value

    hi, I have a report which shows how much money each sales man has taken. I want be able to press a button on a form and only the salseman who has taken the most money is displayed
  14. P

    Report trouble

    Re: Re: Re: Report trouble Yeah I though so, but I have added sales man as a group and still get the wrong total???
  15. P

    Report trouble

    This is the Db with the report, it might make it more clear
  16. P

    Report trouble

    I have a report which summaries the sales by each saleman of the various items on each invoice. I have a calculated field in a Group footer to work out the amount of profit made on each item in each invoice. I am trying to work out the "Total Profit" made by each salesman. i.e. Adding all...
  17. P

    search help

    I need to be able to provide a search for this form. The user needs to be able to search by Invoice No. The form and sub form are linked using salesman number, If you have any ideas for a search lets me know Thanks
  18. P

    Yes/No

    I have a Yes/no Field in my DB have have formatted is so it uses ;"Packing";"Completed" Can I use a third like ;"Packing";"Completed"; "Awaiting Payment"
  19. P

    keep gettin an error

    Re: Re: keep gettin an error I am not sure I was shown the code by some one on this forum ] never realised. to keep as an interger I just user " & InvoiceNo Don't I ?
  20. P

    error trapping

    It still brings up the error would it help if I posted the DB
Back
Top Bottom