Recent content by kcn

Thanks that was helpful. I'm surprised that the report wizard would do this though!

To add to the note above: the error message is "some data may not be displayed".

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.

Thanks. You pointed me in the right direction!

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

I don't know why, but it may relate to filtering the records. When I open and create a new record it pops me into filter by form and then gives the error message re creating a new record in design view. (And I did try compact/repair - didn't work.) thanks! k.

I'm having this problem as well when opening a form from another form. Any ideas would be appreciated (my problem hasn't magically disappeared yet).

FYI - found a solution that bypassed VB. Thanks again for your help!

Thank you for this example. Unfortunately, I'm still confused as to how to relate the data between the different files - i.e. how to pull in the data so that the "Total.txt" file puts the data in the correct order. In my case this means a pattern for each set of related data: Record 1 = Table...

I'm trying to do almost exactly the same thing and am confused about how to merge the files as suggested. Jean9, have you had any success with the code? Many thanks!

Hi, Yes, it links via ContactID. And, actually, it limits the recordset! (I guess I was having problems earlier while playing around with the forms). But what I need is to display the subform as a continuous form that doesn't require moving through the main form one record at a time. thanks...

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

This worked! Thanks again for all your help. :-)

Thanks for sticking with me on this. Here's the code. I did add a "'" to refer to YEAR as text field. I now get a syntax error. ************************************************************* If IsNull(DLookup("ProjectID", "tblProjectYear", "ProjectID = " & Me.ProjectID & " AND YEAR = '" &...