Search results

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

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

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

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

I have the following code in a standard Access 2003 query that works fine: SELECT tbl_MasterSubCaseIDQuery.CaseNumber, tbl_MasterSubCaseIDQuery.CaseID, tbl_MasterSubCaseIDQuery.SubcaseID, '' AS CustodianID, '' AS EvidenceID, '' AS LogID FROM tbl_MasterSubCaseIDQuery WHERE...

Hi, I have a database with a 5-tier table hierarchy. My database users are not allowed to go in and delete records and as such, I have them "request" that they be deleted, by selecting a specific checkbox for each record they wish to have deleted. This doesn't happen very often, so there hasn't...

"Run-time error '2455'" when closing Access after making editing changes to a form I searched through the forums here and couldn't find any answers to this one, though some others have experienced similar issues. Anyway, I have a form that works quite well for everything I'm asking of it at the...

I have a database that has a backend for all the data and a frontend with all of the forms/reports/macros/etc and is used globally by my team. All of the US and EU offices can access it fine with no latency issues, but we are experiencing issues with our Chennai office with access times and the...

I have the following function: Private Sub Form_BeforeUpdate(Cancel As Integer) If (IsNull(Me.CaseID) = True) Then Msgbox "This Subcase record is not tied to a valid Master Case record. Please cancel your changes by hitting Escape.", vbOKOnly, "ERROR" Cancel = True...

I have a form with 4 additional nested tables, for a total of 5 forms, each representing a tiered layer of my database. For the sake of conversation, let's call them Form_Master, sub1, sub2, sub3, sub4. What I want to do is disable editing on each form when Form_Master loads and whenever the...

Okay, so here's the deal. I need to make a report that has 10 charts in it with the following criterion: Each chart has its own query associated with it. I have tested the charts ahead of time individually and they all work as desired. Each query has 1-2 data inputs (Month number and Year)...

Okay, so I have a chart/graph to create based on a few bits of information from one of my tables. I have the queries set up to do most of my work for me and the chart/graph creation is not my issue. What I need to do is perform analysis on a given month/year (which the user is prompted for)...