Recent content by mollow

Hi, I don't know if this can be done, but I'll ask here anyway :) I have a printable form that the users of my DB use to enter specific job information (then print off and give to the shop floor). The problem is that on several occasions we have jobs that are almost identical and it would help...

Right i'm following up on myself here :) After a lot of hair-tearing i've found what the problem is. The recharge subreport calculates a final total and uses: =Sum(NZ([Total Cost])) The problem is that occasionally when i try to run the subreport i will get a "NZ expression" error...

Hi, I have a strange problem. I have a report that produces invoice reports. It draws from two queries, the main one prompts the user to enter the "Job ID" and collates production costs. The second has no prompt and collates any recharges. They both contain a field called "Job...

Thanks guys, I will check out your advice when I get home from work. Reghakr, haha I know it's a very blinkered view I was looking at, but sadly I do come from the school of "Give it a good kick if it isn't working". :þ Yes, I have played around with my cached files, but sadly it...

I'm having trouble with my internet. It appears that after I download a certain amount of websites, I can't connect to any more. I also can't download any mail nor ftp, yet I can connect IRC servers and MUD servers. I'm unsure as to whats causing this problem, although I know its not my web...

Worked a treat :) Thanks, Mike

Hi, I'm not sure whether this question should have gone in the VBA page, but rather than spam the place I'll just leave it here :) I have a replicated database. It autoloads the switchboard form on opening. I also have a nice big button on this form called, "Update", which...

Just to let you know, This memory problem was fixed in the SR-2 patch. Thanks for your help Mike

Thanks guys will give it a go. We are using Access SR 1 so will d/l the later patch. I'm unsure as to whether we have service pack 6A, our NT diag says 6, although i'm told even if it is 6a it will appear as 6 in winmsd As for the size. Yes the database as a whole is rather large, although the...

Hi, I'm having a little problem with my database. It keeps popping up a box saying that: "Not enough memory to update screen". Now this is becoming increasingly frustrating. The computer we use it on is a 266 64mb ram, although we are using Windows NT V4. I'm thinking it could be the...

Ahh, CInt wonderful thanks. IIF([x]="tba", CINT(0), CINT([x])) didn't work however, CINT(IIF([x]="tba", 0, [x]) did :) Thanks for you help :) Mike

Hi, I've written a query that performs a calculation to work out a total cost. However sometimes the total cost will have the text 'tba' in it. This means it can't use the SUM function. I thought i could get around this by using: IIF([x]="tba", 0, [x]) However, it appears that the...

Excellent, Worked a treat mate, many thanks. Mike

Hi, Wondering if anyone out there can help me with a problem. I have a report that calculates an invoice. The invoice contains 2 subreports. I would like to calculate a total sum of these subreports and can easily do so when both subreports contain data. The problem is that occasionally the...

Haha, blummin typical, no sooner do I post this message I figure out how to do it :p Thanks anyways Mike