Results 1 to 5 of 5

Thread: Any access guru's out there?

  1. 10th June 2008, 03:47 PM #1
    Phoenix's Avatar
    Phoenix
    Phoenix is offline Swaggie
    Join Date
    Jun 2003
    Location
    Launceston, Tasmania
    Posts
    12,347
    Total Downloaded
    0

    Any access guru's out there?

    I'm having trouble with an access database and I need a hand.

    in database i've got database.primary displaying a drop box of options from primaryL.primary. PrimaryL is also linked to secondaryL.

    what I need to do in database is display the secondaryL.secondary options that match the primaryL.primary option chosen in database.primary

    Anybody got any ideas?

    I managed to get the correct items to show by going

    SELECT [secondary] FROM secondaryL WHERE secondaryL.primary= "01 Site Works"

    but I can't appear to just say where it is secondaryL.primary = datbase.primary
    1994 Discovery TDi
    2004 Discovery 2 TD5
    2010 Discovery 4 TDV6
    1961, Series 2 Ambulance. 108-098 - Eden

    Registry of Ex Military Land Rovers Mem. 129
    Defence Transport Heritage Tasmania Member
    Reply With Quote Reply With Quote
  2. 10th June 2008, 03:57 PM #2
    abaddonxi's Avatar
    abaddonxi
    abaddonxi is offline Moderator
    Join Date
    Jan 1970
    Location
    2780
    Posts
    8,257
    Total Downloaded
    0
    Thank god I've forgotten the small amount of knowledge I had about access.

    Loathsome.


    Cheers
    Simon
    Reply With Quote Reply With Quote
  3. 10th June 2008, 04:53 PM #3
    spudboy's Avatar
    spudboy
    spudboy is offline Swaggie Subscriber
    Join Date
    Jan 1970
    Location
    Adelaide Hills - SA
    Posts
    12,486
    Total Downloaded
    0
    I am more into Visual Studio and SQL Server, but I can probably sort it out for you if you zip it up and email it to me. If that suits (and as long as the databases are reasonable size that can be emailed) let me know and I will PM you my email address.
    Cheers
    David
    Reply With Quote Reply With Quote
  4. 11th June 2008, 07:30 AM #4
    Phoenix's Avatar
    Phoenix
    Phoenix is offline Swaggie
    Join Date
    Jun 2003
    Location
    Launceston, Tasmania
    Posts
    12,347
    Total Downloaded
    0
    it's still being constructed in a can we get this to work kinda way, and it's been a while since I did any access work, so don't laugh, but I would love the help, thankyou
    1994 Discovery TDi
    2004 Discovery 2 TD5
    2010 Discovery 4 TDV6
    1961, Series 2 Ambulance. 108-098 - Eden

    Registry of Ex Military Land Rovers Mem. 129
    Defence Transport Heritage Tasmania Member
    Reply With Quote Reply With Quote
  5. 11th June 2008, 08:29 AM #5
    spudboy's Avatar
    spudboy
    spudboy is offline Swaggie Subscriber
    Join Date
    Jan 1970
    Location
    Adelaide Hills - SA
    Posts
    12,486
    Total Downloaded
    0
    PM sent with email address.......
    Reply With Quote Reply With Quote
« Favourite browser addon? | Changing AULRO sig »

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Search AULRO.com ONLY!
 Search All the Web!