Search results

I once had to create a Call Stack to debug/optimize a form - I basically created a small logging procedure (DoLog) in a module that would insert a record into a logging table - one Small procedure (FormLoger) in each Form being logged that had the Form's Name as a constant (this would call...

Where is this tread going? I most definitely have interest. I have 1 prettly large access application ive been working over the past 10 years an ERP system to manage my Home Improvement business and am always looking for reusable code. Big believer in creating repeatable processes and this...

Turned out one of my setting of a subforms LinkMasterField was screwed up and cuased improper initialization. Thanks guys for your efforts Fran

Thanks again for your effots. Dim as Access.Form did not help. I did however drop the offending sub on another test form and copied and pasted the plumbing and it worked as expected. This tells me there must be something happening when its contained in my big main form. Some naming overlap...

Maj thanks for your respone - im not sure what you mean by[Event Procedure] am i missing some key syntax? By the way - those calks to the msgbox was just for testing - the real to implement the work was coming once i knew the plumbing was working.

OK Here's the Code: Top Form (Main) - Object Declarations and Instantiation '----------------------------------------------------------------------------------- ' Upper Right Section Properties and Objects...

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

Can you use temp tables? I ran a quick test against a mssql express 12 db and this worked The first table [TestDates] represents yours existing table Insert some test data - including a record with your 9999s The next table [#mytab] is a temp work table with a new smalldatetime column Then...

Hi Arron My approach would be to create a tabbed form for the Receiving document with the first tab being the Receiving Header and the second tab containing a subform datasheet for the Receiving Detail. I would keep the detail tab hidden until the header was saved and some event trigger the...

I don't have any sample code but I do have pointers. I have found when ever I embarked on writing process code its best to map out the process in a flowchart/decision tree diagram before writing a stitch of code. You start with inputs and outputs add decision points and branches of logic. At...

Yes it was done in code. Basically the P.o. receiver process code would read in the receiver then perform the necessary updates to the p.o. line items and header. This would include logic to interrogate all the detail lines as to status - if all were fully received the p.o. header was then...

try this Private Sub Chiusura_Pratica_Click() dim Response as VbMsgBoxResult Response = MsgBox "Bla Bla Bla ", vbYesNo If Response = vbYes Then Me.Stato.Value = "A Scadere" Me.Assegnato_a.Value = "" Else MyString = "No" End If End Sub

Glad to hear you got a resolution.

In a commercial PO system I once worked on it had a similar structure to the one you are proposing. There was a Receiving Header and Receiving Detail table used to record the shipping document that accompanied any incoming deliveries. This document was entered by the receiving dept and then...

I was able to recreate your issue - but only if I had the listbox set to MultiSelect - Simple If I changed the MultiSelect to Extended it did not display this strange behavior. Based on what I tested it looks like ItemsSelected is not being properly maintained when multiselect is set to...

I'm a little lost trying to understand what the current issue you are having. I would think that all inspections have some common data elements such as: SiteID InspectionType ScheduledInspectionDate ActualInspectionDate InspectionStatus ..... I would try to have have one master Inspection...

You could create a "Global Event Handler" class to do what you want. I have not tried creating one of them so I can not guide you; however if you Google it you will find examples. I think there may be examples on this site as well. Glad to hear you got your problem solved.

Your Code Private Sub CheckBoxA_AfterUpdate() Dim itm As Control If itm.ControlType = 106 Then CheckBoxFormat itm End Sub Try this - you were missing the initialization of the variable itm Private Sub CheckBoxA_AfterUpdate() Dim itm As Control set itm = CheckBoxA If itm.ControlType =...

CJ One other thought for you, if you find you must update a node on the tree in memory, you might want to look at storing the values in a XML DOM instead of a memory array. Since xml represents a tree I think finding a particular node in the dom is faster than looping through an entire array...

CJ I can't really speak to compiled queries vs uncompiled since I don't use queries in my system for processing - all processing is done in stored procs on the server. I can say that in my experience updates tend to be the more expensive than inserts. So if you are completely rebuilding a...