Recent content by GetReel

Sorry I should have made myself more clear. =J29+C30-SUM(D30:G30) worked. Thanks

Havent used excel for a while so I am a bit rustly on formulas. Im trying to create a running balance I have 2 cell that i need to add. This part is fine.. =SUM(J29,C30) . This equal 111. Now I need to subtract the J29,C30, which 5 to give me 116. I tried =Sum((J29,C30-J29,C30) but is didnt...

Ive got it working. It was no of records being imported and exported that was the issue.

WORKED!!!!!!!!! Cheers ..!

Hi Ive have used the wizard to search for duplicate record. after running the query i noticed that it picks up records where there is more than to duplicated. There a some record where there a 3 or 4 records I need to keep. The criteria in the query is as follows; In (SELECT [Name] FROM...

Thanks for that but it didnt work.

Hi there. I hope I have posted my question in the right section. I worked out how to import data into access but I am coming across a small problem. I have function the imports all the data and the heading from the excel sheet in an existing table. This works well except doesnt like certail...

Thanks ..I try to employ it.

I had a quick search but couldnt find what I was looking for , I have a date field called txtDateReceived and another date called txtDateAllocated. I have these date inorder to calculate the no of cases have been allocate greater than 3 days. I have notice that some staff are failed to record...

perfect!! thank Paul. much appreciated.

I cant recall where I have seen it but Im after some code that will display the number character left on an unbound txt field before a user reaches the allowable 255 characters in a bound text field. I try searching the forum but could not find anything. Any help how could do this would be...

perfect!! ....thank you so much.. I'll check out the help on Access.

Hi there, Im having troubles trying to figure out how to make a field add the following each time a new record is created. my field is a client file which looks likes this ; CLF2006/0002 I would like the characters "CLF" to allows show so that all the user needs to do is add the year and...

I have managed implement GHudsons Audit Trail into my Db but im have a little difficulty trying to get it to work when main form is open with subfrmMovements . I have the Audit trail sitting in this subform. Having said that I wouldnt have the faintest how to change the the values below to...

I found this cool appointment calendar but I cant seem to get it working. Im getting a few compile errors that I cant seem to fix. One of the missing ref is microsoft outlook that I dont need. Im using A2002. Any help would be appreciated.