Search results for query: *

I am in the process of validating my Access 2003 database and the functionality working in the new Access 2007 environment w/o converting to 2007 - will have mixed environments for awhile. The forms within the AK3 version work perfectly, however not in Ak7. When I open the form with the...

I have a group of code that will update multiple Worksheets within an Excel Workbook and then format the cells according to data within the Excel Cells. from Access Vba The problem I am having is where to place the 2 function to update the formatting of the cells on the 2 separate worksheets...

I need a way to prevent a double quote placed where there should be a single (apostrophe) in the data value. See '>>>>>>>> INSERT INTO TL_FTEM ( FirstofEquipment_ID , NOMENCLATURE , Nomenclature_Modifier , EQPT_LOC_NO , SERVICE_ORGN_CODE , CountOfEQUIPMENT_ID ...

Is there a way to access the Maps without using the SaveAs and establishing the ODBC connection?

I have a mdb with numerous macros - Looking for suggestions on the best way to document these macros in my new specs document - which is mainly in a table format. Access documentor does not easily translate the text into table. Is there any tools or code that will allow me to format the...

I currently have a 1/2 doz spreadsheets - containing 1 to multiple pivot tables included. The Problem is that their current datasource is an ODBC link to MS Access Database. I was wonder if I was to change the datasource to OLAP CUBE, what problems could I expect. I do not want to modify the...

I currently have a database that has multiple spreadsheets linked to the mdb. How do I handle the issue of Multiple users at the same time or if a users forgets to close a linked xls and prevents the admin from running the nightly updates? There is no particular security besides the network...