Replies

Thanks to both of you for your help. I don’t have any boolean fields in the MySQL tables and I also don’t have a timestamp field. As I continued my searching I ran across the recommendation to be sure “Return matched rows instead of affected rows” in the COnnector/ODBC definition is selected. After I made this change and re-linked the tables the problem seems to be resolved. Although the advice on Timestamps may still be a good idea to avoid future problems.

Marty

Paul,

Thanks for the insight, could you share a vba code snip-it on how you do that?

Marty

John,

Thanks for the additional thoughts. The up side is it worked as you suggested. The downside is without reducing the height on the picture control when there is no picture every detail line is at least the height of the picture control even when the text requires less than the 2 inch setting. As an alternative workaround I’ve stacked the picture and text controls rather than having them side-by-side. Takes up more space than if side-by-side worked, but less than having every detail line having a minimum height of the picture control.

Thanks again for you assistance,
Marty

Got a chance to try it, unfortunately no change, still get the gap.

Marty

John,

I guess I’m either not understanding your point or I’ve not made my problem clear. I’m happy with the presentation of the image in the control even if there is blank space to the right or bottom of the image within the control. The control itself is the size I’d like it to be. My problem is there is significant extra space, outside the control, at the bottom of the detail line when the control has an image. I don’t understand where this comes from. With a border visible on the image control the space measures 1 5/8″ from the bottom of the image control of the detail line with an image to the top of the empty image control on the next detail line.

Thanks for help and patience.
Marty

John,

I’ve tested setting just the width and setting both width and height, no change. I have the Size Mode set to Zoom. I tried reducing the height to 1″, still get the gap but it’s only 1″. With a visible border on the control, the control always displays the size set by the code. Depending on the original shape of the picture I get space within the control either on the left or at the bottom.

Marty

John,

Thanks much. I think I got close a couple of times on the syntax, but never quite got there.

Mark,

One approach would be to create a .kml file of as many locations as required and then either open that from within Access or from Google Earth. One of the nice side benefits of the .kml is the ability to create grouping of addresses by what ever properties you wish. It’s easy for the user to have Google return turn-by-turn directions between any of the sites if that’s required.

Marty

Boyd,

Ah there’s the rub. I’m currently trying to figure out how to go about accomplishing either of these to projects. My initial thought has been to do the work from within Access, but as mentioned before having trouble tracking down some examples. If I can solve the challenge of creating the notebooks, I’ll then look at extracting information from them.

Marty

Boyd,[/SIZE][/FONT]
[/SIZE][/FONT]
Happy too, andthanks for your interest.[/SIZE][/FONT]
[/SIZE][/FONT]
First somebackground, my client performs reserve studies for entities such as condoassociations, planned developments and park districts among others. Basically areserve study provides an inventory-list of all things the entity isresponsible for maintaining, an assessment of the remaining useful life, a 30year expense forecast and a funding plan to meet the projected expenses. The first step in performing the reserveanalysis is to go on-site, identify, assess and record all the “stuff” the entity maintains. Thisinventory stuff categorized into a standard major component and standardsub-component. Over the years the total list of sub-components has grown to abouta 1000 items. [/SIZE][/FONT]
[/SIZE][/FONT]
A challenge thefield inspectors have is to be knowledgeable about every component they recordin the study so they can adequately discuss maintenance issues, assess eachcomponent’s useful and remaining life, and determine what the currentreplacement cost is likely to be. Eachfield inspector has complied their own personal set of notes on all thecomponents they have come across. They would like a way to easily share thisinformation among themselves.[/SIZE][/FONT]
[/SIZE][/FONT]
Our first use ofOneNote is to create a set of notebooks, one for each major component and eachnotebook would have a section for each related sub-component. Each page wouldbe created by the field inspectors and populated with information from theirpersonal notes. They are currentlyfinalizing a OneNote template for the entry of their information.[/SIZE][/FONT]
[/SIZE][/FONT]
I thought, given thesize of the major/sub-component list, it would be a good idea to create thenotebook skeletons programmatically. SoI need to be able to create a OneNote section programmatically.[/SIZE][/FONT]
[/SIZE][/FONT]
The second idea wehave is to create a OneNote notebook from the most recent client study rightbefore a field inspector goes out to an inspection. In this case the notebookstructure would have each section correspond to a major component from thestudy and each page correspond to a sub-component. Various pieces of information from the studywould be added to each page. SinceOneNote can be run on mobile devices such as an iPhone and iPad, it would nowbe easy for the inspector to record his notes and pictures with eachsub-component. Often the inspectors arein the field for a week or two. So it becomesa significant issue to transcribe their notes and apply to the correct studycomponent when their memory is less than fresh … that’s of course assuming theycan read their notes which is frequently not the case. With everything in OneNote, the office staffcould have legible notes and pictures, tied to specific components without theinspector bringing them back to the office.[/SIZE][/FONT]
[/SIZE][/FONT]
My search on OneNoteObject Model seemed to keep coming back to codeplex.com as the most robust setof OneNote tools. However, their websitesuggests and editor such as Visual Studio C# Express as a good editor to usewith their code. Unfortunately I’m not aC# guy. Many of the remaining search results came back to an Excel VBA examplefor creating pages, but nothing on how to create a section in VBA.

Marty[/SIZE][/FONT]

Thanks for the reply. I should have included in my original post I wish to do this work fro within Access 2007/10 using vba.

John,

I believe that’s exactly what I’m trying to do. My AutoExec calls a function which tests the value/s passed through the Command function. I’ve a couple of shortcuts setup, one with and one without the command line text. The AutoExec works as desired. The problem comes when I try to open the FE with appAccess.OpenCurrentDatabse. If I don’t include my command line switch the code runs, but the AutoExec fires. When I include the command line switch I get the error I mentioned above.

This is an inherited application and a low priority for me. It needs considerable work to put it in shape to be distributable as a complied FE which will run on the various platforms. The onsite folks are accustomed to following their to compile it.

I need to modify the properties of several controls on a FE form. I’m attempting to put together a small Access db which when Run would execute the updates. I’m bumping into the need to provide different localized formatting for the distributed FE. Rather than trying to put the logic in the FE to determine where its at, I thought a custom “localization” db would be the simpler way to go. The local FE installation procedure would be modified to include a step to run the customization db.

In anticipation of being able to change to an AutoExec macro as you suggested, I’ve implemented that on a test FE. However, I’m having a problem dealing with the command line option. Here’s my code:

Dim appAccess As New Access.Application
appAccess.OpenCurrentDatabase _
filepath:=pdbPath & ” /cmd NoAutoStart”

If I don’t include the command line option, the FE fires the AutoExec. I’ve tested the command line manually and it works … AutoExec does not fire. However, the code as shown raises error 7866 – Microsoft Office Access can’t open the database because it is missing, or opened exclusively by another user, or it is not an ADP file.

Marty

Thanks John. Unfortunately I don’t have the opportunity to modify the FE’s to utilize the AutoExec approach.

I’m using Access 2007 and it’s not recognizing .EnableEvents. Is there a reference I need to include for this?:

Marty

Thanks for the comments, I’ll try to answer your questions.

I am running Win 7 with SP1 and I am not running Office 2007 in 64 bit mode.

I have read the Microsoft Run-time Wizard article, but have run into a couple of problems in trying to use it. Fortunately my first several installations are all local so the convenience of an install package is not a top priority at the moment. I do expect to get back to trying to figure how to make it work. Has anyone run across other documentation on the wizard?

I’ve installed debug traps at the top of main and sub-forms’ On Open, On Load and On Current events. I get the error message before any of the code fires when I open the form. So it seems on the surface I don’t have problem code in the more typical sense. I am not using automation in the main or sub forms. There is quite a bit of code behind the forms doing editing and using DAO recordsets. So with no particular code section to point to and 25-30 pages of code, it doesn’t seem me to be of much help to post the code.

I’ve had a chance to try the compatibility suggestion and the results were the same.