Recent content by anujkmehrotra

  1. A

    Progress Bar not accurate

    I finally got what I expected. Many thanks to you to advice me. OpenProgressBar 100, "Completed" NOS = dbs.TableDefs.count TOS = 1 For Each tdf In dbs.TableDefs sSleep 100 SetProgressBar TOS / NOS * 100 TOS = TOS + 1 If tdf.Connect <> "" Then tdf.Connect = ";DATABASE=" &...
  2. A

    Validation through calender control

    Removed Validation rule Between #01-Apr-12# And #31-Mar-13# and used as Private Sub Challan_date_BeforeUpdate(Cancel As Integer) If (Me.Challan_date.Value < [StartDate]) Or (Me.Challan_date.Value > [EndDate]) Then MsgBox ("Challan date is greater or less than your Fiscal year.")...
  3. A

    Progress Bar not accurate

    As per your advised I changed my code like this. This time it works better but after 100% complete, some process is still on going for few seconds (5-10). Why so?? OpenProgressBar 100, "Completed" NOS = dbs.TableDefs.count For n = 1 To 100 For Each tdf In dbs.TableDefs If tdf.Connect <>...
  4. A

    Progress Bar not accurate

    Please guide me because MDSN says : I agree with you that when there are relatively few steps, that the progress bar advances in discrete steps and not smooth. That is because you have to synchronize the progress bar with the progress of your process, that is the loop with the connection of...
  5. A

    Progress Bar not accurate

    I didn't understand your point earlier. Please check
  6. A

    Progress Bar not accurate

    did I wrong again.
  7. A

    Progress Bar not accurate

    Hi, I'm making a code to run a Progress Bar from different forms and as per their conditions. Have two forms: 1- Form1="frmProgressMeter" 2- Form2="frmDatabaseStwitcher" 3- Module1=for Functions On frmDatabaseStwitcher, the code for Progress Bar is: ----------- Option Compare Database...
  8. A

    Progress Bar not accurate

    Can you suggest any solution of my problem. Asking for help....
  9. A

    Progress Bar not accurate

    No error message coming, but progress completes 100% first and then database connecting. They should work along with. It should be like 100% complete means work done.
  10. A

    Progress Bar not accurate

    Hi, I'm making a code to run a Progress Bar from different forms and as per their conditions. Have two forms: 1- Form1="frmProgressMeter" 2- Form2="frmDatabaseStwitcher" 3- Module1=for Functions On frmDatabaseStwitcher, the code for Progress Bar is: ----------- Option Compare Database Option...
  11. A

    Using Access 2013 to make changes to DB in Access 2003

    I recently upgraded my 10 years old project [mdb] into new [accdb] few days back and found no problem with that. But update A2k3 32bit to A2013 32bit. A few little changes in references and settings only. Hope for the best.
  12. A

    Validation through calender control

    Hi, I've a little concern about Validation rule on date/time field on form: I'm using Validation rule " Between #01-Apr-12# And #31-Mar-13# " on Challan_date field and it's working fine while entering manual entry but when someone uses calender control, it doesn't work at all. It accepts any...
  13. A

    Blank heading & Rows

    I forgot to mention that this problem is coming only in Access 2003. It works fine in Access 2007.
  14. A

    Blank heading & Rows

    Hi all, I'm facing a problem in some of tables & Queries that when i open/run them all rows are blank even having lot of data (records) and table/query heading is also blank. But some tables/queries are working fine. I'm unable to see my data of those records in problem tables/queries...
  15. A

    Open form from a combo

    Hi vbaInet, I'm trying to upgrade my old project into the most secured and error less concept. So, I want user to work more easily and secured like any other applications (VB, Oracle & JAVA) where user has full control over entry, view and report as well as less chances of mistakes. But in...
See more
Back
Top Bottom