Search results for query: *

Got it Thanks guys and the code below is the results: If Me.SSN = DLookup("[SSN]", "Employees", "[SSN]='" & Me.[SSN] & "'") Then '-- Set rst = CurrentDb.OpenRecordset("SELECT * FROM [Employees] Where [Employees].[SSN]='" & Me.[SSN] & "'") If rst![ClockInOut].Value = True Then rst.Edit...

Got it Thanks guys and the code below is the results: If Me.SSN = DLookup("[SSN]", "Employees", "[SSN]='" & Me.[SSN] & "'") Then '-- Set rst = CurrentDb.OpenRecordset("SELECT * FROM [Employees] Where [Employees].[SSN]='" & Me.[SSN] & "'") If rst![ClockInOut].Value = True Then rst.Edit...

Here is what I have so far but it is not working? It gives no error but there is no data in the TotalTime field rst![TotalTime].Value = DateDiff("n", rst![TotalTime].Value + rst![Time].Value, Now())

The code is work all but the code below. I need to use data manipulation but I can figure out how to turn the below code into that? rst![TotalTime].Value = rst![TotalTime].Value + rst![Time].Value - Now()

I know I should use data manupulation but how do I turn that code into what I need?

This would be the code used when the table is opened and edited: rst![TotalTime].Value = rst![TotalTime].Value + rst![Time].Value - Now()

I ment nevermind I got it Sorry. But I do have another problem I started another form for this issue but maybe you can help: Ok everything is working except that I want to have the code below give me a updated total in hours and minutes of the total time an employee has worked but nothing is...

I am building a time clock system where the employee can type there ssn and clock in or out using only one button. Ok everything is working except that I want to have the code below give me a updated total in hours and minutes of the total time an employee has worked but nothing is showing in...

Never got it!!!! Private Sub clock_Click() If Me.SSN = DLookup("[SSN]", "Employees") Then '-- Set rst = CurrentDb.OpenRecordset("SELECT * FROM [Time] Where [Time].[SSN]='" & Me.[SSN] & "'") rst.Edit rst![SSN].Value = Me.SSN 'use the name of the field for your date in your table...

Below is the code I have that adds a new record each time an employee logs out or in. What I am tring to do is rather than it adding a new record I want it to edit the time record of the employee clocking in or out. I am having a problem figureing out how to find and edit the record I need...

Thanks for all your help. I did try that MajP but didn't get the same results the poster did. The linked image looks the same in the report as the embedded one, but does not look the same when you print it. I am at a lose

In any other circumstance I would agree, however, the image prints fine if it is embedded in the report.

I have an access report linked to an image on the server and it displays on the report great but when I print the report letter the linked image qulity is very poor. Any help with this? Thanks guys

Thanks for the respones all. No because I don't want to buy the software I want to build it. I just need to know the file extention.

No .*** is an example I need to know the real extension format of the Metro II file format.

Can anyone tell me what the extension (.***) is for the metro II format and can access out put using it?

Is there a way in the windows 2003 mail server to restrict any incoming mail other that the designated email accounts. The reason for this is the number of bad mails we receive in a given day. I would rather they be undeliverable than to go to the bad mail folder?

No that’s ok I have read up on the same thing about this and do greatly thank you for your help and all that tried. I think I am going to just forget it since I do have search capability for clients and if they need to search by last name they can. I also am going to begin building an SQL...

Thanks Tarwn for your help. It is now giving this error Undefined function 'InStrRev' in expression.

Belopw is the sql code I use to show a report the report loops via a function in the page that shows the results of the code below. All I need is for it to sort those results via lastname but not put the last name first Tarwn is right I am try to find the last space in the name as a starting...