Search results

Oh, and thanks for the prompt initial reply.

That gives me errors, but I don't think it does what I want. Effectively I want to return the following conditions: ((Count(ID) > 1) AND (TEXTFIELD Is Not Null)) OR ((Count(ID) = 1) AND (TEXTFIELD Is Null))

Greetings all, I have a situation where I created a UNION query to generate a distinct list of items from multiple tables. However, as part of the query, it generated some combinations that have some null fields that I would like to get rid of to clean it up. The problem is, I don't want to get...

Okay, I figured it out. I'm not 100% sure why the other ways weren't working, but here is the solution: SELECT [Rotation Descriptions].RotationDescription, [Rotation Descriptions].Supervisor FROM [Rotation Descriptions] LEFT JOIN Assignments ON [Rotation Descriptions].RotationDescription =...

Okay, so I fiddled with it a little bit and decided to write my own SQL statement. Here it is: SELECT [Rotation Descriptions].Supervisor, [Rotation Descriptions].RotationDescription FROM [Rotation Descriptions], Assignments WHERE ((([Rotation...

Hello all. I seem to be having some issues with this query and I am not quite sure why. I'm using Access 2007 and have a rather simple comparison query that tests to exclude items that exist in related tables. Here is the code: SELECT [Rotation Descriptions].RotationDescription, [Rotation...

Thanks much! That fixed it.

Here's what I'm attempting to call: Public Sub Clean_the_database() Dim SQL_Supervisor As String Dim SQL_FCG As String Dim SQL_Competencies As String Dim SQL_RotationArea As String SQL_Supervisor = "Line Manager/Supervisor CDSID(s)" SQL_FCG = "Current and past FCG CDSID(s) in this rotation"...

Hello, I've been finagling with a form that has a single button that executes some code (which it does flawlessly now). Anyway, I want to execute said code from my switchboard rather than force someone to open a form and click a button. The function is a simple one that simply calls other...

Hello, I'm throwing together a database that will allow users to take data from a MS SharePoint survey, import that into an Excel spreadsheet and then make eye-friendly reports based on that data in Access 2003 (though I do have to use Excel 2007 to import the data...long story...regardless it...

Noted. Thanks.

Huh...well...that worked...I don't get it. It must have been my spacing with the SQL text creation. It works now (granted, I can't use the rs.Movelast command though). Thanks a bunch! Oh, and here's the updated code that corrected the issue. SQL = "SELECT * FROM (" & _ " SELECT...

Sounds good. Look forward to the reply. Thanks much!

Thanks for the help you've given thus far!

KenDigg: It makes no difference. Both: Attached is the zipped, stripped version of the database you asked for. This has the ID hardcoded into the static query. The static query is listed as Query1. The only form in there contains the VBA code. Clicking the "trashcan" button will execute the...

KenHigg: I just attempted that and it still returns 1 record. RuralGuy: I believe I have already done that? See the code above for the exact SQL query I ran that produces 0 records. As far as I know, the two queries are identical in every way except for what calls them (VBA vs running a normal...

Yes and yes.

Nope, I'm using Access 2003. I get a RecordCount of 1 when the normal query returns 0 records...perhaps there is something wrong with my VBA version of the query?

Hello all, so here's an example of what I'm doing. I have a sequence of nested tables with "deletion requests" to allow database admins to process deletions. Anyway, I don't want the admins to erroneously delete all related children if it wasn't the intention of the deletion requestor, so I...

Oh, disregard that last post... Anyway, I figured it out, and the no spaces thing was spot on. Thanks a ton!