Search results
-
D
Repopulating a combobox following a requery
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... -
D
Creating checkboxes for a form based on a query
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... -
D
How do I read DBF files in VB?
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...- dabbler
- Thread
- Replies: 0
- Forum: Modules & VBA
-
D
Restricting rows in a query result
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... -
D
Importing Excel data into multiple tables
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... -
D
How do I get the second highest value?
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... -
D
Dynamic Queries
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...