Recent content by szymek_d

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!

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...

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...

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...

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"...

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...

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...

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 |...

Now it works. Thank you!

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...

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"

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.

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...

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

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.