Recent content by Daryl

Currently there are 2 tables (see attached Excel file). I only used recipes as an analogy (it helps me understand the problem better). In the Program-Free table (or tab) the Item field is similar to an ingredients field. There are many ingredients that make up the company's product. But what...

It's been a while since I've used Access and need a little help with querying a table, which is similar to a recipes table. For example, recipe name is peanut butter cookies. Each recipe has a list of ingredients. I want to identify all the ingredients that are common in all peanut butter...

I’ve developed a query that produces a list of forms and an effective date where the form may be applicable. But now I am stumped. I need to reduce the results to a specific state (which I’ve done and it works) and for a specific date (the stumped part). Let’s say user needs 2/15/2005. I...

Using a command button, I am able to open files located in various directories locate on the companies network. The 'On Click' function (is that right) uses the following procedure / code: Private Sub cmd_ViewForm_Click() 'Set variables for lan directories relating to form field entries...

Unfortunately, I wish it were that simple. Legal needs to have everyone (all employees) who was employed on a specified date. A fishing expedition if you ask me. I've tried using >=Effective Date (I'll have to change that to Employed Date) in the Hired field and <Effective Date in the...

I am having fits with the empty fields and would appreciate any help. I am trying to identify employees who were actively employed on a certain date. I'm able to generate a list if they have been terminated. I can't seem to get those employee's who don't have a termination date (they are...

Wow! I surprised myself and found the problem. I had forgotten to add a needed combo field in the new form. It now works like it did and I'm all smiles.:D

I am developing a form with a tab control to take the place of a form with multiple subforms. Hopefully, the new form will improve functionality and appearance. The tabs will contain the subforms. A command button control, which works on the current form, enables the user to view a stored...

The database I'm working on relates to insurance forms. Every year or so a form (Form_nm) is revised and given a new version date (Form_vdt). Insurance regulators in various jurisdictions approve or disapprove the use of the specific form (Form_nm & Form_vdt). The EffDate field identifies when...

I've been trying to show an IsValid flag on the main form using the following code (and several variations)and can't seem to get it to work. Any ideas what I'm doing wrong or leaving out? Dim strValidFormCount strValidFormCount = "SELECT tbl_FormValidity.Form_nm...

Thanks for the suggestion Fornatian. Unfortunately that won't work entirely. Consider that I choose to update IsValid to false using and update query. This means there are no products using Part A. Later, a correction is made to Product C deleting an erroneous Exp_dt entry. Now the IsValid...

I have two related tables with a one-to-many relationship. In Table A I have a field called IsValid. In Table B I have two fields: Eff_dt and Exp_dt. In other words, if a part is being used in any of severable products, then IsValid is true else it should be false. Here's what I think I need...

I have a report based on a query. I've run the query and then selected the 'Filter By Selection' button to get the results the user wants. Rather than have me run these reports at each user's request, I need to be able to filter the query based on the user's selection of a field before...

I am using a combo box that allows the user to select only from a list of current products (e.g. ice cream flavors) from the Products table. The Products table includes the fields “ProdName” and “ProdAvail”. The Row Source uses the following query: SELECT [Products].ProdAbbr...

I have a form consisting of a few sub-forms. My problem is to get one sub-form to be linked to the master as follows: Form_num (master) to Form_RefID (sub-form) Easy enough, but here’s the catch. The Form_RefID field is supposed to be the Form_num field minus its last 4 or 5 characters...