So, we have imported data which we have queried and then created a pivot table off that query. It is essentially a list of files, each having unique ID numbers, and various attributes (file extension,
I have an access database that uses a continuous subform on a form. The continuous subform contains a date field follo开发者_如何学Cwed by three check boxes that link to the single date field. The use
I hope someone c开发者_开发知识库an help me out, or at least help figure out a workaround. I\'m using Access 2007\'s split form feature, and have the code below run on the Form_Open event, as well as
My Access programming is a little rusty, & I\'ve never worked with Excel files all that much. I have a requirement to bring data from Excel spreadsheets into Access 2007. These spreadsheets have
This design problem is turning out to be a bit more \"interesting\" than I\'d expected.... For context, I\'ll be implementing whatever solution I derive in Access 2007 (not much choice--customer requ
I\'m scratching my head whether this idea is worth exploring: I\'d like to use a tab control to filter a subform field by the value of the tab control page. There are about 5 different 开发者_开发百科
I usually make applications with the front end in Access 2003 - 2007 and the back-end on SQL Server 2008. When I create an ODBC to link the tables in access I have two choices in the ODBC Data Source
I\'m quering the table MsysObjects for making a list of the objects in my database: SELECT MsysObjects.Name, MsysObjects.Type
i would like to distribute an access front end to some people and i want to make sure that they do not edit anything in it开发者_StackOverflow; however when i change the extension to ACCDR it makes al
I\'d like to have a macro, called Macro1, for example, run every day at 9 AM. It works great on its own from the VB code editor in Access 2007 but I would like it to be able to execute automatically w
加载中,请稍侯......