Search results for query: *

I have a query based on 2 tables. The first table (Profile) has a one-to-many relationship with the second table (Responsibilities) based on the field ID_New. There are UP TO seven "responsibilities" that each record in the Profile table can have. I thought the way I set the tables...

I have a form (frmSelectSeg), where the user is going to create their own query. The first control is a text box (Name) where they enter the name of the query that they want to create. The second control is a multi-select list box (lbSegment) where they choose the segments for their query...

I have a form that has several subforms within the layout. Right now, they are in the middle of the tab order. The form/subforms worked perfectly fine until I set the property of some of the main form fields to "required." Now, as I tab into the first subform, it keeps giving me an...

Thank you, thank you, thank you!!! Don't know why it didn't work before, but I just copied your code again and...voila! It worked! You don't know how long I've been working on this crazy thing. Ever thought about doing a FAQ for this type of thing (multiple selection combo/list box for...

Never mind, I figured out that I had to check the DAO 3.6 library in references, so I'm not having any more problems with that. But, it doesn't appear to be working. When I make selections from the list box and then click on my command button, nothing happens. The first time I did this, it...

Thanks for helping me with this one, PaulF! I have placed the code on the OnClick event of a command button on the form. But when the code tries to execute, I get a compile error: "User-defined type not defined" on the "Dim db As DAO.Database" and "qdf As...

I think I understand the code, but I don't know where to put it. Do it put in the OnClick event of the listbox or is it in the query somehow? What do you mean by "query string?" Forgive me, but I'm new at this. PaulF, how do I strip off the trailing ","?

I have an unbound list box (lbSegment) set for "Simple" multiple selection on a form (frmSelectSegments). A parameter query (SegmentQuery) gets its parameters from the list box. With my extremely limited knowledge of VB, I need to figure out how to make it work. I've searched...

I am creating a database that needs to have maximum user-friendly capabilities to query. The users query the database to come up with a sample to market new food products to. Participants in the sample are broken down into segment (e.g., colleges, schools, fast food), states, volume levels...

I have created a conditional macro to display a subform when the preceding field of a form is entered. I keep getting "The object you referenced in the Visual Basic procedure as an OLE object isn't an OLE object." What in the world does this mean?? I didn't do anything fancy -- I...