Search results

Managed to get most of the problem sorted now thanks to labans.com Although I am having a problem still.... Firstly I have had to use a background image for my report as it is a pre-made form. On top of this I have placed my sub-report with the information I want to show in repeating sections...

Everyone, I have a problem that I really am struggling to resolve. I will try to paint you a picture; I have a report with 6 vertically aligned text boxes (left-to-right). the 1st 2nd and 3rd boxes align at the top. The 3rd text box could be 1 or 255 characters (its a descriptive box). The...

Namliam, Everyone Although very crude I have finally cracked this bit of code with the help of another from my office. If you wish to use this piece of code then please publish although I know that it could probably be re-written differently to suit different needs. Option Compare Database...

Namliam, or anybody, Been working really hard on this with my limited knowledge. Still encountering a few problems. Case1 and case>1 are still not working properly and I think although I am heading down the right road the code is still not entirely correct. Please Note: Although the code...

Namliam, I do use indents but when I pasted the code form Access module it does not include the indents. I have printed your code and compared it to the module on the database. There are no differences between the two. IT STILL DOES NOT WORK!! I have added the Option Explicit. If you know why...

Thank you for your help so far. I have adjusted the code to the following: Obviously it still isn't working and I have actually ripped all of my hair out now. Sorry to sound lame but I have made up all of the script for the Case statements at the end and it does not come up with any errors...

namliam, Thank You for your help so far, but it is just coming out really confused now. I have inputted the code to see if it would work and it puts in -9 now so I looked at the code but I just can't get my head around it at the end. I know what you are saying with But I can't see how to...

Thank You sooo much. I never spotted that. Sometimes the blindingly obvious escapes the untrained eye ha ha. Would I be right in saying that the code should look like this at the end? 'Calculate number of work hours Select Case intGrossDays Case 0 'start and end time on same day NetWorkhours =...

Thank You for your quick reply, The code already has the lines: If Weekday(dteCurrDate, vbSaturday) < 3 Then nonWorkDays = nonWorkDays + 1 If Not IsNull(DLookup("[HolDate]", "tblHolidays", "[HolDate] = #" & Int(dteCurrDate) & "#")) Then nonWorkDays = nonWorkDays + 1 Next i Is this not the same...

Apologies for the poor formatting, I didn't realise it had pasted in like that. The datasheet should look more like this The actual function works fine, ALTHOUGH I have set-up an "Outage Calculator" for the line manager to use. It is really simple. Contains three text boxes that are not bound...

All, Please can anyone let me know why this is not working? I have the following code as a module in my access database: Public Function NetWorkhours(dteStart As Date, dteEnd As Date) As Single Dim intGrossDays As Integer Dim intGrossHours As Single Dim dteCurrDate As Date Dim i As Integer Dim...

Hi, Struggling a bit to enter expression. I have a [FaultOpened] Field in a table that stores the Date\Time that a fault is opened. I am trying to run a query that counts all Faults that have a fault opened date of between: 1st day of Last month - Last Day Of Last Month, or even just all faults...

DCrake, Thank You, you have just kicked my brain back in to gear. That is such a simple thing to do. I really can't believe I never thought of that. I think I may have been looking so in depth I was not concentrating on the easier thing to do. I will like you say create another table that can...

DCrake, Sorry if this sounds like a bit of a stupid question but, The NetWorkHours() function already works in the database. I can see that there is the extra bit of code in your version. Is this to enable me to put the call on hold? I can't seem to see what it would achieve. If it is then how...

http://www.access-programmers.co.uk/forums/archive/index.php/t-120289.html

:eek:Hi, I am trying to write a part of my database and am a bit stuck. I have used the NetWorkhours() Function available on the web for calculating working hours for Service Level Agreements in my database. Basically faults have an open date\time and a shut date\time. Each fault has an SLA...

neileg, Thank you for the advice. Using the SQL: SELECT Max(tblchecks.date) AS Maxdate FROM tblchecks WHERE (((tblchecks.[_checktype])=1)); I can extract the correct date for use. The 2 problems that I have left are that: 1. I can not add a day to that value, or a month for example using the...

Hi, I have a table called tblChecks. In this table I have 5 fields: id...........................autonumber _checktype..............number (link to tblListChecks) _checker..................number (link to tblUsers) date.......................Date/Time Time.......................Date/Time When...

Hi, Could someone please tell me what may be wrong with this code: DoCmd.RunSQL "Insert Into tblChecks (_CheckType, Comment, _Checker, Date, Time)" & _ "Values ('" & Me.CheckType.Value & "','" & Me.Comment.Value & "','" & Me.Checker.Value & "','" & Me.Date.Value & "','" &...

I dont think that you understand me MY BAD The first column in the recordsource for this list box is indeed a id column which I have hidden but it is the id column of the select distinct query that I would like to convert into the value obtained from tblUsers