Recent content by qmacg

On Ubuntu Linux, I'm having a hard time configuring Apache2 with Tomcat6. Does anyone have a working version of Apache2, Tomcat6 and Mod_jk? Perhaps someone could provide some samples of their working server.xml, workers.properties and /etc/apache2/apache2.conf files. When I bring up...

Thanks Major P!! I put the first procedure's code on my exit button of the main menu and as you instructed put the other code in the form Unload of the Main Menu. Comical how I kept trying to go into other menus and clicked on the Access Close button, but it would not close the App until I...

Is it possible to disable the control box of the Access Application Window? I would like to force users to press the Exit button on the Main Menu to Exit the Database instead of closing out Access altogether. I have some code running when the Main Menu is closing, but it gets bypassed when...

I wanted to avoid Outlook's automation, but I guess I have to at this point. Thanks.

Hello, it's probably something simple, but I can't figure out why the MS Access SendObject does not allow me to move around in Access until I either send the new email or close out the new email window. I prefer to use the SendObject method instead of using the Outlook code in VBA because the...

Hello, it's probably something simple, but I can't figure out why the MS Access SendObject does not allow me to move around in Access until I either send the new email or close out the new email window. I prefer to use the SendObject method instead of using the Outlook code in VBA because the...

Hey guys, i'll respond to both of your posts in this one. First "TheAceMan1", how's it going buddy. Here's the reason behind all of this. The purpose in my code was to capture the record that has been edited/added within the active row of the subform. I did not want to capture all of the...

Thanks, but looks like I've figured out something better. It gathers the data from a single record the way I need it. No need for the recordset object, Tag .etc Again this is triggered from the Subform's Before_Update Event. The key to what I was looking for to make this read the subform's...

So have you tested calling this from a Subform's Before_Update Event? Does it work for you?

Sigh... Ok, don't take offense to this, but this is just a piece of code I copied in here. I'm not worried about making it perfect and i'm not trying to compete with you in any way. But here's what i'm trying to do... Iterate through the current form that has focus (the subform which is in...

Hello: Any help on some ideas would be greatly appreciated :-) I'm trying to reuse some code that I use on a form in regular "Form View", but have it read the current active Subform which is in Datasheet view. I tried inserting in the code below "Screen.ActiveDatasheet", but looks to...

I just wanted to dynamically create a form through VBA code. When I use the code below it dynamically creates a form for me, but I want it to appear in design view, not form view. DoCmd.SelectObject acTable, strTable, True DoCmd.RunCommand acCmdNewObjectAutoForm

I Need to create an Unbound form or figure out how to open a form in design view using the command acCmdNewObjectAutoForm. When the form is displayed with the following code, it immediately opens it up in edit view...: DoCmd.SelectObject acTable, strTable, True DoCmd.RunCommand...

Ok, i'm really, really reaching here, but I'm sure someone has pulled it off somewhere. Here goes... I want, well really have to export a table in a .csv format instead of .xls for excel. Reason for this (to make a long story short), I'm exporting a bunch of memo fields, since memos can hold...

I was using the regular docmd.TransferSpreadsheet command to export the Excel file. But it looks like when I did the docmd.TransferText for the .csv you mentioned above, I was getting the word to appear on the next line of the field( when I opened the file.csv in Excel), but had a square...