Search results

Hi I've recently deployed a system across my network. Problem is when users access it simultaneously it crashes. All my forms, reports, macros and modules disappeared etc. Would creating a BE and FE solution resolve this? Any other clues would be much appreciated Thanks Frank

Dave Hi. You've helped me out on a few occasions with issues and I wondered if you were available today to complete some VB code for me. I'm willing to pay £250 whether it takes 1 hour or 1 day providing the issue is resolved to my satisfaction. If you have the time to work with me today...

David File attached

David That look great! I'm sending you a PM with some further comments. Please check Thanks Frank

First of all thanks to everyone for taking the time. David, I downloaded your amendments however although the error no longer appears, what I need is the Available Flexi to accummulate according to previous entries. So for example if the user has a surplus of 13 hours in week one, and a...

Thanks namliam Thanks also for your tips, most appreicated. Your first code didn't like the ExitSub command. Tried the second one as is. This got round the problem with the Runtime Error but for each record the flexi returned was simply their total for that week and not the accumulated...

Hey folks Trying for some time to resolve this issue but in short i'm not a programmer and simply getting nowhere. I'm happy to pay for an hour of someones time to resolve if at all possible. Payment will be made immediately through paypal. Please let me know. Link below contains further...

hey all Database attached if anyone would like some paid work please let me know. Thanks Frank

Hi Kharwar You may recall you helped me out greatly a few weeks ago with a running sum cap. At the time I indicated that it seemed to work fine except for certain dates which I couldn't understand. I get a runtime error 3021 - No Current Record on most (not all dates) that are in the first...

Dave Thanks for the reply. I got the code of Kharwar who was a superb help. The routine calculates Fleximax on a week by week basis and if it exceeds a certain amount it caps at 14.24 for that users next entry. Whether this is significant I honestly dont know! I'll try your suggestion and...

Hi Would someone mind having a look at my application to see if you can see my error? I've tried in vain for a couple of weeks now but to no avail. Long and the short of it is I have a routine which is calculating my total Flexitime per user per week. However on the first week of any month...

Thanks DCrake Tries what you suggested but so limited is my VBA knowledge that I must have broke the code. I ended up in an eternal loop and had to reboot the application. This is what I tried Function GetFlexiMax(FDate As Date, FId As IdleEnum, EmpID As Long, Maxlimit As Long) Dim Rs1 As...

Folks In my system users enter their timesheet weekly. It seems that on the first week of every month the following code falls over. Returning a Runtime Error 3021 'No Current Record' Option Compare Database Function GetFlexiMax(FDate As Date, FId As IdleEnum, Username As String, Maxlimit...

Hi Users identify organisations against a project from a pull down list which pulls from TBL_Organisations. If the user has an organisation that is not already in the pull down list, can they add to it from the pull-down, thereby adding to the table or do they have to exit the form, add to the...

Hi all I'm developing a small football site and would like my home page populated with summary pages from all the other pages on the site. For example, a summary from Latest News, Match Reports, Results etc... Using WebPlus to develop the site as I know little about Web Development Thanks Fozi

Kafrin That done the trick! Thanks for all your help. Frank

Thanks Kafrin Will give it a go. cheers Frank

Hi folks In my form there's an email button. This pulls through certain form data to the email combined with generic text. I have a block of controls on my form which are comments boxes. I need the email to pull through any comments in these boxes unless the box is empty - null or "". I've...

Thanks Dennisk. Will get onto it. Frank

Hi I need to create a record source for a report containing calculated fields. Advice I have been given is to do this through creating a temp table from which to serve my report. Currently I have a control in a Form which has a module generating a value I need for a report but the module...