progressbar not incrementing

[indhu]

hi
I ve inserted a progressbar in my form its not gettting into loop. when my total_days incrementing the prgress bar should get increment. give me a coding yeah for this

[NeoPa]

Never used it myself but found this searching for Progress Meter in help.

SysCmd Method


You can use the SysCmd method to perform one of the following functions:

Display a progress meter or optional specified text in the status bar.


Return information about Microsoft Access and its associated files.


Return the state of a specified database object to indicate whether the object is open, is a new object, or has been changed but not saved.

For example, if you are building a custom wizard that creates a new form, you can use the SysCmd method to display a progress meter indicating the progress of your wizard as it constructs the form.

Syntax

ReturnValue = SysCmd(action[, text][, value])

ObjectState = SysCmd(action[, objecttype][, objectname])

The SysCmd method has the following arguments.

Argument Description
action One of the following intrinsic constants identifying the type of action to take.
The following set of constants applies to a progress meter. The SysCmd method returns a Null if these actions are successful. Otherwise, Microsoft Access generates a run-time error.
acSysCmdInitMeter Initializes the progress meter. You must specify the text and value arguments when you use this action.
acSysCmdUpdateMeter Updates the progress meter with the specified value. You must specify the text argument when you use this action.
acSysCmdRemoveMeter Removes the progress meter.
acSysCmdSetStatus Sets the status bar text to the text argument.
acSysCmdClearStatus Resets the status bar text.
The following set of constants provides information about Microsoft Access.
acSysCmdRuntime Returns True (–1) if a run-time version of Microsoft Access is running.
acSysCmdAccessVer Returns the version number of Microsoft Access.
acSysCmdIniFile Returns the name of the .ini file associated with Microsoft Access.
acSysCmdAccessDir Returns the name of the directory where Msaccess.exe is located.
acSysCmdProfile Returns the /profile setting specified by the user when starting Microsoft Access from the command line.
acSysCmdGetWorkgroupFile Returns the path to the workgroup file (System.mdw).
acSysCmdClearHelpTopic
The following constant provides information on the state of a database object.
acSysCmdGetObjectState Returns the state of the specified database object. You must specify the objecttype and objectname parts when you use this action value.
text A string expression identifying the text to be displayed left-aligned in the status bar. This argument is required when the action argument is acSysCmdInitMeter, acSysCmdUpdateMeter, or acSysCmdSetStatus; this argument isn't valid for other action argument values.
value A numeric expression that controls the display of the progress meter. This argument is required when the action argument is acSysCmdInitMeter; this argument isn't valid for other action argument values.
objecttype One of the following intrinsic constants:
acTable
acQuery
acForm
acReport
acMacro
acModule
acDataAccessPage
acDefault
acDiagram
acServerView
acStoreProcedure
This argument is required when the action argument is acSysCmdGetObjectState; this argument isn't valid for other action argument values.
objectname A string expression that is the valid name of a database object of the type specified by the objecttype argument. This argument is required when the action argument is acSysCmdGetObjectState; this argument isn't valid for other action argument values.