Search:

Type: Posts; User: mrmo; Keyword(s):

Search: Search took 0.00 seconds.

  1. locking a record with a tick box in it (access 200

    Wondering if someone might know the answer.

    In my database each record has a tick box as one field. The form over-lying the table uses this tick box to populate two fields automatically, one is...
  2. Replies
    7
    Views
    543

    Re: linking form and subform (2k)

    Thanks, I figured out where i had gone wrong and it is working now. It was the duplication of certain aspects of the database, things that should have been deleted hadn't been.
  3. Replies
    7
    Views
    543

    Re: linking form and subform (2k)

    I think it got corrupted at some point, i re-downloaded and it did seem to work, not quite sure of what i did differently each time though.

    I have been working a little with it and have changed...
  4. Replies
    7
    Views
    543

    Re: linking form and subform (2k)

    Thanks, Doesn't do quite what i want though. I want to be able to have the contents of cmbspecfic defined by the contents of cmbzone according to tbldetail and then have frmfault update to display...
  5. Replies
    7
    Views
    543

    linking form and subform (2k)

    I have created the following database and need some advice regarding a few details.

    First the number in the third combo, isn't chooseable, it is what it is, how would i be able to get rid of it?...
  6. Re: making a subform display the results of combo

    figured it out, i had set tblfault .pid to be a number and then when calling combo10 i was treating it like a text string.

    Now why the error messages can't be a little more helpful....
  7. Re: making a subform display the results of combo

    thanks, that helped a little

    got another error and i can't see why it isn't working as the same code has worked before

    I keep on getting Runtime Error 2001, you canceled the previous...
  8. making a subform display the results of combo box (2k)

    The plan was to get the subform to display all records linked to two criteria selected from a pair of linked combo boxes. I have looked at the cascading combo box example and am getting nowhere fast...
  9. Re: query and form/sub form, relationships (access

    thanks
  10. query and form/sub form, relationships (access 2000)

    Bit more advice really,

    The end result i have in my head, not to sure as to feasibility. First part would be 5 or 6 combo boxes each populated by the decision in the previous. This allows me to...
  11. Replies
    1
    Views
    298

    drop down populating drop down (access 2000)

    In an effort to make my life easier, just after some advice as to the best approach really.

    I have been tasked with creating a database in Access.

    Basic premise is one list box of options,...
  12. Replies
    3
    Views
    5,996

    Re: data sum = zero in a pivot table (excel 2000)

    Thanks, i found the problem, for some reason every number is preceded with an apostrophe? So there are items to count but no numbers to sum.
  13. Replies
    3
    Views
    5,996

    data sum = zero in a pivot table (excel 2000)

    I have created two pivot table in two different files, both are basically the same, i have done nothing different.

    On both i need to display the sum of as picked from right click drop down menu....
  14. Replies
    16
    Views
    932

    Re: sql - using AND in child table (2000/XP)

    Thanks, that is exactly what i wanted.
  15. Replies
    16
    Views
    932

    Re: sql - using AND in child table (2000/XP)

    Thanks,

    any advice gratefully received, It probably isn't the most elegant of databases, that may be an issue? I spend more time in Excel these days just needed to create something that could...
  16. Replies
    16
    Views
    932

    Re: sql - using AND in child table (2000/XP)

    The code is currently as follows.

    Private Sub cmdDuelBoxFilter_Click()
    On Error GoTo Err_cmdDuelBoxFilter_Click


    'begin the sql string

    strSQL = "select tblregion.company,...
  17. Replies
    16
    Views
    932

    Re: sql - using AND in child table (2000/XP)

    I am having a bad day, my head has gone completely!

    Some advice, that may help tomorrow.

    I have three tables, one is the companies, includes various details, second is region this has fields...
  18. Replies
    16
    Views
    932

    Re: sql - using AND in child table (2000/XP)

    Speed shouldn't be too much of a problem, the database isn't that big.

    The full problem is

    c100 companies working in one of 14 geographical regions, and installing between one and five...
  19. Replies
    16
    Views
    932

    Re: sql - using AND in child table (2000/XP)

    Thanks
Results 1 to 19 of 19