Search results for query: *

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

Hi, I was wondering if any of you guys could help me with a little problem I have. I keep getting error 3201 on one of my forms that forces a break in the visual basic. I want to handle this error so it doesn't do this, instead pops up a MsgBox saying "blahdy blahdy blah". I have...

Worked a treat mate, your a star! Thanks, Mol

Cool Ta mate, I'll have a play round with it :) Mol

Hi, Wondering if any of you guys can help me. I am writing a query that takes its data from 4 other queries. Each query works out the direct labour costs using a particular method ( ie one works out the piece rate, one normal rate etc). They run off a prompt box criteria asking for the Job ID...

Hi, I am writing a report that uses several subreports. I want to have a cumulative total box that takes the totals of all 4 subreports. The problem is that occasionally 1+ subreport may not contain any data (as the link field connecting it to the report has no record for that searched) and...