Recent content by fipp

I was given some advice by the website mvps.org and I am trying to put it together. I am trying to use a multi select list box as a query parameter. "You can still use a parameterized query provided you pass the entire Where clause to it via code as a parameter. (eg. Have the query reference a...

I have a database that contains information on football games. There are many different games from many different seasons, teams, opponents. I will eventually have a fairly large number of different reports and forms that will want to be viewed but filtered by the above three catagories...

Can you show me how I would add that Wazz? Sorry Wazz, I am a novice to a lot of this. Is there any way you can add it to the code in the original post so I can see how I should do the whole thing? Thanks so much for your help!

I have gotten the following to work with the 2 parameters. DoCmd.OpenForm "reportfiltergameentryfrm", , , "opponent in (" & Me.opponentselected & ") AND season = " & Me.cboseason I am trying to add the following to the parameter? [team]=Me.lstteam [team] and [lstteam] are both text fields...

I have a couple of OLE Objects with microsoft access slides in them. On the slide are drawings. For some reason when I print them in a form or a report the drawing does not show up. You can see the text but not the drawing on the printout. They display in the form and the report with everything...

It works though. It just won't replace a value if there is already one. If there is no value in that field it will put the value in.

I don't receive any messages, the form just closes and it doesn't update the playid field in the gameentryfrm. I can type in a new value on the gameentryfrm in the playid field and that works. It just won't over-ride the pre existing value in the playid field in the gameentryfrm on close. It...

I used the following code in the on close event of my form and it works when the value of [maingameformation.playid] is not previously entered but if there is already a value there it won't overide it? Is this possible to do? Private Sub Form_Close()...

It is for multiple reports.

I appreciate your help I appreciate you taking the time to help me. It will be a major problem solved for me. Thanks again.

Is there any way you can help me with that? I really appreciate your help.

Bob, Thanks so much. That is exactly what I needed. I don't want to push my luck here but is there a way to add to what you just gave me another criteria where the field [run] on the form is not null?

I appreciate your help in advance. I am new to most of this and I need a little assistance. I have searched the web and found some articles etc... I am just not sure how to apply it to mine because I am unfamiliar with some of the wording etc.. I understand a very little of what people are...

I have 2 forms. The first form is called "entry" the second for is called "play" I am trying to open the play form on the click of a button so that it displays the records matching the value set for the [playid] field in both forms. Can anyone help me with the code?