Search results

All, The query I am working with is used to track training courses. Some of these courses have a re-occurring requirement for example Fire Extinguisher training may be required ever year (an interval of 356 days). There can be several intervals types 90, 120, 365 days or no re-occurring...

Hi All, I have an access 2013 database, part of the database is used to track employee training courses. Some courses have an annual requirement. I have created a report that is based on a query that returns the information about a given course. The data the query pulls is employee name...

First off I apologize for the big “wall of text” and I am no expert and self-taught. I am here not so much with a problem as a question, is the process being done correctly and/or is there a more efficient way of doing it. The process I am using works it just seems clucky. The attached Access...

I have a simple query that feeds a report. This query returns a list of employees that have taken a given training course. The information is Employee Name, date completed ect.. For example I can generate a report for all employees that have completed Safety Training 101. The report will have...

I have a report that is based on a query, I have tried to add the “Between [Start Date ] And [End Date]” in the query and it returns a blank report (headers no data)… I have been able to get this work using the manual method “>#1/1/2013# And <#6/30/2013#” but not the user interactive method…...

All, I have a post in the general area, I didn't know if it was better for here or the Reports area (didn't want to double post)... If someone wants to take a crack at it great, if so could you move it to here if it applies... Thanks

I am putting this post here because I am not sure if the best tool is a repot or a form. I have a database with employee folders containing various bits of information. My intent is to have a “main” page with a sub report or from containing employee names. Instead of the names being displayed...

The Title is a little misleading because I didn’t know how to present it… I created a query based on a table that contains several fields. The fields that drive the query are a date field “PrevInvestDate” and type field “Eligibility”.. The objective was to create a “ReInvestDate” based on the...

I have a query that I want to “filter” based on a date derived from a Build statement (Expression). The Build statement works I can even sort by “Ascending”.. But when I try to add a “Between [Startdate] And [Enddate] statement in the Criteria box, returns nothing…. Build statement ...

I am trying to create a query that returns records whether a field has data or not… There are three fields in question, SSN, DOB (this is a date field), POB (this is a foreign key representing a state in the query shows the actual state). Now unless the criterion is different then I just need...

I have a table “tblProperty” with multiple fields; some text and some number fields along with number fields representing FK, the number fields are things like “pages” and “copies”. I have created a query containing the table described above and the associated tables for each FK. When I drop...

I have an issue with getting an unbound combo box in a form to do what I want. I have originally posted in the Modules & VBA thread but have not gotten any “hits”. Below is the link to that post with details. http://www.access-programmers.co.uk/forums/showthread.php?t=227618 Thanks John

Hello All, I have an issue I am trying to resolve, I have a possible method to resolve this issue but I need help with the possible code. Also, if there is a better way to go about solving the issue please let me know. Background: I am using Access 2007; if you look at the attached Relationship...

Hello All, Not sure if this belongs here or in the Theories thread. Need some help/advice on the Normal Form/Normalization process as it relates to the tables shown in the .pdf below. I believe I have it down pretty good (I may be wrong); there are two things I need help with. First in the...

Hi All, I may/may not have an issue, let me explain. I have two a table’s tblCMAS and tblOrganization. The tblOrganization table has a list of organizations and is the one side of the relationship. The tblCMAS table has three fields that are linked by the relationship and pull data (OrgID as FK)...

My name is John, I am a self taught MS Access (2007)/data base enthusiast. Like many novice I have come to this position out of necessity. In am a computer network engineer by trade however in my current position as a Facility Security Officer (and for the record, I am not a security guard), I...

Hello All, I am having an issue trying to create a Combo Box to use as a search device, selecting a “Control Number” from the Combo Box pull down and having that record displayed. I am using a Form setup as a “Review Form” I.E. all of the fields in the Detail section are locked to prevent...

Hello all, first off I am a self taught Access 2007 enthusiast. Which basically means, I can get myself into trouble and maybe get myself out. Here is my issue; I have a table “tbl_CMS-Master”. This table has several fields the issue surrounds the “Status” and “Container” fields. Both of these...