Search results

cool, thanks - i see i've got a lot of work to do! so what are these On Err Goto...etc statements? how do they work? Martin

hi i'm rebuilding an old db and want to include error trapping. however, i don't really know where to start. does anyone know a quick guide or give a few examples? cheers cyberz

you need to create a link between the fields that you want to compare on. basically, in the query design window, add the two tables you want to compare. click the field you want to compare on in one fieldlist and drag it to the appropriate field in the other fieldlist. Just add all the fields...

from access help: "Note To list all reports in the database, whether open or closed, enumerate the Documents collection of the reports' Container object. You can then use the Name property of each individual Document object to return the name of a report." can anyone explain to me what this...

ok, but has anyone had any specific issues, especially with regards to ODBC connections? Martin

hey, why isn't this working? i can't seem to figure it out. it's reporting rep as null :S Private Sub cmdReport_Click() 'loads report for the selected party Dim checkReport As Boolean Dim rep As Report Dim reportname As String checkReport = False Set...

hi! this looks like a wonderfully active forum! i congratulate you all! anyway, i'm about to upgrade from 97 to XP. i have a large number of linked tables and MDEs - has anyone had any trouble with the conversion methods? Thanks :D Martin