Search results

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

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

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

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

Hi. I'm trying to generate a report dynamically based on the selected fields to display. I'm using this as my aid. http://www.rogersaccesslibrary.com/download3.asp?SampleName=ChooseReportFields.mdb This stuff is great. And it works!!!! But what i'm trying to do is: I have a form with all the...