Search results

Thanks Thats done the trick many thanks for your help:):):D

I am looking for some help with inserting a graph in a report. The report I have displays the agents details and their results, in the footer section it displays the totals and it is here I want to display the graph. I had the graph working but its now decided it wont any more.... The graph...

Hi, I have a table which shows fraud order Nos accepted and fraud order No's denied and I would like the system to give me one random number from accetped(Per Agent) and 3 random order numbers denied (Per Agent). Is this do able in Access or am I clutching at straws?????:eek:

You are an absolute starxx Saved me a lot of time and head scratching. Thank you Yes the time rounding up isn't too much of an issue. but thats fab. Thank you again

Thanks this is a step in the right direction, however I would prefer the time field also. Is This possible??

Can anyone help me please!!! I receive a csv file in which I need to import it into a table. It contains a date feild which looks like this '2007-06-15 12:17:54.953000000' and I would like it to look like this 'ddmmyyyy 00:00:00'. I have tried importing the data then changing the imported field...

You are a star!!!!! saving me a lot of time as my db is HUUUUGGGGE!!! and still trying to compress it. Many Thanks

I have checked the tables they come from and the fields are set up as number format. The query that goes into them has the property setting of General Number. I dont know what else I can do? Any Suggestions??

This seems really silly but I cannot get this query to work. In one table I have the agents name, id,Category, No of held emails and the time it took to put these emails on hold. In the other query I have the same agent details,category, No of reassigned emails and the total time it took to...

I had the same problem when I passed my cbt and when I passed my bike test as I was too short for bandit etc. I got a Yamaha virago 535 and had to put a restriction on it for 2 years. didnt make any difference and had the oomph when needed. Good luck and enjoy your bike what ever you get

I had this same problem with one of my databsaes and it was down to a a .ldb file. I tried to delete this file and it wouldnt go until the next day, so I moved my db into a new file and it worked fine.

I escalated this to our IT dept, and they think!!! it might be to do with our network migrating to xp and some mirroring stuff going on. So Im told that when all our stuff migrates over then we wont know for definate if I can get these db's working successfully. Thanks for your help on this. I...

I think it may be to do with the size of one particular table that I have. When you say 'backend server' Im not sure what you mean. The person who built our dbs buit a Data db, Import db and a System db, so im presuming that the data db is the back end as that is where all our tables are linked...

I have tried to manually link the tables and to use the link manager, I think it may be because our main db is so huge . You have to forgive me as I am not totally up to speed with coding : 'currentdb.tabledefs("mytable").connect - a jet table will report database="folowed by the path"' What...

We have recently upgraded our systems from 97 to 2003. A lot of our main info is kept in our Data db and we link our tables to this main db from all our other databases. When I try and link these tables after converting them to 2003 i get a ' Disc or Network error' and then all the queries...

We have recently upgraded our systems from Access 97 to 2003, I am trying to amend the import module so that it recognises the excel sheet we use to import. The old code is : DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, ImportTable, _ HostDir & ExtractFilename, True This...

it is just an Access database, but the other database has three pieces, data, import and system, but Im not sure how all of that is done, as Im picking up after someone has left. I think im doing ok for self taught access, never seen a database before july. Any hoo, will just have to copy and...

G:mid is where the actual cenceo database lives, I dont have a front and back end, Should I?????. The Cenceodata table I had stupidly linked to my import table, hence the fauxpa with the delete query.. The other tables in the cenceo database is our employees and our calendar but I haven't...

Ok I was being a bit thick with my delete query and worked out why everything was being deleted.... muppet!! Followed your instructions regarding copying and pasting the structure only, not sure how to make it and internal table only, i presume that you mean that its not to be a linked table. I...

Ok this is where weirness exceeds itself. I manually ran the query through excel and pasted into the import table, ran the append table query which worked (finally one that works) however if you run the delete query it takes the data out of both tables???? when the query only specifies the...