Search results for query: *

Hi, I am consistently receiving an error message whenever I use the label wizard to create labels in an Access 2002-2003 database. Any ideas what this could be? It doesn't matter what size of label I select or how many fields I put in the reports. Thanks for your help, K.

Hi, I'm getting the same message display *twice* when I use the no data event: Private Sub Report_NoData(Cancel As Integer) msgbox "no records!" End Sub If I include a cancel statement (Cancel = -1), the second message that displays is the Access: "the open report action was canceled" Any...

Hi, I have two sets of data with a one to many relationship: 1. tblContact 2. tblHours The files link using ContactID. I’ve written a query- qryLimitHours – based on the “many” table that is not updatable. I would like to create a form with a recordset from tblContact that is...

Hi, I'm trying to set up a "single click" solution for exporting multiple excel files from a single query. The query is based on tblProject and I'm using a field in a lookup table - tlkpProgramOfficer - as a way to pass criteria to the query to create a separate file that exports for each...

Hi All, I'm not sure how to word this, so bear with me! I have a data entry form, Form A, which has the recordsource, Table A. The user enters data in Form A and then clicks on a button to open Form B. When this happens two values are coppied over to Table B (recordsource of Form B): an ID...

Hi, I need to regularly update a field (field 1) in a table based on the the data in two other fields in the same table. The data changes both when a new record is imported *and* when changes are made to fields 2 and 3. Note these are all text fields. The table itself has around 500 records and...

Hi, I am using a form for querying data for multiple reports. There are two dates on the form: Date1 and Date2. When I run a query it looks for date ranges between the two. I've used this for searching both over a range of months and within one month (Date2 uses a drop-down list that has the...

Hi, I have a report based on a query with two tables in one-to-many relationship. The table on the many side (Table B) contains criteria for report as well as the field I want to group on. In the report, I want to group on the field in Table B, and then give totals for fields from both...