Recent content by MattS

Thanks Wayne.

I was hoping somebody could explain how bitwise comparisons work? The following subroutine (written by somebody else!) sets up a shortcut menu. I'm ok with all of this, except the comparison - i.e. (showoption And 1) I do not understand how this could return the true/false value needed to set...

As dcx693 said, using Name isn't good practice. That aside, if Name is a text field (and therefore cboName is text) you need to put apostrophes around it: & "Name = '" & cboName & "'," _ HTH, Matt.

The above may work, or DLookUp may be the answer to your problem. All depends on what you are trying to do...

Thanks for that, but..... I read up on those particular problems, and they were resolved within office 2000 service release 1. We're now on release 2. Oh well, back to the drawing board. Thanks anyway.:)

I have several reports which are e-mailed, in snapshot format, to various people on a weekly basis. I am having problems with one of the reports not being displayed correctly when the recipient opens it in the snapshot viewer. The report in question is landscape but always opens in portrait...

How about: NewString = Left(OldString,8) & Right(OldString,Len(OldString)-9) Do you need to code this? Couldn't it be done with an Update query?

Bullforgs & Blowj*bs A woman went into a store to buy her husband a pet for his birthday. After looking around, she found that all the pets were very expensive. She told the clerk she wanted to buy a pet, but she didn't want to spend a fortune. "Well", said the clerk, "I have a very large...

To be honest, I'm not really sure. The pass-through queries I use were written some time ago, and I don't know (remember!) too much about them. Sorry I couldn't be of any help.

I've checked a couple of the pass-through queries I use (to interegate a Sybase database) and I think you have to add dbo to the table name, i.e. dbo.PROD2_LOAN_HISTORY

I think it's to do with your table structure. I tried to recreate your jpeg with a simple table with 3 fields: Time, Court, and Match. The crosstab from this looks fine.

Rugby......... Johnson, Dallaglio and Wilkinson are standing before God at the throne of Heaven. God looks at them and says "Before granting you a place at my side, I must first ask you what you believe in?" Addressing Johnno first he asks, "what do you believe?" Johnson looks God in the eye...

Is the form bound to a query that's based on the table in question? If so, the fields might be part of the query. Or, there could be a control on the form, such as a list box or combo box, which is bound to the table/query.

I think it's because you've got no join between tblInput and qryRatio.

You need to set the column headings property in the crosstab query.