Search results

bill, i've found that access is incredibly poor at producing graphs...i tend to creat queries with the required info and then export it to excel to generate graphs. I'm pretty sure access could do what you want but i've never got into using access for graphs...

cheers Ally, i did have one field appearing twice.....guess i was using that 'duct tape' you mention in your signature!:D

I have a report that is based on a query. It works fine but I am puzzled as to the existence of a field in the field list selector. it is called Expr 1004 and does not appear in the underlying query and when i select it to be displayed on the report it brings thru the primary key field for a...

..i think using the following expression in the criteria box on the relevant field in your query - like []&"*" ..this should prompt the user to enter a name, eg type in "Smith" and every entry under the name of Smith will be brought back (along with any smithsons, smithers etc). if you just...

100K of records?!? good grief...that must be nearing the limits of access is it? i think i remember someone telling me that once you get to that amount of records access starts to have problems?

...thankfully not....more like an amstrad 464!:D hopefully my IT dept will give me one of the natty new machines that they are doling out.

....how good our network is I do not know......my PC probably has something to do with the slowness...a pentium 2 with about 128k ram. it struggles with things like word and excel so a reasonably hefty database must be causing it problems.

thanks rich, fair enough....i was under the impression that making an .mde did reduce the size - it is back to a decent size now after being compacted so reducing it further isn't that important. I'll be keeping the bitmaps in as I spent a couple of hours yesterday making them on photoshop and...

cheers mile, i compacted it and reduced the size from 18.5MB down to 9.4MB! by turning it to an .mde it should come down further even if i leave my groovy bitmaps in!

...morning all, at what size does a database become too large? I've noticed that my one is now 18.5 MB and it is becoming quite slow (worringly i've only got about 200 records in it...eventually there will be three or four times that amount - i'll make an .mde out of it once i've stopped...

1st issue I can help with...have a look at this post - http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=42298&highlight=capital+letters. 2nd issue.....i've no idea mate.

...it is not a good idea to have calculated fields within a table....why don't you want to use a query?

cheers pdx_man, that does the job perfectly. I was wanting to automate everything to make it easy for users.....i'm sure they will be able to click the mouse button a couple more times to do what they need to! your help is very much apopreciated.

I have been searching the archives of this site for two days trying to find the answer but, alas, i still cannot get access to do what i want it to do - I am trying to export the results of a query into an excel file - this excel file will produce a graph....exporting to excel is not the...

cheers folks, Iif([field1]=1 or [field1]=2 etc works absolutely perfectly!

what is the limit to the number of Iif statements within a query? ii tried to use one that has 27 and access complains and says it is too complicated........is there a way around this? i tried another method but again it did not work... iif([field1] = 1 or 2 or 5, "result1", IIf([Field1]= 3 or...

i'm not sure if this is the best way (well, i'm sure that there is a less ham fisted way to do it) but it seems to work for me..... on the drop down box i put in some vb code which runs 'after update' - if [your drop down box field name] = 1 then [three letter field] = "xyz" else if [your...

Badangel, I had a similar problem a while ago - http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=37841&highlight=primary+key What i did in the end was to leave the primary key as an autonumber and concatenate this primary key to another field that provided the reference i...

how do i make access print out all of the 'tabs' in a multi tab form? i've tried using the command button wizard to print current record but it only prints the tab that the command button is on.

thanks neil, that was one of the threads I looked at but my coding deciphering skills are non existant - the template i need to use is called ncisdfi.dot........please excuse my ignorance but where in the code should i enter the template name?