Search results

Ok, I found a workaround. I learned that starting in Access 2007 there are three hidden relationships that manage the objects pane (tables, queries, forms, etc.). The names of all begin with "MSys". So I excluded them from my routine and now everything works fine - I'm only deleting...

This is part of a routine I made to reset the database. First I delete all the relationships, then I replace the tables and then restore the relations. Most of all I'd like to understand what has changed - this used to work just fine. BTW, I have administrator privileges, and I tried opening...

Old code, new problem? The following code worked just fine - built using Access 2002 under XP. Now with Vista (I don't know if this might be the problem) and newer Windows OSs, the code fails at the db.Relations.Delete db.Relations(iRel).Name line with a Runtime 3033 error that says I don't...

I use Ghostscript/Bullzip to merge multiple reports (up to 43) into a single pdf output file. The basis of my code is the Access example on the bioPDF website. I've modified it a bit. (Since I set this up a few/couple of years ago, they have added the option to "AppendIfExists", eliminating...

Thanks so much for replying, jzqp22. I apologize for my delayed response. I essentially followed your advice in terms of the table design and it works very nicely. Thank you so much.

I'll continue trying.

Hi Bob, thanks for jumping in, here. The people testing my file are getting some kind of error (I can't wring the details from them) the first time they try to sort a column, but thereafter it works. Killing the sort process seems like the easiest thing. There aren't likely to ever be very...

Is there a way to prevent the user from clicking on the column headings and attempting to resort in a subform displayed in datasheet view? I can't disable the subform because the users can double-click on it to open a form based on the record selected in the subform.

I wanted to give back to the forum and check out my latest insight. I’ve searched around (and worked out my recent understanding) on the forum but I haven’t found a single thread that laid it out so I could fully grok the issue/solution. So I’m hoping to produce a searchable thread to help...

Okay, will reformat the code for the Else|Cancel=True part for sure. Did you see a problem with the Select Case structure? I need a different DELETE statement for 6 different tables.

Thank you Thank you Thank you Thank you so very much for your generous responses. Between them and further searching on the form, I came up with the following: Private Sub Form_Delete(Cancel As Integer) If MsgBox ("Do you want to delete...) = vbYes Then With CurrentDb...

I have a problem I'm failing to figure out and I wonder if anyone cares to help me sort it out. I'm trying to delete records from a subform in datasheet view. It works fine when I press the DEL key - the selected record (with a FK) is deleted after I respond affirmatively to the MSGBOX...

I'm not sure how to articulate my question effectively, so I'm having trouble searching the forum. I may be just flaking on a really easy thing - I hope it's easy, anyway. I need some help: I'm making an application to help school counselors track their meetings with students. They can be in...

Thank you, RG. I've seen the DoEvents thing in people's code before, but I didn't really understand what I read in the Help file. Can you refer me somewhere that explains it? The Escape key thing is a good idea too. I'm going to start searching for a way to code that - I don't know how at...

Hi Everybody, Darbid, RG, and Dave (gemma-the-husky), thank you so much for your help. Darbid's link provided the EnumWindows code that let me identify BullZip's class, which I could then add to the code in RG's link for IsAppRunning. Here's that piece: Case "bullzip"...

So, my latest thought is to try to use the Windows Task Manager to see if Bullzip is still running before moving on to the next report. I've worked out part of the Tasklist command as follows: but I'm not sure how to implement it. I think this line causes a printout of Task Manager members...

No help so far in finding a way in Bullzip to determine whether a merge process has completed. Is there a way to simply determine whether a file is "open" or "in use" on the computer?

Thanks Dave. that's a good idea. I'll look into how Bullzip does it. I think PDF_Creator does it that way, or can, but I don't know about Bullzip. There used to be problems with PDF_Creator in Vista. I've posted on the Bullzip forum to see if there's a way to know when the merge process has...

Thanks RG. The "API for Sleeping" seems to work great in practice, when testing the code given. When I try to use sSleep, though, I still get the white screen. I think it's related to "opening" the report as a part of the printing process and i don't know how to identify it (trap it?) to use...

I'm using the Sleep command to buy time between printing events while BullZip merges the current report with the previous ones (I need to bunch up to 43 separately created report pages into one pdf file). As the merge file grows, Bullzip takes longer to add the new page to the old ones in the...