Search results

The Strategically placed DoEvents through out the code seemed to do the trick. What was odd is the Pause_Ops(XXXX) is a global sub that does just that; it loops performing DoEvents while waiting for XXXX milliseconds to pass and that was not enough. Anyway thanks for the suggestion. And if...

Here are all the inter-related pieces... The merge modual... Private Sub Merge_CMD_Click() On Error GoTo Err_Merge_CMD_Click ' need to browes to allow user to select Mailmerge template ' open document and start mailmerge from this Db If Not IsNull(Actv_User) Then If Len(Actv_User) > 0...

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

Thank you Bob. That was the kick in the pants I needed. So I abandoned my futile effor to get the FE to release the BE. I switched to your idea of an external agent, but with out submitting a batch file. I created a third "Compressor" accde which has a single table and a startup form...

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

That does the trick, but leaves me with questions. Why does the ribbon named "DoNotChange" become the 'Default' ribbon? and what about the application 'Default ribbon' would this override an entry manually updated in the Current Database options Screen?

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

It's always best to put in error trap in my global declarations modual I have a template routine that I can copy to any procedure. (use 'replace all' focused on current procedure and change Just_a_holding_place with the name of the procedure) Then you can add a case for error.number =...

Thanks! I've not dealt with the AutoExec before. I'm not sure how to initiate it. What is the main diff between AutoExec and a Startup form's events? So, I'm pretty close to what I want already, but I can always use some external input. The load UI function could be used at close to...

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

As I stated in my problem description... I have an App that syntactically works fine before it is compiled into a Accde file. Once compiled none of the forms modules work work. As a common practice I always do a Debug compile before making the .accde file, but even that was not catching...

Well I started this project with what I had and don't have the mullah to buy another full office suite. I am executing the ACCDE from the same directory, but I also have code that catches the Trusted location situation and with user OK adds the currentproject.path to a new Trusted location...

Re: Dompiling into ACCDE causes all functioning to stop Hey Thanks... I'm not using ADO and I do perform compact and repair b3fore I do a compile. Actually I have found the problem and I'll write it up in a full reply..

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

The error message given is "Quoated" in the post -- "Could not delete from Specified tables." I've already written a version using an alias for the second table name with the same results and a version with the first table aliased. I've encountered this before with a delete query containing a...

Thanks. I guess all I needed to hear is that I will have to use an intermediate table. I'll use Select INTO to create a table on the fly that I can subsequently run data massaging Queries against . Thanks..

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

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

Thanks for your concern about the over all design, but that's not what I'm asking about. This a a personal sized DB only one individual will use each edition. I feel a DB password is more secure that individual passwords. So I will re-iterate my original question does anyone know how to...

If it is the users Database they want to change and control their password. All tool bars are hidden there is no way for them to change it other than through coding.