Search results

I have an Access 2007 ADP project that is giving me "The Save operation failed" error message upon attempting to save the DB after compiling. I have tried creating a new database and importing all objects but still getting the message. The database runs fine, I can make changes to the forms...

I am having a problem with on of my forms where the SubForms are continuing to fire off the OnCurrent Event long after the form has loaded. Main form has a Tab Control which contains a subform (datasheet) on each tab. Each subform has a Public Event defined (CurrentID) which is raised from the...

Hi Guys It's been awhile since I've posted here, but thank you for all the previous help. My system has come a long way. To the point. Now I would like to add some Access - Word integration to my system to generate contracts which will contain some info from the database. Customer Name and...

Looking to find examples of a Data Structure to Support a decision tree. Cant seem to find any practical examples. Here is an explanation of the business need. I've been working on creating an Estimating or Quoting module within my access application i use to manage my Home Improvement...

In my db, ive created a feature I'll call Custom Properties. This feature is intended to allow additional User Defined information to be captured about a particular entity and then the value(s) assigned to these properties to be used at decision points in processing logic. An individual...

I just had a rather fustrating experiece New code and controls added to a screen were not saved - upon completing some work compiling the code, closing and saving the screen. This happened twice in a row on the same screen so i was doubly careful to save after every small change. Still after...

Hoping to get some insight into the level of granularity i should implement in the Estimating/Quoting module I am building. As I posted before, I currently run a small Home Improvement company. We specialize in really just a few types of projects. Deck Construction during most of the year...

Over the past 10 years I've been building and adding to one MS Access 2007 Project creating basically an ERP system for managing my Home Improvement business. I'm reaching the point where it's getting difficult managing the application due to the sheer number of objects. The functional Areas...

Im working on building a template form that contains a SubForm which only contains 6 command buttons to act as a standard toolbar to handle standard db actions. New Save Delete DesignMode PrintPreview Close On initialization of the template form, i pass Me to a a Public Property defined as...

Having a vexing problem and was hoping for some insite as to where to look. I have a form divided into 6 quadrants, each quadrend is comprised of a sub form. Each subform contains a form that has 1 sub form. At each level i declare (WithEvents) and set object variable that reference the...

I have an Access 2007 Data Project (ADP) database using a Ms Sql 2012Express db server. I know this is not a supported platform and the project option goes away I think in Access 203. While I'm having no issues with this configuration I'm thinking I should switch to linked tables to come...

I was hoping someone could give me a practical example of a Nested SubForm. I use the SubForm control extensively in my application but always only 1 level down when I'm presenting a 1 to many relationship. Such as an Invoice or Sales Order. With the main form representing the "Header"...

I can't figure out how to set focus to a non Default instance of a form. Environment A2007 ADP Project Document Window Option - Tabbed Documents MS SQL 2012 Express DB Windows 7 64 Bit I using Allen Browne's method to open more that one version of form, storing each form object in a collection...

Hi all - my name is Fran and I just joined this group. I am currently a home improvement contractor but have over 20 years experience in system design, development and implementation. My only current use of access is a business management - ERP system I developed to manage my business. It is...