Recent content by dabbler

Hi guys and gals, I was wonderijg if you could help me in my hour of need. I have two comboboxes -com31 and com32. Following the change (update) of com31 I want to requery com32, and retrieve the corresponding value from the database using com31 as a parameter. I've got that bit working. But...

Thanks for the response. Okay, my query in the continuous form is select A, B, C, D from table1 (A=unique key) The form is a continuous form. The checkbox values are not to be stored in the database, but I want them available next to each row, initially as unchecked. The process I need is...

Hi there, I'm having trouble with a query/form that requires checkboxes. The form is based on a query. The query returns around a hundred rows currently, of which the data is a list of contacts. Functionality ------------- What I want is the ability to check each of the rows that I wish to...

I've created a form that allows the user to browse the machine for a .dbf file and now I need a piece of code that allows the user to select the contents of the dbf file into a temporary table. Does anyone know what the syntax is for: 1. referencing the database 2. referencing the recordset 3...

excellent thanks for that!

Hi guys, I'm trying to restrict the results of my query by a crude rowcount method. My existing sql query says "select customerid, date, item from sales where date = 01/01/2003" The trouble is there are tons of sales for this date. I know there are other ways of restricting this query but I...

Does anyone have a copy of similar code?

Hi guys/gals, Can anyone tell me the quickest way to do the following. I have a contact access database which need a regular feed from maillist spreadsheets received from data suppliers, and I need to build an import wizard. The excel spreadsheet contains the following data headings...

Thanks lads - top answers!

Yes but you would have to bring back all values, whereas I only want the second.

Hi guys/gals, I need to write a query which finds out the second highest value for a company. I have two tables, "A" and "B". A stores company names, and B holds the sales and each value. The tables are linked by A.COID =B.COID. What I need is the second highest sale for each company...

I was wondering if somebody could help me with reusability of subforms and queries, so that they dynamically work depending on what form is loaded. Problem - I have a query (Q1) which I would like to use as a record source for subform (SF1), which may appear either as a subform nested in form...