Replies

I’m guessing you put the image on your report as an unbound object frame? Trying putting it in as an Image control instead. At least that’s the control type in Access97.

This is 1 way. Create a new table which contains 30 records numbered 1-30. Join this table with the table containing data you want to print. Since they are unrelated, you get what is called a Cartesian join; that is, you get 30 records for each record in your original table.

I’m not sure this is what you are looking for, but DatabaseCreations has a utility for updating a database. The are at http://www.databasecreations.com

I haven’t used it myself, but it sounds like the Treeview control would do what you want. It is an ActiveX control that is on the “More Controls” button on the toolbox.

None that I can find! If it is really necessary, I’d advise you to just convert to a continuous form and put your labels in the form header.

From your description, it appears that you are trying to update the inventory record before you have written your order record. I’d try making sure that was done before the update.

Another approach is to avoid the update of the inventory record. Instead, use a query which detects which inventory records to not have a matching order record (which indicates it was sold). The UnMatched Query wizard will help you create such a query. The additional benefit is that this will mean your database is more normalized, and reduce risk of update problems.

I generally do it this way:
With Forms!MainFormName!subformControlName.Form
.recordsetclone.movefirst
.bookmark = .recordsetclone.bookmark
end with

If your only intention is merely to detect that you are on some other page other than Page 1, then you can use the Me.PageNo property. For example, create a label (lblContinued) in Page Header and set its caption to “Continued from prior page”. Your code to make it appear on pages 2+ would be:
lblContinued.visible = (Me.PageNo > 1)

How about: RunCommand acCmdRemoveFilterSort

Never tried it myself, and I don’t know if it just removes the Sort or the Filter & Sort.

I have found the WillContinue and HasContinued properties to be a bit of a pain. They are really only useful if you have a report in which the detail section is quite long, and it might continue on another page. Don’t confuse this with the typical situation in most reports in which you have a detail section that is only 1 line high. So, if your report recordset is 80 records, you will print the detail section 80 times. But the WillContinue/HasContinued will only kick-in if any particular detail prints on 2 pages. If 1 detail line finishes exactly at the bottom of the page, the next detail will start at the top of the next page, so no WillContinue/HasContinued flags will be set! I found it easier to use the pageno property. If I’m on page 2, then I know the report was continued!

I don’t think Me.Detail will work. You need to use Me.Section(0).

Could you supply more details? Are you selecting frmINvoices from the database window, or are you making a selection on a form? If the latter, maybe you could post the code. It sounds like you are trying to reference a control on frmINvoices, but frmINvoices is not open. (Note the difference between a form merely existing and actually being opened. An opened form is the the Forms collection.)

There is a difference between blank and null (no entry). Check your field properties in your table, and make sure the Allow Zero Byte string is set to False (and required is set to True). Also, you combo box can be set to “LimitToList=True”.

Try dropping the Me!, it doesn’t seem to work well in reports.

If you’ve made the field Required in your table, then you should not be able to move off the record (which causes an immediate update for a bound form) if nothing has been selected. Are you trying to prevent them from leaving that field without making a selection? I would advise against that. You can also put in code in your form’s BeforeUpdate event. Check that field for IsNull, if true, then set “Cancel=True” and “Exit Sub”.