Recent content by BrunoBB

Good point Bob. You're correct that it's not a well designed (normalized) data model. Some background... My users are entering data into a handful of standardized Excel templates. Each template corresponds to a different entity (can't get too specific). Users can also add columns to each of...

Hi folks, New to Access and need your help... I've split my mdb into FE and BE. My application is such that new tables will be created almost daily. What I'd like to do on the FE is dynamically relink to existing and any new tables added on the BE, but I'm not sure how to go about it in...

I could be wrong, but I think there's an extra double quote just after the last single quote on the second line. I've rewritten your SQL below... strSQL = "DELETE * FROM [tblBuilding] WHERE " & _ "[fldBuildingId] = '" & Me.ItemList & "';"

Very inexperienced with Access, but I've mananged to build an application that queries my Teradata db and returns the results as a report. My problem is that when I want to print this report, Access runs the query again and then prints the report... Is there any way to basically print the...