Search results

  1. E

    Code for bulk importing .txt file into seperate records same table

    I have 12,000 cvs that i need to get into An access database so i can start to extract email info etc. They are stored in one folder All Cvs under each of their names edc.txt (i have converted them to .txt) i want to create one table with two fields name (taken from the cv filename and contents...
  2. E

    Massive Integration Problem Any ideas?

    Thanks The Doc Man, i am forwarding your advice to them!!! They are hard work and seem to be fighting me even for money for a website! It seems to me they are trying to keep control but that is killing them!! Incredibly frustrating!
  3. E

    Massive Integration Problem Any ideas?

    Simon MT You can switch convert using access 2000 then from 2000 to 2007 using Access 2007.
  4. E

    Massive Integration Problem Any ideas?

    Very interesting - what about switching to Macs or linux for more security i.e windows is not a very secure system is linux better or Mac or Unix?
  5. E

    Massive Integration Problem Any ideas?

    Its not that big. 10 to 15 meg maybe 20 i think it may be compacted and repaired each week maybe each night though i will have to check! i think getting a copy of it and upgrading to 2010 or 2007 has got to be the first thing to try if it works at least the old computers can be ditched and the...
  6. E

    Massive Integration Problem Any ideas?

    the only backup that is being done is onto iomega zip drives .... not sure what a split database is ? do you mean tables in one dbase and data in another? because i don't think they are if that is the case!! Loading all the data onto a slave dirve is a good idea ... has anyone ever tried...
  7. E

    Massive Integration Problem Any ideas?

    Thank You the Doc_Man very kind of you and very sound Advice. The information they hold on this computer is the money engine of the company !!!! It is al Invoice information, Current sales. Staff Placed etc ...MASSIVE DEAL IF IT WENT DOWN OR IT IT WAS HACKED MASSIVE. They wouldn't be able to...
  8. E

    Massive Integration Problem Any ideas?

    Hi, i am currently helping a company which uses several different versions of Access. The Financial side is run on Windows 98 PCs and built in Access 2.0! the HR Side is running on windows XP and vista and using Access 2007. THey want to get on to the web and integrate all their databases so ID...
  9. E

    Please support these forums

    I will definetly support your site as soon as i get a web site built and try and link to as many sties that i build too. You guys have been fantastic and i wouldn't be able to do this without you! You really have boosted my confidence already and given me hope that i can set this up as a...
  10. E

    Creating Custom Right Click Menu to act on Highlighted text .

    Hi, I have a I want to create a custom right hand click menu that will allow the user to do the following. Select certain text in a memo field. Right Click and depending on the options the choose from the menu transfer copy of the selected text into another Memo field and bullet point it. For...
  11. E

    Generating Emails of Selected records in a continuos subform.

    I have changed my code but i cannot see why it is not working. it is Just saying "A problem occurred while MS ACCESS was communicating with the OLE Server or Active V control!" Does this mean it can't find the control on the form i am trying to access ? Private Sub Email_JobDetails_Click() On...
  12. E

    Generating Emails of Selected records in a continuos subform.

    Right!! I am trying to send an email to all the records i have selected from a continuous form ... my code at the moment is not even start due to activex or ole problems (not sure what it means ) but can anyone look at the code i haev written and tell me why or whether it is any good .. i thikn...
  13. E

    Refreshing a Form

    Hi, What is the best way to refresh a form (this is a subform) to make sure the information is current it only needs to be every couple of minutes maybe? Cheers ed
  14. E

    Is there a way of checking t osee if Outlook is open ?

    Do you run treat all you functions like this and if you want to early bind run through setting EarlyBind to 1 the nre-compile? I supppose 1 = Early Bind 0 = Late is that right? With the If earlybind Then i'm guessing that if it = 1 then it uses early binding terminology? One more question i...
  15. E

    Is there a way of checking t osee if Outlook is open ?

    Really good stuff Thank You very Much!!!! Cheers ed
  16. E

    Is there a way of checking t osee if Outlook is open ?

    clever coding vbaInet - i like it!!
  17. E

    Is there a way of checking t osee if Outlook is open ?

    Hey didn't see all the other ideas before!! They look great and i'm gonna have a look at them. There are definetly a lot simpler than devs. I will try and understand them before i use them ... like your const naming Banana!!
  18. E

    Is there a way of checking t osee if Outlook is open ?

    BRILLIANT Thank You!!! Thank You DEV!!!
  19. E

    Is there a way of checking t osee if Outlook is open ?

    Hi, I have written a vb function to email from within access using outlook but have noticed that when outlook is not open it just hangs the whole schbang! Is there code i can add to check to see if outlook is open and if not open it to avoid this problem? Cheers Ed
  20. E

    Searching Memo and matching against Multiple Criteria

    Thats pants!!!! That realy true!?
Back
Top Bottom