Search results

  1. Teebird

    Database to record training data

    Date, time, name, location, type of training eg. refresh or ongoing, followup date for further training eg. in 6 months time. who the trainer was, how long the session, ability to add a number of names for one session and one trainer. hope this helps. Thanks.
  2. Teebird

    Database to record training data

    Hi All I am trying to setup a database to record details of who and where I trained staff. The ones I have found all include grades and marks which I don't want. Does anyone have a sample database that can help get me started please. Tee.
  3. Teebird

    Software to create menus on CD

    Excellent many thanks for your replies. I will try the suggested software.
  4. Teebird

    Software to create menus on CD

    Was wondering if anyone can recommend a program that I can use to setup menu items on a CD. I have a number of pdf files (training manuals) and I want to put them on a CD but would like to have a menu set up so that CD will auto run and the user just needs to click on a menu button to select...
  5. Teebird

    Access or Excel

    Grade Book in Excel Try this spreadsheet from the Microsoft site. All credit to them....
  6. Teebird

    Excel Spreadsheet for Car Park Roster

    Yes - it would be but my work does not have Access installed - only Excel. So I am trying to create it in Excel. A real headache.
  7. Teebird

    Excel Spreadsheet for Car Park Roster

    Hi All Does anyone have a excel spreadsheet set up for allocating carparks to employees. At my work we have 3 car parks that are shared between 40 people. Evey 2 weeks - the car park is allocated to another person to use for the next 2 weeks. I have tried to set one up but failed totally. I...
  8. Teebird

    ASK merge field - Why does it take so much space?

    Hi All I have 11 ASK fields at the top of my word doc with the relevant REF fields in my doc. My ASK fields are at Font size 12 - because they take up so much space in my doc and push my letter text too far down, I have to reduce the ASK fields to Font size 1. Is there another way I can...
  9. Teebird

    Auto Email

    It relates to the References - I found I had to have the Reference to Microsoft Outlook 10.0 Object Library ticked. In your VB window - go to Tools, References, Browse for the Reference for Outlook and tick and close the References form.
  10. Teebird

    Database permissions - can not open

    I have copied a work database onto my flash drive and then onto my laptop to do some work in it. Now I can not open the database because it has the error message. You do not have the necessary permissions to use the database etc... I have copied the Application file, the Data file and the...
  11. Teebird

    Help with database

    Hi Dave Many thanks for your response and fixing my database. I have done everything you did and I now have all sorts of problems. I think I will give this City lookup the flick. It is now taking too much of my time to get it right. Again many thanks. Tee
  12. Teebird

    Help with database

    Thanks for your reply - but adding the relationships hasn't made any difference. My complete database has the relationships in place.
  13. Teebird

    Help with database

    I need some help with my database and combo boxes please. My cutdown version of my database is attached. On the Members form - I have a combo box to lookup the City name and then add the corresponding values for State and Postcode. The problem I have is that I can lookup the City but it is...
  14. Teebird

    combo box to fill 3 fields on form

    "From the top of the country to the bottom" Thanks for your reply Ansentry. My 1st post was attached to the end of another post "How to populate a form from a combo box " that I found referring to combo boxes yesterday at 4.44pm. As I was waiting for a reply and the post did not quite meet...
  15. Teebird

    combo box to fill 3 fields on form

    Many thanks for your reply. This is sort of what I want. But when I select the City and the other 2 fields fill automatically, and then I close my form, the data is not saved. Also if I select a City from the list and then move onto the next record, the value I selected is displayed in the...
  16. Teebird

    combo box to fill 3 fields on form

    I have the fields City, State and Postcode in my Member's table. My Member's form has the same 3 fields. I have the CityLookup table which contains the City name and relevant State and Postcode. I want my users to be able to either select from the combo dropdown list to select a City or...
  17. Teebird

    How to populate a form from a combo box

    Hi I have tried your code but I get a compile error. Private Sub cmbCityTest_BeforeUpdate(Cancel As Integer) Me.City = ([cmbCityTest],1) Me.RPostCode = ([cmbCityTest],2) Me.RState = ([cmbCityTest],3) End Sub
  18. Teebird

    Checkbox and If Statement

    :) excellent just what I wanted - many thanks. and yes my checkbox was unbound.
  19. Teebird

    Checkbox and If Statement

    Update - I changed my code to this - that fixes the problem of it updating the field slowly but now my checkbox remains true for each member as I move from one member to another via the form nagivation arrows. Private Sub chkResPostal_AfterUpdate() If chkResPostal = True Then Me.[PO Box] =...
  20. Teebird

    Checkbox and If Statement

    Excellent thanks for that. Here is my code now. Private Sub chkResPostal_AfterUpdate() If chkResPostal = True Then Me.[PO Box] = Me.RAddress Me.PCity = Me.RCity Me.PState = Me.RState Me.PPostcode = Me.RPostCode Else: chkResPostal = "" End If End Sub Except it is...
Top Bottom