Append Query

[Red via AccessMonster.com]

Good day everyone,

I have an append query that is mis-behaving. When I view the query it shows
the correct records that should append but when I actually run the query,
nothing happens. I dont get the append warning- nothing happens. I have
included my sql for your reference. What I can't figure out is why I can see
the data when I view the query and the data is there but won't run. Any help
will be greatly appreciated.

INSERT INTO [Basic Patient Data] ( [Pat SSN], [Last Name], [First Name],
Branch, Rank, [Email Work], [Work Phone], [Unit Assigned], [Base Assigned],
Deros )
SELECT [Waiting List Data].[Pat SSN], [Waiting List Data].[Last Name],
[Waiting List Data].[First Name], [Waiting List Data].Branch, [Waiting List
Data].Rank, [Waiting List Data].[Email Work], [Waiting List Data].[Work Phone]
, [Waiting List Data].[Unit Assigned], [Waiting List Data].[Base Assigned],
[Waiting List Data].Deros
FROM [Waiting List Data] LEFT JOIN [Basic Patient Data] ON ([Waiting List
Data].[First Name] = [Basic Patient Data].[First Name]) AND ([Waiting List
Data].[Last Name] = [Basic Patient Data].[Last Name]) AND ([Waiting List Data]
..[Pat SSN] = [Basic Patient Data].[Pat SSN])
WHERE ((([Basic Patient Data].[Pat SSN]) Is Null) AND (([Basic Patient Data].
[Last Name]) Is Null) AND (([Basic Patient Data].[First Name]) Is Null));

VR,

Red

 

[John Spencer]

Is this the only append query that you have that fails?

Have you turned off warnings? That is in Tools:Options:Edit/Find have you
unchecked confirm Action queries or have you used a macro or vba to Set
Warnings to False.

The query looks good. And when you run the query you should be getting a
warning message unless you've turned them off.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Jeff Boyce]

One possibility is that the SetWarnings have been turned off. Can you
confirm that SetWarnings is On?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Red via AccessMonster.com]

Thanks John,

That is exactly what had happened, my confirm was turned off. Thanks for the
help.

VR,

Red

Good day everyone,

I have an append query that is mis-behaving. When I view the query it shows
the correct records that should append but when I actually run the query,
nothing happens. I dont get the append warning- nothing happens. I have
included my sql for your reference. What I can't figure out is why I can see
the data when I view the query and the data is there but won't run. Any help
will be greatly appreciated.

INSERT INTO [Basic Patient Data] ( [Pat SSN], [Last Name], [First Name],
Branch, Rank, [Email Work], [Work Phone], [Unit Assigned], [Base Assigned],
Deros )
SELECT [Waiting List Data].[Pat SSN], [Waiting List Data].[Last Name],
[Waiting List Data].[First Name], [Waiting List Data].Branch, [Waiting List
Data].Rank, [Waiting List Data].[Email Work], [Waiting List Data].[Work Phone]
, [Waiting List Data].[Unit Assigned], [Waiting List Data].[Base Assigned],
[Waiting List Data].Deros
FROM [Waiting List Data] LEFT JOIN [Basic Patient Data] ON ([Waiting List
Data].[First Name] = [Basic Patient Data].[First Name]) AND ([Waiting List
Data].[Last Name] = [Basic Patient Data].[Last Name]) AND ([Waiting List Data]
.[Pat SSN] = [Basic Patient Data].[Pat SSN])
WHERE ((([Basic Patient Data].[Pat SSN]) Is Null) AND (([Basic Patient Data].
[Last Name]) Is Null) AND (([Basic Patient Data].[First Name]) Is Null));

VR,

Red

 

[Red via AccessMonster.com]

Thanks Jeff, you were exactly right, I had turned off my confirm action.

Many thanks,

Red

One possibility is that the SetWarnings have been turned off. Can you
confirm that SetWarnings is On?

Good day everyone,

[quoted text clipped - 23 lines]

Red