Search results

Right now with what I am using I have only spaces. Using dash between Co name and persons name.

In writing my last comment, sometimes you write your own answer, I think I have figured it out. Seemed to simple, but hey. I believe the answer is [CompanyName] & "," & [LastName] & ", " & [FirstName]. To answer your question, if the company does not want a persons name the first and last name...

No, a field for each. I have a customer form that saves first, last, address, city, state and zip. The combobox is on the order form. In using you choose the name, first/last from the combobox and all other info is auto into the order form. I have a query using customerID with LF: [LastName] &...

I have a customer form with source customer table. The table was originally setup with first and last name but I've found I need a company name and sometimes just the company name because some companies do not want a persons name as part of the invoice address. I have added CompanyName to the...

Thanks everyone. Got it figured out. It was mentioned to me how was I opening the form... and there is the key. I had not thought about what was opening the form. It is a button on a completely different form that opens it and it had the line DoCmd.GoToRecord , , acNewRec that was doing it with...

There is nothing in the events you mentioned and it is a continuous form that serves as a report for info entered daily.

Nothing in the open event and I see nothing that relates to new record.

Hello guys. I have a continuous form that has enough info to have a scroll bar. When I open the form it jumps to the bottom of the list and new, for new record is in black. I have tried all the settings I can find on the subject, set tab order and set ID 1 as subject. ID 1 does appear in black...

Did you fix this in the module? The two bold lines need to be added. If Not IsNull(![TimeOut]) Then TotalMin = TotalMin + DateDiff("n", !TimeIn, !TimeOut) End If

The fact that an employee has to choose their name on the main menu and then click the Time Clock button in order to even get to the clock in/out form, I can't imagine they would do all that if not clocking in or out. Once clocking in or out the form auto closes. When reopened under the same...

It is set for only clock in first. The clock out is greyed out until clock in is done.

Thanks, I like it. Works great and makes more sense to have this way. I was going to do it in the TCForm also but noticed there is already an event procedure in On Time, I guess for the box in/out.

I fixed it. I never pat myself on the back because I usually don't get the opportunity, but this time I feel like it. Coding is not like riding a bike if you haven't done it in over 30 years. So to look at a bunch of code and try to figure out what you need to change when it is Greek, well you...

Hey arnelgp. Don't want to keep bothering because your help is great. The error does seem to be fixed unless I close the program and reopen several times the error reappears in report. I am testing doing occasional clock ins with no clock outs and testing report in between them. This is when the...

Hey arnelgp, thanks. As usual, you have it down. It works and is exactly what I'm looking for but when I choose an employee and do just a clock in, forgetting to do a clock out, which I'm sure someone will do, and look at the report, I am getting a run-time error 94, Invalid Use of Null. I took...

Yea, since I couldn't get it to work I enabled it.

Yes, I disabled clock out button in properties and tried vb code to make it available when form reopened but still greyed out. I am trying to make it so an employee has to clockin before they can clock out. It doesn't matter when that is. In other words if they have been at work for eight hours...

What you are saying is exactly what I am trying to achieve by if an employee opens the form at the beginning of their work schedule the Clock Out button will not be available, only the Clockin button will be available. I can achieve this but when that same employee opens the form to Clock out...

Admin, the person that takes care of the time report and writes the checks will adjust the time. The employee that forgot to clock in will merely let them know what should have been the correct time. This will not happen often but out of 30 clock ins it happen once and that one time was enough...

The form doesn't close if no buttons are clicked. The close button at the bottom of form is just to close the form if no one is clicking in or out. If someone clicks the Clock In button it automatically puts in the time of clicking the clockin button and closes the form. Same with clock out...