Search results

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...

BTW - FrmTemplate has the work around frmTemplate_Old is where its broken

Thanks for the willingness to take a look. I extracted the forms and modules and put them in their own db I you have any questions let me know - this is all about creating a template to be used as the starting point for other form development.

I found a work-around thats not pretty but works. The Form_Current event does fire and i now am re-initializing my toolbar an every Form_Current firing. I wanted to only do this step once - on Form_Load, and the Update the button states on Form_Current only if the data within the current record...

Ok heres the logic - may not make sense but it does for me. Writing reports are a big PITA, and with over a couple hundred tables and writing a report for every table/form would take me forever. So... I wanted to include a Print button on most every form through this tool bar that envoked some...

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...

Here is an update to above Attachment - Found some areas of I had not updated - specifically the 2nd TreeForm which loads customers and orders. Made the ports and cleaned up the query module.

Here is the ADODB version There is one Folder that contains three Files in the Zip 1. TreeviewDemo.adp: MS 2007 ADP or AccessProject: 2. TreeviewDemo.bak: MSSQL 2012 Database backup File 3. qryToViews.sql: SQL file of the statements I used to convert the Access queries to Views Not sure if I...

Will do Turns out I ported an earlier version that was much simpler - Before all the customer/orders data was in the db. Im porting this current version now and will post when ready.

I work with a Sql back-end. The one unbound form i can think of which would be very helpful, Is a "Generic search for Code". This would used to replace a drop down combo when searching for a primary key value in another table when that table has many rows and potentially multiple fields you...

I got it working. It was really just the security warnings. I did however port the table over to Mssql and updated dao to adodb and modified the findfirst & nomatch to the appropriate adodb calls. Works great.

Awesome job on this treeview. I've been needing to add this functionality to my db and while I've played with trees in Vb6 some 15 years ago, I couldn't find any of the old code. This example will save me many hours of relearning as well as give me functionality i never had. Thank you Fran...

Any chance you can upload or send me a version of this for A2007?

Tried to upload the .bas file and it seems the site didn't want to take it. The tried copying and pasting the entire module and site complained saying it was too long. The tried cutting and pasting sections of it and got fustrated. So... I went and got winzip. There was probably a simple...

Sounds Right - I know I did download a bunch of stuff from that site. Excellent stuff

Allrighty then, ill download this and check it out Looks like I'm doing some of the same stuff with the initialize and terminate as well as the _Enum Good stuff. Have you played at all with the "Implements" and "Interface" Found it to be a bit of a brain tease and buggy, but i think that was...

OK This is getting tedious - I downloaded winzip - cnat believe it wasnt on my macine

And More... Sub CreateProcedure() On Error GoTo SubError Dim s As String Dim LineNum As Long ' Use the next two lines to create a new module for the code 'Set VBComp = ThisWorkbook.VBProject.VBComponents.Add(vbext_ct_StdModule) 'VBComp.Name =...

and more Function CopyModule(ModuleName As String, _ FromVBProject As VBIDE.VBProject, _ ToVBProject As VBIDE.VBProject, _ OverwriteExisting As Boolean) As Boolean ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' ' CopyModule ' This function...

Her is some more Public Function Initialize() Set VBAEditor = Application.VBE Set VBProj = VBAEditor.ActiveVBProject End Function Public Function KillObjects() Set VBProj = Nothing Set VBAEditor = Nothing End Function Function IsEditorInSync() As Boolean...