Search results

See if this works for you. You need to do what you are requesting in code. If you want to to export specific records then you can use the following. Code: Application.ExportXML ObjectType:=acExportTable, _ DataSource:="Customers", _ DataTarget:="C:\Learn_XML\OneCustomer.xml", _...

Hey Leigh, happy birthday man! Dane

Just Curious why would u be using a union here? What do these individuals queries look like? Dallr

You cannot delete data from MsysObjects table. Glad to help. Dallr

You can also do this via the SysObjects table as Paul pointed out, and use the "WHERE TYPE = xxx". Replace xxx with 1, 6 or 4 as indicated below. Access Tables = 1 Linked Access tables = 6 Link SQL Server Table = 4 Dallr

The "AS" keyword is optional in the FROM Clause when Alaising tables in Microsoft Access, hence I left it out.

Glad to help

No problem I trust that the solution works for you. Dane

Yep there are many ways to do this.... I would also place a exit For within the IF statement so you do not have to loop through all the remaining tables after you find a match. Dallr

Put the code in a module and then call it on your button as follows. Dim tbl as string tbl = "YourTableName" if TblExists(tbl) then '.....place your code here to delete the table End if Dallr

I am not sure what is this sites policy but u should not be double posting the same question. This can cause confusion and have. Different people helping u in different threads. It might be best to close off one and keep one active. I have replied in your first post...

I still don't know why u would be doing this!! Can u explain why do u want this requirement as appose to what u want to do?

There are many ways to check to see if a table exists. I would show you one method. Public Function TblExists(strTableName As String) As Boolean 'ADO Method Dim obj As AccessObject Dim dbs As Object Set dbs = Application.CurrentData For Each obj In dbs.AllTables If obj.Name =...

Why are you trying to copy a table from one database to another?? Why not just have a database already setup and insert the data into that external database. This would be cleaner and much more efficient. This link gives you some information http://allenbrowne.com/ser-37.html And this is...

Find All Customers who didn't Purchase the Following Yr There is no need to break up your customers into separate years and then try and pull them back together. You can simply get your results based upon the tables in question using one sub query. If I understand your requirements correctly...

Two options : 1. Match your two tables on the primary key and then us an IIF statement to match ALL the similar fields in question. e.g IIF(T1.Cost = T2.Cost,"Match","No Match") , ....... Then filter to show all fields with "No Match". 2. Option 2 which will be faster. Please take note of the...

Sorry I was busy over the last few days and I am now getting some time to add some additional comments. This can be a very good shortcut approach especially if you are working with many fields. However, one must be careful that the fields are in the same order when using this approach (...

I just wanted to add 3 points 1. I don't want you to leave with the impression that a union query is used to bring two distinct data sources (tables) together since most of the examples I saw was of this nature. You can also use a union to return results from the same table by "unioning" it to...

NO problem. Dallr

If my comment in point 2 above holds true you can even use this in your WHERE clause and replace what I had previously. WHERE YT1.TimeStart <=YT2.TimeFinish dallr