Search results

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.

Thanks for the prompt reply The only thing is I do want the comma to be in there, because later report gets generated based on that query and in this case I want to have comma between the first name and last name. Is it even possible to keep that comma in there?

Just quick and i think easy question I'm building a query in VB: strSQL = "SELECT f1, f2 & ", " & f3 as fullName" & _ " from t1" so my problem is the quotetion marks around the comma between f2 and f3. So is there a way in VB to make VB treat only those quations around the comma as character...

Hi. I'd like to export only email addresses separated by ";" to a word document based on a result of a query. Query gets build dynamically in VB behind the form as there are many search criterias. so user can eneter one field or many in the form to build the query. Queries work and i can...

hi. i'm trying to order a report based on a condition selected in a form that calls the report. for instance 'builds whereCondition varWhere = (varWhere + " AND ") & _ "[field1] IN (Select field1 From tbl1, tb2 " & _ " WHERE tbl1.field3 = tbl2.field4)" 'this is list...

Hi. Will a database created in Win Xp using Access 2003 work on machine running Win 2000 Pro and Access 2000? Thanx