Jump to content
Sign in to follow this  
johnynardi

Count The Rows in access DB

Recommended Posts

johnynardi

Hallo guys iam trying to build a script the give you msgbox every time that row add to my access DB.

any idea how can i do it?

Share this post


Link to post
Share on other sites
hannes08

There's an _sql UDF in the Example section of the forum. I think it is capable of accessing Access DBs.

You can use simple SQL statements to count the lines.


Regards,Hannes[spoiler]If you can't convince them, confuse them![/spoiler]

Share this post


Link to post
Share on other sites
johnynardi

well this is what i did

i did a count statement and i got to line...

but how can i get an msgbox if anther line was added..

heres the code... of what i did

While 1
   
    $msg = GUIGetMsg()
    If $msg = $GUI_EVENT_CLOSE Then ExitLoop

  if $msg = $send Then
   sendMsg()
   EndIf
 
DataRow()
WEnd
Func DataRow()
$query1= "SELECT Count(Dt_user.Msg) AS [Count] FROM Dt_user;"
$Size = $adoCon.Execute($query1)
$Rows_Temp = $Size.Fields( "Count" ).Value
EndFunc

Share this post


Link to post
Share on other sites
johnynardi

Hallo guys iam trying to build a script the give you msgbox every time that row add to my access DB.

well this is what i did

i did a count statement and i got to line...

but how can i get an msgbox if anther line was added..

any idea how can i do it?

heres the code... of what i did

While 1
  
    $msg = GUIGetMsg()
    If $msg = $GUI_EVENT_CLOSE Then ExitLoop

  if $msg = $send Then
   sendMsg()
   EndIf

DataRow()
WEnd
Func DataRow()
$query1= "SELECT Count(Dt_user.Msg) AS [Count] FROM Dt_user;"
$Size = $adoCon.Execute($query1)
$Rows_Temp = $Size.Fields( "Count" ).Value
EndFunc

Share this post


Link to post
Share on other sites
Melba23

johnynardi,

How about you stick to just the one topic at a time. :)

And post it in the correct place - "Examples" is for exactly that, not help requests. ;)

I have merged the 2 topics this time - please do not make me do it again. :)

M23


Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind._______My UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

Share this post


Link to post
Share on other sites
hannes08

try something like this:

Global $rows, $new_rows
$rows = DataRows()
While 1
    $msg = GUIGetMsg()
    If $msg = $GUI_EVENT_CLOSE Then ExitLoop
    If $msg = $send Then
      sendMsg()
    EndIf
    $new_rows = DataRows()
    If $new_rows > $rows Then
        $rows = $new_rows
        ;Your Message Box goes here!
    EndIf
WEnd

Func DataRows()
    $query1= "SELECT Count(Dt_user.Msg) AS [Count] FROM Dt_user;"
    $Size = $adoCon.Execute($query1)
    Return $Size.Fields( "Count" ).Value
EndFunc

Regards,Hannes[spoiler]If you can't convince them, confuse them![/spoiler]

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×