6 replies to this topic

[bradploz]

Im actually creating a Billing System wherein the employees work from Monday-Friday in the range of 8am-5pm (8 hrs a day). The Manager will determine their rate/hour and if they work on Saturdays there will be a 30% bonus.

The Manager can handle All modules, Add, Edit, Delete, View Employees, Clients and Projects.

I've already finished those windows for the manager, my last problem is the Time Sheets which contain all the info when the employee logged out everytime and the Billing Invoice for the Clients that will be printed on a monthly basis.

My worse problem is for the Employees. Every employee has a window that is connected to their user accounts that when they log in it shows their name,project,salary,time-in and time-out and when the employee logs out, all the records everytime they logged out will be recorded,I used textbox for the data to appear in the window, but I don't have any idea how to connect it. Also, the manager can view these records on time sheets and the manager can print a payslip for the employees.

I'm using MS Access 2007 as my database.

PLEASE HELP ME, I NEED THIS PROGRAM WITHIN 3 DAYS! :(

[WingedPanther]

Without seeing what you have so far, it will be very hard to help you with your homework.

[bradploz]

This is our project and if I will not finish it, Ill fail :( what do you need to know?

These are the things Ive done so far : ASC Billing System.rar

[WingedPanther]

I have two issues right now:
1) I don't have Access. I can infer some of what you have, but it's limited.
2) I've got VBExpress 2010, not 2007

With that said, I'd use a SQL statement to insert a new record into your database. I'm not clear on why you haven't used data-aware components, but that may be a VB thing (I haven't studied the language).

[bradploz]

I am trying to connect MS ACCESS 2007 Database with textboxes which will show the info of the users now..for example..when I login..I see my info in the textboxes..and when other user logs in..they can see their info..

This is the code I have on load after the window login..

Code:

Private Sub frmemp_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Timer1.Start()

Try

conn.Open()

cmd = New OleDbCommand("SELECT * FROM employees,username WHERE ID=IDE", conn)

dr = cmd.ExecuteReader

While dr.Read()

txtfn.Text = dr(1)

txtpro.Text = dr(2)

txtsa.Text = dr(3)

End While

Catch

End Try

dr.Close()

conn.Close()


End Sub

But this code only shows the last user on the row on the database..It is not changing even other users login..for example...I login and I am the last user on the row..I can see my info but when other user logs in..He just see my info..Not his...

please help me..tnx

[WingedPanther]

A text box can only show ONE piece of data, not multiple records. Because you loop through, overwriting the the values, you will only show the last record returned.

[edge02]

change your query use "Select * from employees where ID='" & txtbox1.text & "' "
where txtbox1.text will be the input coming form the user.
that way, the employee logged in will only see his/her info not others.