Search results

Sorry, VB applications are beyond what I know. Anyone else?

DoCmd.RunMacro

You want to set the string to the text box Control Source. Me.Text3.RowSource = myString

If you don't specify criteria for a field, all results will show up. So as long as you don't tell it anything about the webtype, you will get all matching records regardless of web type. Just as an FYI: if only one of the four check boxes can be checked for any record, an option grouped linked...

Do you want your users to only search one field at a time, or can they choose more than one? If it is one at a time, I put my results into an unbound ListBox on the form by dynamically changing the RowSource for the ListBox. They choose which field they want to search (in a drop down) and then...

Brian, it is somewhat difficult to answer your questions because it is unclear as to what you know and the way you did things. Here are some good questions that you can answer for us: 1. The Bill of Materials - is that a table in your database? A report? 2. Quantities: you said it is a field...

It is possible. You have to obviously create the extra field in the table. Then, behind each check box's AfterUpdate event, put the following code (I would run it from a Function that each event points to): Dim strBoxesChecked As String strBoxesChecked = "" If Me.chk1 = True Then...

Thanks. I thought the ListCount property listed how many rows were displayed, not how many existed. That makes what I want to do very easy. Thanks alot! Dave

I have a search form that, when the command button is pressed, updates the SQL statement for a listbox rowsource to display the records found. If no records are found, I would like to give a message box to say so. Is there a way to dynamically retrieve the number of records in a list box...

Hadn't thought of that. Thanks. That's a good idea.

Alright. I have used that in certain instances. I guess I would rather just keep everything in code than have to create a new form each time I want a custom msgbox. But if that's the only way to do it....! Thanks for your help. Dave

Sorry, I am not following. In that help page (which I have looked at before), it lists all of the default options for the buttons. I am looking to create custom messages on the msgbox buttons. Perhaps a msgbox with one button that says "Press here if you like cheese" and another that says...

Can you stipulate what the buttons say on a message box (instead of just Yes, No, Cancel, etc.)?

OK, I tried all of your suggestions and they didn't work. The only way I can get it to happen is to put the GoToRecord command in the OnOpen event of the subform, and reassign that subform to the SourceObject of the control on my main form in the OnCurrent event of the main form. It hiccups the...

Bill, thanks for being my person Access assistant! I tried what you suggested. For the name of the form, I tried the name of the control, the name of the subform placed in the control, and Forms!MainFormName!SubFormName and none of them worked. It kept telling me that the form (subform) was...

I have a subform on a main form. When the main form changes records (OnCurrent), I want the subform to move to the last record. How do I do that? Dave

That is the direction I am headed. What I don't understand is this: changing the SourceObject for an existing subform is considered a design change. When I tried this before (with a user's login), I got a message that they did not have priviledges to make design changes. What am I missing? Dave

Thanks for your responses. I have a main form now with about 10 subforms stacked on top of each other, of which only 1 is visible based on a choice in a listbox. What I am trying to do is lessen the work the form has to do when it opens by not having to open all 10 subforms (even if they are...

I want to, using VB, open and close subforms on a main form and place them in a certain spot. Is that possible? Dave

I FOUND THE ANSWER!!!! Someone helped me find the right Knowledge Base article. This is simply a bug in Access. To solve it, you simply import all of the items into a new database. I've done it and it works (Thank God!). Here is the Knowledge Base article...