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 was able to get the List of Macro- main name however, there is no way to obtain the sub-Macro Name. And yes I normally do not use macros only Modules. Unfortunately, I inheredited the database and I am converting it into a Sql backend system. thanks for all your input and normally your tool...

thanks for the suggestion, however, is there a way to modify the table to include the sub macro name. I mean I have several macros that are included into a single macro, is there a way to display those names? Karen

thanks that works fantasiclly. You think MS would incorporate this within ACCESS. thanks. Karen

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...