Search results

Found an answer. http://www.tek-tips.com/faqs.cfm?fid=3765 Cheers :D

Hey. I got great help for my last question so thought I might come back :D Im having a little trouble with using an unbound list box as a control for a docmd.gotorecord action. Ok so I have a relatively simple setup with a Main form (Mainform1) and related subform (subform1) related by a unique...

Don't worry got it! Linked the relevant lookup table in the design view box with a relationship and changed the relevant column heading field accordingly. Thanks again for your constructive help.

Ok so Dat Ive created a Crosstab query and it appears to be working well. Your a guru! Thank you very much for your help. I do have one lead on question if you have the time? In respect to column headings, is it possible to show the text descriptions that I use for my field combo boxes rather...

On the case Dat ;)

Well they say a picture says a thousand words so its probably easier for the structure to speak for itself rather than me bumble through incorrect terminology. The image shows the following details (1) the source data table Note that the SampleOID is the primary key of another table of higher...

Sorry should have been more clear on my terminology. By Data types I mean classifications for data values. ie. Colour, Mass, Size Im thinking I should be using left joins of preceding queries to get the result I need though I am unsure how to pass the results of preceding queries to the end...

Hi guys, long time lurker first time poster. OK I've been using Access for quite a while now however have only really started getting into the nitty gritty of using vba and proper database structure. My database has 2 tiers of tables linked by a one to many relationship. Sample>Data I have over...