Search results

That's interesting that excel is giving you problems because of admin permissions. To my knowlegde, admin is the default permission for all new database objects. Sorry I can't help much, but maybe that will give you something else to look into.

I am by no means an expert. But i have a little experience in dealing with something similar. If the fields on each tab are going to be unbound, you shouldn't need to use subforms. you can just call a procedure when you open the form to pull data from a recordset through an ADO connection. I...

I am trying to figure out how to write code to transfer all of a database's objects (tbl,qry,frm,rep,mcr,mod) to another database. I have been able to do this with tables and queries by looping through each object definition(tabledef, querydef) in the respective class for each...

My problem is i want to return counts and sums of different record sources onto the same form. Does anybody have a solution? Thank you for your help.

Thank you for your response. Perhaps i wasn't explicit enough. I know how to do that. My problem is i want to return counts and sums from different sources onto the same form.

I am trying to create an expression in a text box that returns the number of records in a query. I have not had any success yet. I've written a total query which does return the count, but i need somehow to get that number to appear in the text box.