Search results

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?

morning all, I need to create a button to open a MS word template (currently saved in the usual folder for word templates) - my DB skills (!) allow me to create a button that will open MS word, but for ease of use I would really like to be able to click on a button and have the template open...

the problem seemed to be with the form...i created a new form from scratch and the problem was no longer there. anyone got an explanation for this?

i reset an autonumber field using the method Pat desribed above (delete all records then compact)....this worked but now whenever i try ro add a new record via a form a warning box appears and says 'record cannot be updated'. once I click on OK then I can update the record freely. how can i...

Afternoon All, I've got another problem, no doubt simply solved by some access expert - I have a user defined, indexed unique reference number on a form. How can I get access to check whether a reference that is entered has not been used in a previous record? The way I have the form set up...

Problem sorted! in the query design view i had added another related table to bring through department names....i didn't actually need this - all i had to do instead was to type in the primary key number of the department rather than its name in the query in order to filter the records. the...

Pat, tried to update the table by altering info in the query itself - access would not allow this and said 'this record set is not updatable'.

Now that I have got a form using a query from a table is there any way I can allow the form to add records to the table? on the form properties I have set the 'allow additions' to yes but I still cannot add a new record.....anyone know where I am going wrong???