I am designing a report that shows product id, description and then quantities and dollar values for 7 different regions plus total quantity and total dollars for each product row) and also sums every
We\'re currently running into an issue with an Access 2007 database for a client.They\'ve got Excel 2007 documents attached to records within the database.Whenever changes to the document are made, th
How can I retrieve the value of specified column of the selected row in a multicolumn listbox? I populate the listbox by setting the RowSource prop开发者_StackOverflow中文版erty with a SQL string. Bo
I have a access 2007 report for which one of the fields returns a numerical value of $0 if there no dollar amount associated with the project listed, else it returns a dollar amount greater than $0.
In Access 2003 I was easily able to get to all the tables and edit/view data directly. However, in 2007, I\'m unable to find this functionality.I have an MDB with a form, and I can only view the main
I am working on monolithic desktop application which interacts with the binary database files and some part with the access database 2007 (MDW database is in Access 97). This tool got some serious mem
I\'m try开发者_如何学Going to call an event when the user returns focus to the Access application when a specific form is open. The following event doesn\'t seem to fire up at all.
In VBA for Access 2007 I wish to create a PDF document and e开发者_Python百科mail that document out to someone. How would I go about creating a PDF document in VBA?You can use the SendObject method of
I have an Access database front-end and I\'m trying to put a button on a form to delete the current record.I used the following VBA code to delete the record:
I\'m trying to implement and test this Performance tip for MS Access 2007 database with ODBC linked tables.