Search results

Right sorry misread what you wanted, you'll need to add some coding like below to the On Print event of your detail section, Me.nameoftextcontrol below refers to thye text box that holds the value of RSC, Clamp etc If Me.nameoftextcontrol <> 2 Then Me.nameoftextcontrol.Visisble = False End If

Create a query and base your report on the query. Put 2 as your criteria using the Or Lines under RSC, Clamp etc.

At the end of your SQL statement.

You can use indexes to sort the table, again in the design view of the table.

Hi, Open your table in design view and click on Properties, In Order By enter [rank];[name] Sorry scratch that doesn't seem to work.

Create a query with a left outer join between Table A and table B

If I have a form that has a list box of several columns, how do I go about setting a value of a text box in another form to one of the columns in the list box when a user double clicks on the appropriate row? I should say that the value of the text box in the form I want to transfer the record...

Thanks guys, sorting out the spaces has solved it, as there was no space before FROM it wasn't selecting the tables. Also thanks for tthe tip about using the immediate window it helps a lot.

Keith, The error message i'm getting is "Query Input Must Contain At Least One Table or Query " when i click the button to run the query. On the debug it stops at the line starting qdf.SQL = Thanks for that grnzbra I shall amend it tomorrow when I get to work and see if it makes any difference.

Hi, I'm trying my first query on the fly and am getting the above message when I try and build the query. Ive posted the SQL below, can anyone tell me where I'm going wrong? Private Sub Command24_Click() Dim dbsCurrent As Database Dim qdf As QueryDef Dim strSQL As String Set...

You need to requery the other combos following the change in Name using the After Update Event of the Name combo. See http://office.microsoft.com/en-gb/as...730581033.aspx

I think you need an extra field in your table that holds user names to specify whether the users are owners or developers then you could query this field using <> "Developer"

Hi, This has been driving me mad for a day or two now. I have a form which I use to feed a query which is a make table query, I'm wanting it so the user can enter as little or as much criteria as they wish. I've attached a screenshot of the form and query. I can handle the treatment of the...

No, sorry I can't help you with that one. I just use distinct when I have multiple values which is working for you.

Hi, You need to look at cascading combos, this link should help: http://office.microsoft.com/en-gb/assistance/HA011730581033.aspx

I think I know what you want, the way to do it is 1. Create your Roster table in design view 2. Create the query in design view that joins roster and employee tables to be used as the source of your report and also a delete query to clear the records in your roster table after the report has...

Like "*"&[Forms]![Nameofyourform]![Nameofyourtextfield]&"*"

No need to apologise. To create the command button, in your form design click on the ToolBox icon on your toolbar (if its not there you will need to add it using View;Toolbars;Customise) , in toolbox click on Command Button and follow the wizard that pops up (Run Query is under Miscellaneous).

Yes, If I'm understanding you right you want to search several fields using the same criteria. You need to create a form with a text box to enter the criteria and then in your query under each of the fields you want to search on put the criteria [Forms]![Nameofyourform]![Nameofyourtextfield]

Hi I've done this quick but I think this is what you are wanting. A few points: You don't need to have personal details in the Options table if you have them in Attendees. All I've included is the AttendeeId and the options they've selected. I have created a one to may relationship between...