Search results

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.

If a client is only ever with one professional, or wth a GP practice, then use criteria like Stuart suggested: Where (Inp_To Is Null) OR (STF_Code Like "GP*")

You need another loop in there. For each item selected in the first list box, you then need to loop through the whole of the second listbox until you find the matching member of staff to select.

You'll have to take the criteria statement out of the openform command. You could try something like the following in the on_open event of frmDetails: DoCmd.GoToRecord ,, acFirst Do Until txtThingID = forms!YourForm!Combo1 DoCmd.GoToRecord ,, acNext Loop

The two surgeries being dropped, "Petersgate Medical Centre - Scawthorpe" & "The Nelson Practice - Scawthorpe", only have referral dates of 1st April 2003 - therefore they are not null, and not referred in the last 3 months.

I would probably do this in code. Have a combo box listing all the possible source tables, and then put some code behind a command button. Something like: Dim strSQL As String strSQL = "SELECT field1, field2, field3 INTO tblYourNewTable FROM " & combobox.value DoCmd.RunSQL strSQL