Results 1 to 5 of 5

Thread: Access VBScript

  1. Feb 28th, 2002, 05:29 AM #1
    ezz3x
    ezz3x is offline

    Thread Starter
    New Member
    Join Date
    Feb 2002
    Location
    Essex, UK
    Posts
    5

    Talking Access VBScript

    How do I make a text box list the number of the last record. Umm like if I had 100 records the text box would say 100 and then if I deleted a couple it would say 98.

    Thanx for at least looking at my question.

    Ezz3x
    Unable to find reality.sys Universe haulted. oh and who is General Failure and why is he reading my disk?
    Reply With Quote Reply With Quote
  2. Feb 28th, 2002, 05:46 AM #2
    Richyrich
    Richyrich is offline
    Addicted Member
    Join Date
    May 2000
    Location
    London Occupation: Desktop Developer
    Posts
    141
    use =DCount("<field>","<source>"), you might need to requery the text box after your deletion.
    Reply With Quote Reply With Quote
  3. Feb 28th, 2002, 05:52 AM #3
    darre1
    darre1 is offline
    Bouncy Member darre1's Avatar
    Join Date
    May 2001
    Location
    Peterborough, UK
    Posts
    3,828
    VB Code:
    1. TextBox.Text = RecordSet.RecordCount
    Confucious say, "Man standing naked in biscuit barrel not necessarily ****ing crackers."

    Don't forget to format your code in your posts
    Reply With Quote Reply With Quote
  4. Feb 28th, 2002, 06:20 AM #4
    ezz3x
    ezz3x is offline

    Thread Starter
    New Member
    Join Date
    Feb 2002
    Location
    Essex, UK
    Posts
    5
    Thank you Darre1!!!!!
    Unable to find reality.sys Universe haulted. oh and who is General Failure and why is he reading my disk?
    Reply With Quote Reply With Quote
  6. Feb 28th, 2002, 07:55 AM #5
    darre1
    darre1 is offline
    Bouncy Member darre1's Avatar
    Join Date
    May 2001
    Location
    Peterborough, UK
    Posts
    3,828
    welcome
    Confucious say, "Man standing naked in biscuit barrel not necessarily ****ing crackers."

    Don't forget to format your code in your posts
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width