Search results

ok, those properties were the main thing I needed. I have a module already that handles saving and retrieving values to a text file, which I prefer over a table for anything that isn't a global setting.

sounds to me like you want to run access is runtime mode. You'll have to create a shortcut on the user's desktop that looks something like this: "C:\Program Files\Microsoft Office\Office12\MSAccess.exe" /Runtime "C:\Database Folder\Access Frontend.mdb"

We are using Access 2007 and Access 2010. Our users like to change the background color and foreground color on their datasheet view subforms. I tried to maintain their settings by saving the backcolor and forecolor for each control to my text-based settings file. However, this doesn't work...

Sorry, Khalid, I already knew that. I just wanted to know what code to use to call the function/sub. I tried the following and none of them worked. Note that the name of the sub I'm trying to call is "subRefresh": Call Forms!frmMainFormName!fsubSubFormName.subRefresh Call...

I need to call a subprogram on a subform. I'm not going to be calling this sub from the main form. I need to call it from an outside form. How can I do this?

Could you elaborate a little bit on what you mean? I thought the tag property is something you use on a textbox on form. I do have filters that are far more efficient but users like to try the Any Field filter first since it works for almost anything and is quite accurate. Of course, the...

OK, so I'm editing this post because it was incorrect. I thought ampersands where causing my problem but that wasn't true. It appears that what is causing Access to freeze is long filters with lots of fields. I'm allowing my users to perform an "any field" search which means I parse out their...

*Solved* .jpg Files Stopped Loading in Image Control (Access 2007) *Solved:* This problem was caused by the fact that Office 2010 left behind it's graphics filtering files in the following folder: C:\program files\common files\Microsoft Shared\GRPHFLT I copied all of the following files from...

Yes it makes sense but I prefer to do it using a Winsock control since there are a lot of possibilities of what I can program into this thing. Also, there is not network traffic except for when I initiate the traffic.

I use this information to determine if and when I can close the database during working hours to make changes/updates to it.

I'm trying to program a short function in a stand-alone code module that will iterate through all forms and their subforms and return a human-readable string that tells me which forms are Dirty or in NewRecord state. So far I'm not having success, especially on the subforms. Can someone help...

I installed that Audit Trail thing and modified it a tiny bit. Looks like it's going to work for what I want it for. Thanks a lot.

I know you can setup your outlook contacts to be a table in Access but that's not what I'm looking to do. I'd like to have code that, when triggered, updates a given contact's details in Outlook using the information stored in an Access table. I don't need to pull any information from Outlook...

This is more of a theoretical question since it will generally be impractical to implement. Let's say I have a form that's bound directly to a table and the table has about 25 fields. Now I'd like to detect when the user makes a change to a record and simply log the change. For example, if they...

With enough blood, sweat, and tears, and also with the generous help of Dmitry Streblechenko from dimastr.com, I was able to get a subprogram that does what I want it to. I'm going to post it here for the benefit of others. This subprogram uses Outlook Redemption Objects (RDO) and late binding...

I found this code to embed one email in an outlook email using VB or VBA. http://www.outlookcode.com/d/code/htmlimg.htm I also found this discussion but it didn't help me out very much since I could find the complete code anywhere as a final solution...

Your idea is a working solution. Thanks

Also, I disagree with the statement that a "form cannot overlap the Navigation Pane". It might be desirable for it not to overlap but I'm using access 2007 and it's technically possible for it to overlap. It just puts the WindowLeft property into a negative zone.

I want to detect if the form is off the screen on the right hand side. More specifically, I want to detect if the settings that were saved for the position of that form will push it outside of the viewable area.

I've figured out how to reposition an Access form but I have a new problem. I have one form I'm using mostly for testing right now. When the user closes it, I'm saving the width, height, top, and left, so I can position it at the same place the next time they open the form. However, if the...