Project management based on the Web - Online Solutions

Software

Organizations of all scopes and varieties need ways to improve productivity and manage workflows. It is an aspect of the management of employees and helping to maintain a project on the task and schedule. Web project management systems are designed to provide easy access screens of in a window of the browser from the obligation to download specialized software. This provides convenient ways for the...Read More

Posted: 09 Apr 2012

Tags: Project management based on the Web Online Solutions Project management based the Web Online Solutions

Unable to field table links values based on NULL values

Office

Question:I need some help creating a DLookup() statement or elookupAt the present time I haveDLookUp ("maxofdtapproR", "qry_dtapproR_Max", "(([PlanifIngId]_="_&_[tbl_Planification_Ingenierie].)) ") [[] PlanifIngId] & ") and ([NoEmission] ="& [qry_dtApproP_Max_ApproGestion].")" [[] NoEmission] & "))")The problem I have is that [NoEmission], which is a number, is not always a value. This...Read More

Posted: 30 Mar 2012

Tags: Unable to field table links values based on NULL values Unable field table links values based NULL

conditional formatting based on the difference in value of two cells

Office

Question:I use Excel 2007.Try to use the conditional formatting so that, if the difference in the value in cell B7 and C7 is greater than 100 to change the colors of these two cells in red.Is it possible?= "If (abs (b7 - b8) > 100)" is the format that I have, but it is not workingAnswer:... If the difference of the value in cell B7 and C7 is greater than 100 to change the colors of these two cells...Read More

Posted: 13 Mar 2012

Tags: conditional formatting based on the difference in value of two cells conditional formatting based the difference value two cells

How to state a form visible/invisible control based on the contents of a cell

Office

Question:I need a SpinControl is visible when the user has entered data in a cell adjacent, but invisible, if the cell is empty (null or space).I need to work in Excel 2000 and upwards.I think it must be a macro (that I know / understand and only used "record macro" (which is great)).Can someone guide me to an example please - I have lots of research, found many issues, but have not found a response...Read More

Posted: 10 Mar 2012

Tags: How to state a form visibleinvisible control based on the contents of a cell How state form visibleinvisible control based the contents cell

duplicate record (with the new current date and new auto # (PK) based off the coast of an existing when recording press the command button)

Office

Question:I have a form for a quotation system - there is no history - now back us to an old (ex last year) existing quote and edit it - possibly keep all the same - but can change the price - therefore currently the old citation # remains the same and the DATE remains the same - and no story on what the quote was returning to the origin. We would like to navigate to the old existing Record - and then...Read More

Posted: 29 Feb 2012

Tags: duplicate record with the new current date and new auto PK based off the coast of an existing when recording press the command button duplicate record with the new current date and auto based off coast existing when recording press command button