Recent content by BF1

  1. B

    Printing date only in a form

    Result Many thanks - the display when option worked just fine.
  2. B

    Printing date only in a form

    Hope you can help - I am currently entering customer information in a form and would like to print the data entered which would then allow it to be used on a pre printed form as well as stored in the DB. The only problem is that the title of each piece of data ("name" "address" ) is printed...
  3. B

    Revisiting Access

    Many thanks for the replies. I can read the forms through explorer but not through the database when using the switchboard. The original folder containing the forms has moved - how do I repoint the database to it ?
  4. B

    Revisiting Access

    Hope you can help a beginner - I have had problems with the DB and therefore had left it alone for a while. I have returned (having used a system restore) and cannot open any of the files through Access (okay through explorer). The message is "failure creating file". Each time the DB is opened a...
  5. B

    Changing property types

    Many thanks for the reply - do you have anysuggestions how I can make records differentiate between what are different jobs at the same store without setting primary keys ? Also, how can I change from number to text type in a field if the table is loinked to a spreadsheet as Access will not...
  6. B

    Finding records

    I am fairly new to Access and have no programming skills whatsoever ! I have used the wizards fairly well to build a database that does everything we need, but can somebody suggest how to improve the record search facility on a form ? The current type via the wizard is the usual excel "find...
  7. B

    Changing property types

    I may have messed up on this one. I originally linked my table to a spreadsheet. I now need to add primary keys to certain field but Access will not allow this due to the linked nature - any suggestions? I would also like to change the data type in one field to mixed numbers and letters - does a...
  8. B

    linked table/form

    Not sure if I have set this up right: I have a form fed by a table that is linked to a spreadsheet. I enter jobs as and when they come in. If a job comes in for the same location, the form cannot recognise it is a separate job, and when reopened, all the details are from the first job entered...
  9. B

    Inserting tables

    Hope someone can help - we have a form where repair jobs are entered on the form individually. This is okay, but we need an overview of all the jobs as well to be sure they have been issued . Ideally we would like the table that is linked to the form to actually appear with each record - jobs...
  10. B

    WAB Files

    reply Many thanks - will export as csv. Usin WAB file as all our address' are held in Microsoft Address Book and I would like to have an address option on the database.
  11. B

    WAB Files

    Hi there Does anybody know if I can create a form that will access windows address book through the database rather than opening it separately ? Thanks in advance
  12. B

    Switchboard pictures

    I am fairly new to Access and have created a default switchboard with other switchboards undeneath. I would like to put pictures in the optin tabs on the default switchboard, but beacause the other switchboards have corresponding option numbers, the pictures appear in the tabs on other pages. Is...
Back
Top Bottom