Recent content by ncimike3

1. How do I round off time

I actually found a solution. I worked on this for a while and came up with this: AdjTimeIn: TimeSerial(Int(Int((Hour([TimeIn])+((Minute([TimeIn])+15)/60))*2)/2),((Int((Hour([TimeIn])+((Minute([TimeIn])+15)/60))*2)/2)-Int(Int((Hour([TimeIn])+((Minute([TimeIn])+15)/60))*2)/2))*60,0) attached is...
2. How can I convert a number to time?

I would like to convert a number such as 15.25 to 3:15 pm. What is the easiest way to accomplish this? Thanks.
3. How do I round off time

I've searched the forum but have found difficulty in solving this problem. I am trying to round off times to the nearest half hour. To be clear, I don't want to only round down or only round up. I need the rounding to be to the nearest half hour. I want to do this in the query, not vba...
4. Need a programmer for hire

Not sure if this is the right discussion group for this but here goes... I own a small business and it's growing. In the past I have set up access databases for my needs and it did the job. But now I'm a bit older (52) and need help with customizing access to fill my needs. A good knowledge...
5. Lookup values won't format my numbers correctly

Worked like a charm. Solved. Thank you so much!
6. Lookup values won't format my numbers correctly

I have a lookup value that accesses a table. The table values are set at 3 decimals. The value that is placed into looked up and placed into the data cell is formatted to 3 decimals. In fact it even displays 3 decimals after the value is selected. The problem that is driving me nuts is wen...
7. dynamic search box possible in VBA?

Some time ago I took a class in Visual Basic Studio and had to construct a simple form which was linked to a database. I had a search box on the form that would filter my search results as I typed. In other words for every key stroke I made I could watch the filter working away filtering my...
8. Is there a data entry shortcut for Entering a Date?

Bob, thanks so much. I figured it out and it worked like a charm!
9. Is there a data entry shortcut for Entering a Date?

Bob, thanks. Looks like the code has already been written. I think I need some help implementing it. I've never imported a module before. Anywhere I can read on how to bring those tools in and use them?
10. Is there a data entry shortcut for Entering a Date?

ok. just saw the latest posts. Thanks guys. I'll give it a go and let ya know.
11. Is there a data entry shortcut for Entering a Date?

Thanks for the quick response. Your reply leads to a new question. The key down event won't know the difference between a numerical entry and a down arrow. Or will it? In quickbooks, you have the option of typing in the characters 0-9, and the / character to overwrite the existing date or if...
12. Is there a data entry shortcut for Entering a Date?

I want to increase or decrease the date by 1 by simply using the plus or minus key when I'm in a Date field. If any of you have use quickbooks you would be familiar with this nifty data entry technique when in a date field. In my access form, when I go to a new record, the first field is the...