Search results for query: *

Hi I have a form which currently displays all records based on a value from a combo box. I am looking to change the form so that there are two combo boxes. The data is as follows: Column 1 = Datagroup Column 2 = Datagroup Version Column 3 = Data The first combo box will filter based on...

Hi I am exporting a query from a form, via a button. The query exported is used to populate the open form but the query output is filtered by a combo box. What I want to do is apply the same filter to the export so that what is seen in the form is also seen in the export. The code I use for...

Hi I have a subform with the following fields: Module, Datagroup, Version. The main form has two combo boxes: Combo Box 1 lists all datagroups Combo Box 2 lists all versions based on the datagroup selected in combo box 1 The subform needs to display the modules based on the datagroup/version...

This has also been posted on Microsoft: Access Forms as I was not sure where best to put this Hi I am using Access '97 I have a form with a subform set to continuous forms. This form reads from table [Access Paths] and displays five pieces of information for each record. What I have been...

Hi I have a form with a subform set to continuous forms. This form reads from table [Access Paths] and displays five pieces of information for each record. What I have been trying to do, however is highlight the text box where the value from the record is not the highest value available. An...

Hi I have a form which is used to update records on table 1. At the bottom of the form is a button to got to form 2 and display related records that exist. This works fine unless there are no related records on table 2. If this happens form 2 is just blank. What I would prefer is for a...

Hi I've been trying to figure this out for some time but have not managed it. I am using Access '97. I have a subform within a form with a combo box built to find specific sets of records. The subform is continuous. I have been trying, with no luck to add the option of showing all records...

I have imported data from an excel spreadsheet which has created a table where I am missing column names or the column names are not correct. I know how to change the column names and can manually insert columns by creating a 'select into' query. What I can't do is insert the new columns with...

I have imported data from an excel spreadsheet which has created a table where I am missing column names or the column names are not correct. I know how to change the column names and can manually insert columns by creating a 'select into' query. What I can't do is insert the new columns with...

I have a table which has multiple columns but I am only interested in querying on two of them the two columns are structured so: Column A Column B CD010 CDU CD010 CD010 FSA CD020 CDU CD030 CD040...

I've been trying to solve this problem on and off for a couple of days now but am getting nowhere. Hopefully someone can help. I have two tables where five columns match. Table one has 10 columns and table 2 has just the five columns I am trying to run a query where the result shows all the...

I have a view form which lists records based on a selection from a combo box. The combo box selects its records from a column on the same table. eg table Element has the following Element Gold apib001 Yes apib002 No apib003 No On the form the combo box is...

I have a table with the following three columns: SITE_COD BUS_CAT_COD BUS_TYP_COD SITE_COD and BUS_CAT_COD are used as an index to provide a unique list of category codes per site code. Each BUS_CAT_COD then has a number of BUS_TYP_COD records related. So for example SITE_COD...

Dear all I have two tables with a matching field of between six and eight characters long. I need to compare the two fields where the first six characters from field 1, table 1 equals the equivelent in table 2. This is because the first six characters are unique with the remaining two...

I have two tables both containing two columns as follows Batch Associate Table Element Table Name Online Associate Table Element Table Name I need to combine the two Table Name columns into a single column output so that I have a total list of all Table name records from both tables. Is...