Search results

Thank you very much for the prompt responses. I used the "Dcount" option, made a couple minor changes to work with the form and walaaa, it works exactly as i'd like. Thank you very much for the help, greatly appreciated.

Forgive me for asking but how would i apply this? Ive got the table set which has fields for fname, lname, and dob. Ive created a form for said table and im in the property sheet for the form. Ive got dcount() in the before update but ive got a feeling im missing something. How do i get it to...

I was wondering if someone might be able to help me with something i'm having some difficulty with. I have a table that is going to track people. First Name, Last Name, and Date of Birth in three separate fields. I dont want to be able to add the same person in the table. How do i do this when...

Disregard that last. I placed the "code" provided by mattkorguk and it works perfectly. Its a bit more than what I was looking for but even better.

I appreciate all the help; however have one issue trying to apply this. I am not at all familiar with coding. Where do I put this "Code" string at?

I was wondering if someone could help me. I am trying to create a query to pull up people whose birthday is today in a different year. In my table, there is a field for DOB but when I use "Date()" as the criteria it comes up empty, presumably because nobody's birthday is todays date. How can I...

So i'm getting closer and closer however am still having difficulty understanding what is going on here. Some of the times are adding up correctly and some of them are just way off base. If you view the attachment, you'll see that the "Total Time's" for employee numbers 1, 2, 5,7, 8, and 9...

OK, still on the task at hand. I tried rounding the times to the nearest quarter hour and then adding those up and it worked. The problem with that is I dont want the times to round to the nearest quarter hour. I want the exact total time someone is doing something in real time. Example: 4:17...

("Field1")EndDateTime-("Field2")StartDateTime=("Calculated Field in Query")Total Hours: Format([EndDateTime]-[StartDateTime],"Short Time") This part is working fine, What I am trying to do is create a query or report to total all "Total Hours" for each individual person.

I have done this before in a so far successfull database but am now having problems. I have a report which indicates what time someone checked something out and what time they checked it back in. I need to get the total Hours the item was checked out. When I do this using the same method I...

I am ultimately trying to create a query to get the average hours/minutes per month a specific employee rides a bike. I successfully completed this task with miles, however am having problems with getting the average time/month. For the Miles, I created a query showing my start and ending...

Thank you very much everyone for your help. This worked perfectly and exactly what I was trying to do.

It appears as though either way works; however, I want the date to show only as July 26, 2012 rather than Thursday, July 26, 2012. I do not want the day of week shown.

Success. It seems to be working in 2010 and not 2007 version. Thats the part that sucks, i'm working at home on 07 and work on 10. Thank you very much for the help. I also applied the necessary changes to the other forms and it looks exactly as i want it.

Thank you for the help, one more question. I am not at all familiar with vba, where do I put this syntax. It looks like this would be the proper format for my need. (#17/04/2004#, "Long Date")

Is it possible to use Date() in July 25, 2012 format rather than 7/25/12 format?

I was wondering if anyone might be able to help me with something. I have created a report with a date on the top using a "label" coded with =now() which reports back with a format of "Wednesday July 25, 2012", is there additional code or another code I could use to have my result come back with...

What msgbox code are you talking about?

Here is a copy of the form. Also if you figure it out let me know what i'm doing wrong. I have several other forms that look similar to this one and have similar buttons doing the same thing. Hopefully whatever we do to fix this one will fix all of them.

Which values do you need? The top/left for the button?