Recent content by szymek_d

  1. S

    Create backup of db in vb code

    Works like a charm! I really appreciate your help. And next time i wont give up searching this forum, as it appears that we can get all our questions answered by thoroughly searching this forum!
  2. S

    Concatenation & Sending Email via Lotus Notes

    Take a look at this thread. It might point you in the right direction. http://www.access-programmers.co.uk/forums/showthread.php?t=87589 I used code written by "godofhell" it's a attached to one of his replies. I dynamically create a query that generates all the email addresses that i want...
  3. S

    Create backup of db in vb code

    Hi guys. I'm trying to create a backup copy of my database in vb. So user can click on a button to create the backup copy instead of going into tools and utilities. I'm trying to do it by compaciting the database. < DBEngine.CompactDatabase source, destination > Where source is path to my...
  4. S

    Really weird!!

    Ok. This is really weird. When i was using my database it crashed and access shot down. But then i just opened access and continued working on the database. Now i just noticed that when the database crashed new file got created myDB35_Backup which i did not create. Name of the database is...
  5. S

    Exporting field value to a word document

    godofhell; Thank you sooo much!!! This is perfect. It works for me. Now i'm just thinking; is there a way to skip exporting to listbox first. What i have is a query that gets build dynamically containing all the email addresses that meet my search criteria. Then i have a button "Print"...
  6. S

    Access version

    Thanks Doc. So if I install access 2003 on a machine that has windows 2000, then i won't have any problems? Currently i'm using windows xp and access 2003, but i want to be able to run this db on a machine that has windows 2000 and access 2003. Will the references be effected in this case...
  7. S

    Exporting field value to a word document

    actually i was just thinking. Would it be possible to put query result in a memo box separated by ";"? that would be actually the easiest for me when i'm using this db. This way i'll be able to cut and paste from the memo box. Would this be possible? Maybe i'll clarify a bit more. The query...
  8. S

    Exporting field value to a word document

    fixed the referencing problem.. thank you. now i figured out a quick way to output query result to a text file: DoCmd.OutputTo acOutputQuery, "zzztemp", acFormatTXT but the result is displayed: ---------------------- | E-mail | ---------------------- | dan@sadfs.com |...
  9. S

    Converting to string

    Now it works. Thank you!
  10. S

    Converting to string

    can anyone in the world thell me why this doesn't work??? Dim temp As String temp = CStr(Year(Now())) I get type mismatch error. why?? i created new form and tried it there... and it works.. but when i plug it into the form where i need it i get an error. i'm just trying to extract current...
  11. S

    Exporting field value to a word document

    Thank you. I will attempt to give it a try first thing in the morning. But just a quick question. how come when i declare object dim objWord as Word.Application it doen't work. Am i missing some libraries? The error i get is "user-defined type not defined"
  12. S

    Export query result to Word doc.

    Please let me know if it is even possible to do, as I am getting worried since I'm not getting any feedback. So please, at least let me know if it is even possible to do.
  13. S

    Export query result to Word doc.

    Hi guys. I posted similar question in reports forum, so I apologize for repeating myself a little. But i think this forum will be better place to find a solution I'm generateing a query dynamically that always returns only email addresses. This query is generated dynamically as there are many...
  14. S

    Ordering reports based on condition.

    Once again... thank you for pointing me in the right direction Wayne!! I'm playing around with queryDefs right now.
  15. S

    Easy VB question

    Thank you very much Wayne!!! It works now. I was using " as delimiter in SQL. It works, but it started causing problems when i started generating quereis in VBA.
Back
Top Bottom