Recent content by jwindon

Chris, I've written a little VB procedure that will do what you need to do. It runs an update query when the report is activated and sets a text field for each record to the ranges you are looking for. I will send it to you. Jackie

Thanks Rich.

Is there a way to refer to a PREVIOUS record's control on a report?

Doc Man, That was my initial thought. (refreshing) Forgive my ignorance, but just how would I do that? Thanks.

Hi all! I have a little something funky going on with this. The command works to send information from a command button on a form. It works fine the first time I use it, but the next time I use it, I hit the command button and nothing happens. Is there some kind of refreshing that needs to take...

Can't help you with the code, but I could suggest creating linked tables and perhaps importing a copy of the form or report from the other database.

You stated the problem was that the viewers were being confused by the record number showing and the key field number showing. MY suggestion addresses that issue alone. It does not lead you to hide the navigation bar. If you want to go this route, then I would hide the navagation bar and create...

A yes/no dialogue box is created thru vba. To make a dialog box with yes/no: Where you would assign a macro to an event, right click on the build button and select code builder. Between you lines put: Dim UserResponse As Integer UserResponse = MsgBox("Your message here!", vbYesNo, "YOUR...

Rather than making custom navagation buttons, consider HIDING the record number field. Set its property to visible: no

If you must use a macro (for whatever reason), use the SetValue action. Run the macro on the OnClick event of your command button. Have a good day!

Don't know what you are doing exactly, but the ASK field may be what you are looking for. Look at fields and functions of those fields.

If these text boxes are bound to the same table that contains the information that is pulled by the combo, then yes, if you update them, the underlying table will be changed. If you are using just that piece of a combo to fill in one value to another underlying source, you could consider using...

You need to bring the NAME field into a query and sort that ascending then base your report off that query and the selection you made on your form. That would mean bringing the table that contains the names into the query grid. Hope that helps.

I see what you are needing to do here. I had the same problem last fall and Pat Hartman was kind enough to guide me thru this. Best I can explain is that you need to have an event on your main form, that runs an append query to the table that contains both the categories and their respective...

Consider putting a command button on your form that will "FIND" using a query. The command button should be set to run this query. In your query, set your criteria under the Surname (for customers) to Like([Enter Surname]). This is a quick way to do it. You may wish to consider other find...