Search results

  1. M

    Automating mailmerge from Acces form to Word document

    I am having the strangest results with my automated mailmerge. Basically it does work, but not all the time. The basic idea is to allow the user to dynamically create a query that produces a result list which fills a temporary table. The use then selects a prebuilt merge template and merge...
  2. M

    Performing a Compact&Repair on both FE and BE

    I'm sure I'm just being blind here. I need to compact my BE data file, but the code fails because the initial file copy to backup the data file gives a permission denied. (The file is still in use). How does the front end release it's hold? I've seen several examples of compacting the...
  3. M

    How to set the default Ribbon for athe Current DB

    Every where I look for an answer to this question I find the loadCustomUI, but the UI is loaded already, I want to change what the default ribbon is set to on the next opening. (i.e. when I close the Db I want to set the default ribbon to either of two defined ribbons in the USysRibbons table...
  4. M

    Question Loading Ribbons

    I have a little app that I locked down very tight in Access 2007. However a test run with access 2010 shows there was a security hole. It has to do with Ribbons. In Access 2007 I turned off all the developer ribbons and allowed the compact and repair button on a customized ribbon when the...
  5. M

    Compiling into ACCDE causes all functioning to stop

    I have the strangest problem. I've been working on this app for a while now and every now and again MS access will cause a corruption that requires me to remove all the modules from the startup form save the form and them paste them back in. I usually do a Cntrl 'A' and then a Cntrl 'X' and...
  6. M

    Converting an Access elect query to a delete query.

    delete Temp_Updates_list_Table.* FROM (SELECT Temp_Updates_list_Table.* FROM Temp_Updates_list_Table WHERE Temp_Updates_list_Table.Actiontaken="MainRecord deleted") AS Tmp_B LEFT JOIN Temp_Updates_list_Table ON Tmp_B.Main_RecID=Temp_Updates_list_Table.Main_Recid WHERE...
  7. M

    Combining/merging two Recordsets into one

    I have two recordsets(rst) one created in the current DB by a local query and the other created from and external DB with a second query. Both recordsets contain very similar data. Now I would like to merge the two recordsets. I would like to do this with a third query rather than a VBA...
  8. M

    Programmatically changing the password on a .accdb or .accde Database

    Hi All, I have a little Access app DB that has an option to let the user assign a new password to the database. In the .mbd or .mde format the option worked fine. But when I switched to the .accdb format the change password option failed with the error message the the file was already...
Top Bottom