Search results for query: *

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 = '" &...

Hi, Well, I'm not sure if it's the use of Null or what, but the if statement didn't work. However, after playing more with data entry your original suggestions are working (though not as smoothly as I'd like) so I'm not too stressed! Thanks again for your help. k.

Hi, Thanks to you both, I did learn something but it doesn't solve my problem, because it doesn't stop the user from opening the new form and entering lots of data before getting that error message. As I have it currently designed, the user clicks a button that opens Form B and copies ID and...

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, yes. that's closer. because field 1 needs to be set to four different categories depending on data in fields 2 and 3, i guess i would need to create four separate sql statements, or four separate queries and run each of them. i'll give this a try. it's far more simple than what i was...

hi, i may have an unusual situation here where the users like to work both behind the scenes and with forms so that i need some way to bypass the beforeupdate event (although thanks, that was helpful). the imports are irregular and are not currently automated. i also find i'm beating around...