Search results

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...

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

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...

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...

Worked like a charm. Solved. Thank you so much!

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...

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...

Bob, thanks so much. I figured it out and it worked like a charm!

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?

ok. just saw the latest posts. Thanks guys. I'll give it a go and let ya know.

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...

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...