Search results

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

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

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

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

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

I am trying to open Word documents when a button is pushed. The documents are located on a certain server in a specific master forms directory. Presumably, the documents are located in certain subdirectories based on their usage (or placement by the user). The message box in the following...

I have a text box that provides a brief description of a product. If the field has no value (null or ZLS) it is set to display "No Description Available". This works fine except when the field has data beyond so many characters. That is, you only see part of the description. The data is...

Rather than repeat everything, please see my post at http://www.access-programmers.co.uk/ubb/Forum4/HTML/004408.html I've been told I need to write code to parse my proposed combo box. What's parsing and how would I do that?

I have two text boxes in my subform FormReplacementList: Replacement For and Replaced By. The subform is linked to the mainform by my primary key consisting of two fields: Form_nm and Form_vdt. Currently, the user navigates to a record using the main form and enters Replacement For...

Instead of repeating everything please see my request for help: http://www.access-programmers.co.uk/ubb/Forum3/HTML/002196.html Thank you.

I’ve developed a query on 3 different tables that generates all the records I need ... and then some (duplicates). The relationships are one-to-many (A to B) and many-to-one (B to C). There is no relationship between tables A and C. The output fields of my query which are later needed for a...

I've written code that allows user to create a new record source for my form based on the combo box selection. It works and here’s the code: Private Sub cboState_AfterUpdate() On Error GoTo Err_cboState_AfterUpdate 'Purpose: Change the form's Recordsource to only records from the...

I developed a command button that filters a form based on users input of 2-digit territory ID (in this case USA states). My problem is that when the user is done with the filter they want to remove it. I'm at a loss on how to show all records. Do I need to add another command button that just...

I'm fairly new with Access but my boss is asking me to track changes made to records in our database. I developed a History module based on MS Support Article Q183792. I am able to report changes in various controls of the main form to a memo field. My problem is that I can't get the changes...