Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 79
Search took 0.02 seconds.
Search: Posts Made By: dallr
Forum: Modules & VBA 01-11-2010, 09:33 AM
Replies: 17
Views: 14,927
Posted By dallr
Re: export tables to XML

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...
Forum: The Watercooler 04-17-2009, 03:38 AM
Replies: 7
Views: 950
Posted By dallr
Re: Happy Birthday Lpurvis!

Hey Leigh, happy birthday man!

Dane
Forum: Queries 04-16-2009, 10:44 PM
Replies: 9
Views: 672
Posted By dallr
Re: Union query

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

Dallr
Forum: Modules & VBA 04-16-2009, 10:10 PM
Replies: 9
Views: 1,281
Posted By dallr
Re: Programmatically omitting "Linked" Tables

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

Dallr
Forum: Modules & VBA 04-13-2009, 03:34 PM
Replies: 9
Views: 1,281
Posted By dallr
Re: Programmatically omitting "Linked" Tables

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
...
Forum: Queries 04-12-2009, 02:59 PM
Replies: 24
Views: 1,499
Posted By dallr
Re: Am I doing this right???

The "AS" keyword is optional in the FROM Clause when Alaising tables in Microsoft Access, hence I left it out.
Forum: General 04-11-2009, 04:06 PM
Replies: 16
Views: 992
Posted By dallr
Forum: Queries 04-11-2009, 03:14 PM
Replies: 3
Views: 915
Posted By dallr
Re: My first subquery......Help???

No problem I trust that the solution works for you.

Dane
Forum: General 04-11-2009, 02:30 PM
Replies: 16
Views: 992
Posted By dallr
Re: I need to delete a table

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
Forum: General 04-11-2009, 01:49 PM
Replies: 16
Views: 992
Posted By dallr
Re: I need to delete a table

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
Forum: Queries 04-11-2009, 01:17 PM
Replies: 3
Views: 915
Posted By dallr
Re: My first subquery......Help???

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...
Forum: General 04-11-2009, 01:02 PM
Replies: 10
Views: 786
Posted By dallr
Re: need alittle help here

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?
Forum: General 04-11-2009, 11:01 AM
Replies: 16
Views: 992
Posted By dallr
Re: I need to delete a table

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...
Forum: General 04-11-2009, 10:51 AM
Replies: 10
Views: 786
Posted By dallr
Re: need alittle help here

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...
Forum: Queries 04-11-2009, 10:08 AM
Replies: 24
Views: 1,499
Posted By dallr
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...
Forum: Queries 04-11-2009, 08:14 AM
Replies: 15
Views: 1,296
Posted By dallr
Re: Unmatch query

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...
Forum: General 04-05-2009, 11:34 AM
Replies: 22
Views: 3,509
Posted By dallr
Re: Why use a UNION query

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...
Forum: General 04-01-2009, 04:49 PM
Replies: 22
Views: 3,509
Posted By dallr
Re: Why use a UNION query

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...
Forum: Queries 08-22-2008, 11:27 PM
Replies: 3
Views: 656
Posted By dallr
NO problem. Dallr

NO problem.

Dallr
Forum: Queries 08-19-2008, 05:16 AM
Replies: 10
Views: 1,047
Posted By dallr
If my comment in point 2 above holds true you can...

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
Forum: Queries 08-19-2008, 04:47 AM
Replies: 10
Views: 1,047
Posted By dallr
OK, lets start over from the top by reexamining...

OK, lets start over from the top by reexamining you first post.
1. You said the output should be Rec1,Rec2 & Rec4. But your output should really be Rec2 & Rec4, simply because Rec1 does not have a...
Forum: Queries 08-18-2008, 01:30 PM
Replies: 10
Views: 1,047
Posted By dallr
JET which is the database engine that access uses...

JET which is the database engine that access uses is not smart enough at times. These types of queries do not show in design view. Therefore ,you have to handle all your edits in SQL View.

I...
Forum: Queries 08-18-2008, 11:14 AM
Replies: 10
Views: 1,047
Posted By dallr
What do you mean it gangs? Is it taking to long...

What do you mean it gangs? Is it taking to long to run? Have you tested it with a small amount of records first?

Dallr
Forum: Queries 08-16-2008, 05:19 AM
Replies: 3
Views: 656
Posted By dallr
Try: SELECT T1.* FROM YourTable T1 INNER...

Try:

SELECT T1.*
FROM YourTable T1 INNER JOIN
(SELECT Max([Date]) As MaxDate, Item FROM YourTable GROUP BY Item) T2.
ON (T1.Item = T2.Item AND T1.Date = T2.MaxDate)


PS: Please note...
Forum: Queries 08-14-2008, 04:42 AM
Replies: 9
Views: 731
Posted By dallr
Alex, is this question linked to this one in...

Alex, is this question linked to this one in many, way to me there are similar. And if that is the case then why have two threads running at the same time. Or two threads saying different things but...
Showing results 1 to 25 of 79

 
Forum Jump



All times are GMT -8. The time now is 05:00 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World