Search results

Sorry here is the first line for the first function Public Function NetWorkhours(dteStart As Date, dteEnd As Date) As Double here is the first line for the second function Public Function NetWorkMinutes(dteStart As Date, dteEnd As Date) As Double FYI the date formate for the start and end is...

I have used a minutes function then converted the total time to hour, but this is also giving me wrong results. Like for 60 minutes i'm seeing 660, and like 570 ect.. here is the code. '-- 480 minutes per day and up to 480 minutes for the beginning and ending day Dim intWorkingDays As Integer...

I think the problem is in the query, it is not showing the decimales, how can i make it do that?

Here is the code, as i said it gives me accurate resutls but whenever the total hours between two dates is less than one hour it gives me zero, the funcation i'm using is in a query. Here is the code. Dim intGrossDays As Integer Dim intGrossHours As Single Dim dteCurrDate As Date Dim i As...

I have a function that is calculating the hourse between two times, it's working fine for example time1 11:00am vs time2 12:00 pm, it gives me 1 hour, the only time it doesnt work is when the time difference is less than 1 hour, anything that is less than one hour i get 0, any advice? thanks.

PPadly, thank you so much, I did what you said and it works great. :)

hi, i have a column that has the date and time combined, how do i write a qurey for example to filter all records with time greater than 5:00 PM. I know how to do it if the time value was in a seperate colum for example > Timevalue("05:00 pm") but if the date and time are combined i dont know...

Thank you so much it's working :) :)

hi guys can somone help? I"m creating a dlookup query it only works when i inlude the value but not when i refere the value to a form. for example Nz(DLookup("[ID]", "[ID_tbl]" _ , "[Comments] like 'ABC'")) Is working but when i refere the ABC value to the form it's not working see below...

Hello, I have a module that copies a record then pastes into a listbox, is there a way to copy and paste multiple records or can i do it by pasting the second record by inserting a new line at the end of the used listbox? I know this is so confusing but any help would be so appreciated thanks.

I want to load multiple Ms-Exell files into Ms-Access table automatically through Procedure / Macros. The files will be in the same folder. How to do this process?. Can anyone help if you have done it in code. Thanks. "I already know how to do it thru get external data"

I hope that someone can assist, I know its probably a basic formula, but I cant' figure it out. I"m trying to get the total uptime for 20 devices per month. I have the total downtime minutes and total business time minutes, but do i have to consider the total devices in my formula!!! because if...

Thanks for the help, this worked for me.

Hi, I have an acces form which includes a date field, date is always first day of the month, for example 4/1/09-5/01/09 ect... I want to make an unbound field next to it the relates to the previous date, for example if i have 4/1/09 I want to make the new unbound field show 3/1/09, i can't say...

:) Thank you so much Sir, great Idea. You saved me a whole bottle of motrin until next week. Thank I got it this should work.

sorry i dont have winzip i just changed the file extension to xls, just change it to mdb. thanks.

Ok see attachmemnt it's an example table, the results i'm trying to get is account number 123 since it has status run and status start, other account #'s has status run but don't have status start so I don't want to see them. Thanks. FYI there is only one field for status. But the value can be...

Yes as long as the record has a combination of the two statues, "run" "start", I don't want to query a record that has "run" and "run" or only run or only start, in this table the record can have more than one run or start but I only want to query records with combination statues. Hope i...

Hi all, this might seem simple at first but it's really so complicated. I have a table that has records, there is a column for status. The table has like five different statuses. I have an account # feild and a statues field. I want to query all acount # that have two specific statues for...

I'm not sure if this is 2007 bug or issue, i've been using access for a long time, what i'm trying to do is modifying a combox query, so I put my expression then i save but nothing is saving, i come back to it and my expression is gone, anybody got a clue. thanks.