My employee Time monitoring program

Printable View

December 31st, 2005, 12:23 PM
VBprogrammer2006

My employee Time monitoring program

hello I need some help with a program I am trying to write it is a Server / Client application What I need it to do is as follows:

Structure:

Administration View:

-Admin Login
-User (employee) setup
-Task setup
-User / Task relating, allowing admin to relate particular tasks to spacific employees
-Reporting (period/user/task)definable time period - all users or single user -all tasks or single task (exportable to MS-Excel format)
-Keyboard and mouse monitoring maintenance to set amount of keyoard/ mouse inactivity time for break recording
-Need to be able for admin to retrieve updated data from spreadsheets every (admin specified time)
-Auto delete duplicate records
-ability to pull individual time records from database
ability to disable users from resizing application window
-ability to view records of employee activity
-ability to set as service in windows upon install (server)
-ability for admin to set up the application for use over the internet with one server end application located at head office and just the client end of the application installed on machines at the other locations
-ability to asign a product key to installation and the ability for (LGCC) to change it upon renewal date
-ability to auto save data every (time set by admin) minutes
-ability to activate program upon windows login (must tie into the user login API and the User list on the SQL server and network
-When exporting data from program to excel each entry must be specified by user name
Ability to copy to CD/DVD (Depending On Size) at the end of every month

Employee (User) View:

-Employee Login (must connect to the windows login screen)
-Task selection
-Time recording
ability to only install Employee (user) view restriction on the user systems but have it link back to server (Client)

The excel output app needs to be password protected (password set by admin)
Is it posible to set time limits on use of the program (ex: 365 days)
and then force to repurchase (date has to be able to be changed by LGCC)
The backbone of the app will be tied into the SQL server and MS - Excel
December 31st, 2005, 03:47 PM
GremlinSA

Re: My employee Time monitoring program

Quote:

Originally Posted by VBprogrammer2006

hello I need some help with a program I am trying to write it is a Server / Client application What I need it to do is as follows:

Structure:

Well almost everything listed is already posted or answered in CG.. I've linked to some of the more interesting ones..

Quote:

Administration View:

-Admin Login
-User (employee) setup - Use A DB Table
-Task setup- Use A DB Table
-User / Task relating, allowing admin to relate particular tasks to spacific employees
-Reporting (period/user/task)definable time period - all users or single user -all tasks or single task (exportable to MS-Excel format) - Multiple of Methods here.. easy way is to use A DB table to store the info and export to CSV format
-Keyboard and mouse monitoring maintenance to set amount of keyoard/ mouse inactivity time for break recording
-Need to be able for admin to retrieve updated data from spreadsheets every (admin specified time)
-Auto delete duplicate records
ability to disable users from resizing application window
-ability to view records of employee activity
-ability to set as service in windows upon install (server)
-ability to asign a product key to installation and the ability for (LGCC) to change it upon renewal date

Employee (User) View:

-Employee Login
-Task selection- Use A DB Table
-Time recording- - record "Date, Time & User" to a db Table
ability to only install Employee (user) view restriction on the user systems but have it link back to server (Client) - Use A DB Table

The excel output app needs to be password protected (password set by admin)- Use A DB Table
Is it posible to set time limits on use of the program (ex: 365 days)
and then force to repurchase (date has to be able to be changed by LGCC)
The backbone of the app will be tied into the SQL server and and MS - Excel

I hope this is enough to get you started...

When you start writing your app and get into problems.. post your code and we can help you debug it...

Gremmy....
December 31st, 2005, 11:44 PM
VBprogrammer2006

Re: My employee Time monitoring program

What is a db table? and how to I create one?

another question:

How would I be able to connect all of the seperate components of the application together
January 1st, 2006, 01:10 AM
VBprogrammer2006

Re: My employee Time monitoring program

Private Sub btnCancel_Click()

End

End Sub
Private Sub Form_Load()

btnLogin.Enabled = False
gintKeypresscount = 1
End Sub
Private Sub txtLoginID_GotFocus()

gintKeypresscount = 0

End Sub
Private Sub txtLoginID_KeyPress(KeyAscii As Integer)

If KeyAscii = 13 Then

KeyAscii = 0

gintKeypresscount = 1
SearchEmployee

End If

End Sub
Private Sub txtLoginID_LostFocus()

If gintKeypresscount = 0 And txtLoginID.Text <> "" Then
gintKeypresscount = 1
SearchEmployee
End If

End Sub
Private Sub txtPassword_GotFocus()

If txtLoginID.Text = "" Then
txtLoginID.SetFocus
End If

gintKeypresscount = 0

End Sub
Private Sub txtPassword_KeyPress(KeyAscii As Integer)

If KeyAscii = 13 Then
If gintKeypresscount = 0 And txtPassword.Text <> "" Then
KeyAscii = 0
gintKeypresscount = 1
SearchPassword
End If
End If

If txtPassword <> "" Then
btnLogin.Enabled = True
End If

End Sub
Sub SearchEmployee()

'establish connection to database
Dim dcnRefund As New ADODB.Connection
dcnRefund.CursorLocation = adUseClient
dcnRefund.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0; Data Source = D:\Alvin Tan\My Documents\Refund\Refund.mdb;"

'create recordset
Dim rstUsers As ADODB.Recordset
Set rstUsers = New ADODB.Recordset
rstUsers.CursorType = adOpenKeyset
rstUsers.LockType = adLockOptimistic
rstUsers.Open "tblRefundUsers", dcnRefund, adOpenStatic, adLockOptimistic

rstUsers.Index = "UserID"
rstUsers.Seek "=", txtLoginID.Text

If rstUsers.NoMatch Then
MsgBox "Sorry, User not found!", vbExclamation
gintKeypresscount = 0
txtLoginID.Text = ""
txtLoginID.SetFocus
Else
txtPassword.SetFocus
btnLogin.Enabled = True
End If

rstUsers.Close

dcnRefund.Close

End Sub
Sub SearchPassword()

'establish connection to database
Dim dcnRefund As New ADODB.Connection
dcnRefund.CursorLocation = adUseClient
dcnRefund.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0; Data Source = D:\Alvin Tan\My Documents\Refund\Refund.mdb;"

'create recordset
Dim rstUsers2 As ADODB.Recordset
Set rstUsers2 = New ADODB.Recordset
rstUsers2.CursorType = adOpenKeyset
rstUsers2.LockType = adLockOptimistic
rstUsers2.Open "tblRefundUsers", dcnRefund, adOpenStatic, adLockOptimistic

If txtLoginID.Text = "" Then
MsgBox "Please enter User Login ID", vbExclamation
gintKeypresscount = 0
txtLoginID.Text = ""
txtLoginID.SetFocus
Exit Sub
End If

rstUsers2.Index = "UserID"
rstUsers2.Seek "=", txtLoginID.Text

If txtPassword.Text = "" And gintKeypresscount = 1 Then
MsgBox "Please enter password", vbExclamation
gintKeypresscount = 0
txtPassword.SetFocus
Else
If rstUsers2("UserPwd") = txtPassword.Text Then
gintLoginID = UCase(txtLoginID.Text)
Unload Me
frmMainMenu.Show
Else
MsgBox "Wrong Password!", vbExclamation
gintKeypresscount = 0
txtPassword.SetFocus
txtPassword.Text = ""
End If
End If

rstUsers2.Close
dcnRefund.Close

End Sub
Private Form_Load()
Frm.Tool_Acc.Enabled = Acc(8) 'Set Menu rights to user..
Frm.Tool_Print.Enabled = Acc(9)
Frm.Tool_Staff.Enabled = Acc(6)
Frm.Tool_Supp.Enabled = Acc(7)
Frm.Tool_User.Enabled = Acc(10)
Frm.Main_Func.Enabled = Acc(3)
Frm.Main_Paym.Enabled = Acc(4)
Frm.Main_Shift.Enabled = Acc(2)
Frm.Main_With.Enabled = Acc(5)
End Sub

-----AND------
Private Sub Cmd1_Click()
If Acc(1) Then
.........
End If
End Sub

btnLogin.Enabled = False (comes back with a run time error 424 object required. Please help
January 1st, 2006, 05:09 AM
GremlinSA

Re: My employee Time monitoring program

Quote:

Originally Posted by VBprogrammer2006

What is a db table? and how to I create one?

This is a new table in the Database , Create it in Access, SQL, or the Database system your using..

Quote:

Originally Posted by VBprogrammer2006

How would I be able to connect all of the seperate components of the application together

Write your Server aplication as one EXE and your Clinet aplication as one EXE, with all the Different Components in forms and/or modules...

Quote:

Originally Posted by VBprogrammer2006

Code:

Private Sub Form_Load() btnLogin.Enabled = False gintKeypresscount = 1 End Sub

Are you sure that BtnLogin in on this form.. IF not you have to refrence it by (Form).Object.Property = Value. Double check the Name used...

Gremmy...
January 1st, 2006, 06:05 AM
JonnyPoet

Re: My employee Time monitoring program

Quote:

Originally Posted by VBprogrammer2006

Private Sub btnCancel_Click()

End

End Sub
Private Sub Form_Load()

btnLogin.Enabled = False
gintKeypresscount = 1
End Sub
Private Sub txtLoginID_GotFocus()

gintKeypresscount = 0

End Sub
Private Sub txtLoginID_KeyPress(KeyAscii As Integer)

If KeyAscii = 13 Then

KeyAscii = 0

gintKeypresscount = 1
SearchEmployee

End If
......

Hi VBProgrammer. Glad to see you have joined our forum here. Your code is really bad to read dear! I know ;) nobody reads 'userinstructions' I also usual never read the instructionbook of my coffeemachine :D , but indeed you should read ' Before you Post' and then using Code Tags and setting spaces, so it looks like this

Code:

Private Sub btnCancel_Click() End End Sub Private Sub Form_Load() btnLogin.Enabled = False gintKeypresscount = 1 End Sub Private Sub txtLoginID_GotFocus() gintKeypresscount = 0 End Sub Private Sub txtLoginID_KeyPress(KeyAscii As Integer) If KeyAscii = 13 Then KeyAscii = 0 gintKeypresscount = 1 SearchEmployee End If end Sub

Please for future posts use Code Tags. Its an advantage for all. If you dont know how, look into this post doing a quote on it and look how I did that. Its easy. If you dont use this tags, Left-Spaces, you maybe have had in your post are lost. Happy new year to all :wave:
January 1st, 2006, 12:30 PM
VBprogrammer2006

Re: My employee Time monitoring program

Quote:

Originally Posted by GremlinSA

This is a new table in the Database , Create it in Access, SQL, or the Database system your using..

Write your Server aplication as one EXE and your Clinet aplication as one EXE, with all the Different Components in forms and/or modules...

Are you sure that BtnLogin in on this form.. IF not you have to refrence it by (Form).Object.Property = Value. Double check the Name used...

Gremmy...

The BTN login is still not working what do I need to do to get it to do what I need it to
January 1st, 2006, 01:49 PM
GremlinSA

1 Attachment(s)

Re: My employee Time monitoring program

Quote:

Originally Posted by VBprogrammer2006

The BTN login is still not working what do I need to do to get it to do what I need it to

Well with out seeing the project, i can't help you there... But to help you a have posted a example login code for you.. In the Attached db. there are two users..

User1 :Admin - Password = admin
User2 :Guest - Password = password

Start up the project (DB must be in the project directory..)
Click File, Login to start the login procedure...

Play around with it .. Expecially the Util menu on the form... see how the two different users have diferent access rights..

Hope this will help you...

Gremmy...
January 1st, 2006, 02:22 PM
JonnyPoet

Re: My employee Time monitoring program

Hi VBpgmer
I have against my will now read me through all that terrible sausage
of code, because you still didn't correct it with codetags and adding all lost spaces. You only have obviously one function there where this
btnLogin.Enabled = False can cause err 424 and this ist that one

Code:

Private Sub Form_Load() btnLogin.Enabled = False 'error 424 occures here gintKeypresscount = 1 End Sub

Look at the above. Thats how it should look like.
And now there is only one reason that can cause this error.
YOU HAVE NO binLogin Button on that Form. !!! Maybe you have an button there but it is not btnLogin Look into the buttons Property maybe a damned typo like bntLogin or something like that. If you dont get it that way, delete the button an create a new one. I 'm very sure that this should work.

Jonny Poet
January 2nd, 2006, 11:20 PM
VBprogrammer2006

Re: My employee Time monitoring program

Quote:

Originally Posted by GremlinSA

Well with out seeing the project, i can't help you there... But to help you a have posted a example login code for you.. In the Attached db. there are two users..

User1 :Admin - Password = admin
User2 :Guest - Password = password

Start up the project (DB must be in the project directory..)
Click File, Login to start the login procedure...

Play around with it .. Expecially the Util menu on the form... see how the two different users have diferent access rights..

Hope this will help you...

Gremmy...

What I ment by log in was being able to have the application start as soon as the user logs into the actual computer because you and I both know that if the user has to log into the timer seperately they wont and then will defeate the purpose of the program

So what I was asking was if you know how I could tie the windows login into my application so that they only login once

thanks
waiting for your reply
January 3rd, 2006, 03:29 PM
GremlinSA

Re: My employee Time monitoring program

Quote:

Originally Posted by VBprogrammer2006

So what I was asking was if you know how I could tie the windows login into my application so that they only login once

thanks
waiting for your reply

Well then read this thread for the answer...

Gremmy....
January 3rd, 2006, 06:02 PM
VBprogrammer2006

Re: My employee Time monitoring program

Quote:

Originally Posted by GremlinSA

Well then read this thread for the answer...

Gremmy....

Sorry I'm needing so much help but the client I am working for has asked me to create this application for them but they dont understad that I have not ever done this type of thing before I support PCs I am not very good at building software applications (what I had done before is I had found a company that specializes in programming custom applications but when I came back to them with the price that they quoted me they said we are not willing to pay that we want you to build the program for us.)

Again I am sorry
VBProgrammer2006
January 3rd, 2006, 06:18 PM
GremlinSA

Re: My employee Time monitoring program

No problem ... Just it's eisier to point you to threads where these things have been discussed already rather than trying to explain things again... Also was in a bit of a rush when posting that answer..

Another thread worth reading is this one.

Gremmy...
January 3rd, 2006, 07:09 PM
JonnyPoet

Re: My employee Time monitoring program

Quote:

Originally Posted by VBprogrammer2006

but when I came back to them with the price that they quoted me they said we are not willing to pay that we want you to build the program for us.)

VBProgrammer2006

hmm. Do you like to work for one dollar / hour or less ? How much hours have you estimated to get all that work done ?You told, in one of the first threads, whats all needed to be done. I really dont want to disencourage you I would really like to here oother programmers estimate in that, because server-client applications is not my main field I'm programming, but my estimation for getting all that things done is more then 1000 manhours. And the next point is product guaranties. So maybe they never will pay you any cent for that or if paid claimng back money, because of producttroubles. If you are not familar with databases, and even when you are, you could experience so much multiuser troubles you really cannot imagine.

IMHO its totally OK to do such projects for personal use or for learning and fun, but in - excuse me - your state of know how - you should not even thing about, to sell the final product as a professional one. This would cost you much more than you ever can earn. People who told you that they didn't want to pay for real professional work,... forget them.

Thats a private advice which is the summary of my experience of 33 years doing business as electronic devices and services reseller.

BTW Have you solved that btnLogin problem in between ?
January 3rd, 2006, 10:27 PM
VBprogrammer2006

Re: My employee Time monitoring program

Quote:

Originally Posted by JonnyPoet

hmm. Do you like to work for one dollar / hour or less ? How much hours have you estimated to get all that work done ?You told, in one of the first threads, whats all needed to be done. I really dont want to disencourage you I would really like to here oother programmers estimate in that, because server-client applications is not my main field I'm programming, but my estimation for getting all that things done is more then 1000 manhours. And the next point is product guaranties. So maybe they never will pay you any cent for that or if paid claimng back money, because of producttroubles. If you are not familar with databases, and even when you are, you could experience so much multiuser troubles you really cannot imagine.

IMHO its totally OK to do such projects for personal use or for learning and fun, but in - excuse me - your state of know how - you should not even thing about, to sell the final product as a professional one. This would cost you much more than you ever can earn. People who told you that they didn't want to pay for real professional work,... forget them.

Thats a private advice which is the summary of my experience of 33 years doing business as electronic devices and services reseller.

BTW Have you solved that btnLogin problem in between ?

Would you be willing to assist me in creating this application
if so that would be greatly appreciated

thanks
VBProgrammer2006
January 3rd, 2006, 10:30 PM
VBprogrammer2006

Re: My employee Time monitoring program

Quote:

Originally Posted by GremlinSA

No problem ... Just it's eisier to point you to threads where these things have been discussed already rather than trying to explain things again... Also was in a bit of a rush when posting that answer..

Another thread worth reading is this one.

Gremmy...

Would you be willing to assist me in actually creating this application
if so that would be greatly appreciated

thanks
VBProgrammer2006
January 3rd, 2006, 10:46 PM
GremlinSA

Re: My employee Time monitoring program

Quote:

Originally Posted by VBprogrammer2006

Would you be willing to assist me in actually creating this application
if so that would be greatly appreciated

thanks
VBProgrammer2006

I would not mind helping you with some of the coding..
January 4th, 2006, 11:46 AM
JonnyPoet

Re: My employee Time monitoring program

Quote:

Originally Posted by GremlinSA

I would not mind helping you with some of the coding..

its the same with me. But I think you have to do the work, we can only assist you in coming out of troubles. And thats where I told you, be sure not to work for less then 1 Dollar / hour.

Additional: I never ,never again want to see code sausage, which is created not using code tags. So first rule if you want help by me is:
USE CODE TAGS and bring your code in a readable form using spaces in the left of the code so that logical brackets could be seen easily. Got me ?
And: Answer Questions. I have three times now requested if the btnLogin problem is handled now, I'm still there without any answer. !!:thumbd: :thumbd:
January 4th, 2006, 06:24 PM
VBprogrammer2006

Re: My employee Time monitoring program

Yes I did get the btnlogin problem fixed thanks for your help in advance

And how do I create code tags? Duh

thanks
VBProgrammer2006
January 4th, 2006, 06:38 PM
GremlinSA

Re: My employee Time monitoring program

Quote:

Originally Posted by VBprogrammer2006

And how do I create code tags? Duh

thanks
VBProgrammer2006

start by putting [code] at the begining of your code block, then end the code block with [/code]. you can also use [quote=User] [/quote] to do quick quotes..
January 4th, 2006, 07:02 PM
JonnyPoet

Re: My employee Time monitoring program

Quote:

Originally Posted by VBprogrammer2006

Yes I did get the btnlogin problem fixed ...
VBProgrammer2006

Thanks for info.
January 9th, 2006, 02:47 AM
VBprogrammer2006

Re: My employee Time monitoring program

How would I setup serial number security on this program so that when it is installed on a system the user must enter a serial number

I need to be able to randomize the serial numbers
I also need to be able to change the serial number at the end of the specified time of use ( when the license exprires)
When they renew the app they need to be issued a new serial number to reactivate the program.

please send code examples *it helps to see what it is supposed to look like*

Please Help

thanks
VBProgrammer2006
January 9th, 2006, 01:41 PM
JonnyPoet

Re: My employee Time monitoring program

Quote:

Originally Posted by VBprogrammer2006

How would I setup serial number security on this program so that when it is installed on a system the user must enter a serial number

See the following posts
http://www.codeguru.com/forum/showthread.php?p=1267651

http://www.codeguru.com/forum/showthread.php?t=365084

Both are descussing that theme. In one of the post Gremlin gives an examplefile. Maybe the full discussion and all hints are useful for u. Then do a soultion as you like and for diverse problems tell what problems you have and we will help you out. But we are basically nor doing the homework of others. And dont forget in all your posts use codetags.
January 14th, 2006, 03:50 PM
VBprogrammer2006

Re: My employee Time monitoring program

Is it posible to set time limits on use of the program (ex: 365 days)
and then force to repurchase (date has to be able to be changed by LGCC)

Please help
If posible please leave examples or links to examples to posts that will help

thanks
VBProgrammer2006
January 14th, 2006, 04:51 PM
GremlinSA

Re: My employee Time monitoring program

Quote:

Originally Posted by VBprogrammer2006

Is it posible to set time limits on use of the program (ex: 365 days)
and then force to repurchase (date has to be able to be changed by LGCC)

Please help
If posible please leave examples or links to examples to posts that will help

thanks
VBProgrammer2006

If you decide to use a method simular to this one that JonnyP pointed out before. In the unlocking key you could include an Expiry date and checksum (To make sure they cant fool with the key). The key is saved in the registry, and can be checked at every application startup.

If the program has expired you could then erase the Key from the registry, and disable the program.. Keeping track of entered keys can also help to prevent the user from turning back the date on the system and entering the old Key ( I use this method for a application that no longer has support and key updates.. :blush: )

There are a number of methods to do this.. but if your looking for one where the user cannot muck around with it. the date entry must be encrypted. The checksum must be part of the key and not a seperate entry.
(Another method I used to gain access to a application that allowed you to enter a date and 4 digit validation number.. took me 2 hours to find a validation code for the date 2020/12/31 :p <--- this is a small hobby of mine :D )

Gremmy..
January 15th, 2006, 05:32 AM
JonnyPoet

Re: My employee Time monitoring program

Regarding Code Example: I can only describe the principles as Gremmy now also described, but I cannot give you examples, its Code created by ma son and prof used so I'm not allowed to show any code or codepart because of copyright reasons. I know its a lot of work to go over that, but it has to be done if you ever want to get out some money by your application. But I think better to know how this can basically be done than to have nothing. :)
January 15th, 2006, 06:34 PM
VBprogrammer2006

Re: My employee Time monitoring program

A totally different question:

Is it posible to create a rutine for this application that will allow the admin to set it up over the internet to connect different locations together with One Server end application at say head office and just the client installations at the remote locations and then for the remote client, when they log into the system it then connects that location to the server end of the application that is located at head office

How hard would that be to create
Is it posible to send examples

thanks
waiting for reply

VBProgrammer2006
January 15th, 2006, 07:29 PM
GremlinSA

1 Attachment(s)

Re: My employee Time monitoring program

Yes.. it is posible to do remote (Over the Net) connections but bearing in mind that your connections pass through Firewalls and over proxy servers as well. The firewalls will have to be setup to accept connetions to the ports you use for this communication. The proxy servers will have to be setup to translate/ forward the packets across the lan/wan..

Idealy you would use a HTTP request to bypass some of these problems.. but that leaves a few security holes in the Application. Also HTTP is more of a one way request system. there are methods for full two way communication (Cookies for example), but i'm not too familiar with them, or the security issues around them.. But i do know they need to be initiated by the client.

Also the Server needs to be open to the net, not behind a Proxy or NAT (Network Address Translator). this is a requirment, Most proxy's and NAT's have one way connection requests.. Internal only.. External requests are normaly regected for security issues.. (Mostly to prevent system hacking).

But if your planning to deploy on a internal Lan look at this small application i wrong some time ago.

It uses the Winsock control with a simple UDP connection to connect several computers on a Subnet together for a 'Chat'.. It uses it's own protocol and can send files via TCP/IP from user to user.

If you got access to a network. run the aplication on two PC's. It will automaticaly pick up the network address and Pc name, You might have to click login, but else it will pickup any users running it and list them.

This can give you an idea how to connect the Server Client Applications together..

Have fun and Enjoy..

Gremmy...

PS. This is another of those unfinished projects of mine... its still a bit buggy, and a little tempramental. so dont be too suprised if a uer pops up twice or messages get duplicated or lost, but this only realy happens when the network is very busy, or the pc is very slow..
January 15th, 2006, 09:19 PM
VBprogrammer2006

Re: My employee Time monitoring program

Do I impliment something like this right into my program or would this run as a seperate application?

VBProgrammer2006
January 15th, 2006, 09:34 PM
GremlinSA

Re: My employee Time monitoring program

Quote:

Originally Posted by VBprogrammer2006

Do I impliment something like this right into my program or would this run as a seperate application?

I would recomend writing the Tcp/ip as a seperate ActiveX dll and making calls to it from within your application.. Just makes for easier debugging.. but otherwise it would be part of the program and not a seperate application..

Gremmy...
January 15th, 2006, 10:13 PM
VBprogrammer2006

Re: My employee Time monitoring program

How would I go about coding for the connection from this application to the SQL Server (for database) and from this application to Excel (For exporting the information from the database) and then being able to incorperate the data that is going to be recieved from the remote locations

please help *If you have examples that would help emencely*

thanks

Waiting for reply
VBProgrammer2006
January 15th, 2006, 10:35 PM
GremlinSA

Re: My employee Time monitoring program

In one of my previous posts i posted links to some threads that discuss these items, and also have a few code snips you could use.. Another thing you can try is a Search on CG for any of the following keywords. SQL, Connect, ADO, DAO, Select to get more info about connecting to a SQL server..

Gremmy..
January 19th, 2006, 07:51 PM
VBprogrammer2006

Re: My employee Time monitoring program

Quote:

Originally Posted by GremlinSA

In one of my previous posts i posted links to some threads that discuss these items, and also have a few code snips you could use.. Another thing you can try is a Search on CG for any of the following keywords. SQL, Connect, ADO, DAO, Select to get more info about connecting to a SQL server..

Gremmy..

Gremmy

I have looked through some (not all) of the posts and have not been able to locate the appropriate post for what I am requesting is there any way that you would know exactly what post it was and be able to send me the corresponding link(s).

sorry for the inconvience

Thanks
VBProgrammer2006
January 19th, 2006, 08:09 PM
GremlinSA

Re: My employee Time monitoring program

I'm getting ready to go to bed .. so for now... Look through this search for some threads to follow...
January 19th, 2006, 11:54 PM
VBprogrammer2006

Re: My employee Time monitoring program

Quote:

Originally Posted by GremlinSA

I'm getting ready to go to bed .. so for now... Look through this search for some threads to follow...

Here is the reply that I recieved when I went to the webpage that you had left the link for. Sorry - no matches. Please try some different terms

Sorry

VBProgrammer2006
January 20th, 2006, 03:06 AM
GremlinSA

Re: My employee Time monitoring program

Quote:

Originally Posted by VBprogrammer2006

Here is the reply that I recieved when I went to the webpage that you had left the link for. Sorry - no matches. Please try some different terms

Sorry

VBProgrammer2006

Oopps duno what happened with the search.. but here are a few threads to follow from that search..
Using ADODB here andhere
Using a recordset
Using the fields properties.

These should get you going...

Gremmy...
January 31st, 2006, 12:11 PM
VBprogrammer2006

Re: My employee Time monitoring program

Does anyone know of any ways to enhance this program with a copy restriction (so that the CD can not be duplicated at all(When a copy is attempted it should pop up a message box saying access denied))

Any suggestions would be greatly appreciated

thanks
VBProgrammer2006
January 31st, 2006, 12:46 PM
dglienna

Re: My employee Time monitoring program

Nope. You can't copy protect a CD, but you can have a registration scheme that requires a valid key before the app will run, or at least run with full features.
January 31st, 2006, 01:49 PM
GremlinSA

Re: My employee Time monitoring program

Quote:

Originally Posted by VBprogrammer2006

Does anyone know of any ways to enhance this program with a copy restriction (so that the CD can not be duplicated at all(When a copy is attempted it should pop up a message box saying access denied))

Any suggestions would be greatly appreciated

thanks
VBProgrammer2006

Theres a thread on that as well... I've added a link to it on my Sig Line..

enjoy...

Gremmy.....

Ps. your the Third person this last week asking about copy protection...
January 31st, 2006, 03:27 PM
Rich2189

Re: My employee Time monitoring program

Reading that previous thread, Can't you just write the value to an online database where the user has no access. record the number of times executed and there HDD serial and match it against the allowed serials when the user registers the product, no registration the program wont run either. If they dont allow the connection to the database then the program will end.

Rich
January 31st, 2006, 04:02 PM
VBprogrammer2006

Re: My employee Time monitoring program

Quote:

Originally Posted by GremlinSA

Theres a thread on that as well... I've added a link to it on my Sig Line..

enjoy...

Gremmy.....

Ps. your the Third person this last week asking about copy protection...

Is it posable for you to post this link as the link was not avaliable in your reply to my request

thanks Gremmy

VBProgrammer2006

PS: Do you know of a way that I would be able to capture video off of web cams and send it to a dedicated video capturing server
if so any suggestions on how to accomplish this would be greatly appreciated

Thanks again

looking forword to your reply
January 31st, 2006, 04:22 PM
GremlinSA

Re: My employee Time monitoring program

This one : Copy/ Install Protection..

You can read the rest of the thread to see what we were getting at...

Gremmy
January 31st, 2006, 05:10 PM
VBprogrammer2006

Re: My employee Time monitoring program

Quote:

Originally Posted by GremlinSA

This one : Copy/ Install Protection..

You can read the rest of the thread to see what we were getting at...

Gremmy

Thanks, now I remember you linking me to that thread earlier in our previous conversations. I don't know what I was thinking, sorry for acting so dumb that was not intentional.

but if you have any other suggestions on what I would be able to do for the video capturing delema that would be greatly appreciated

thanks
VBProgrammer2006
January 31st, 2006, 07:21 PM
GremlinSA

Re: My employee Time monitoring program

Quote:

Originally Posted by VBprogrammer2006

Thanks, now I remember you linking me to that thread earlier in our previous conversations. I don't know what I was thinking, sorry for acting so dumb that was not intentional.

but if you have any other suggestions on what I would be able to do for the video capturing delema that would be greatly appreciated

thanks
VBProgrammer2006

Not a problem..

Even i forget sometimes...

With the video capturing, unfortunately i have very little experiance with it... (Actualy with Video i'm pretty good, Our security camera's are all linked to seperate channels on the TV's (All 4 in the House...) but no video link to the PC.... sorry..

All times are GMT -5. The time now is 12:21 AM.