Search results

Thanks for your help. Found the solution by setting Me.FirstFieldofFollowingPage.SetFocus on the On Exit of the last field of the page.

I have a form with 8 pages. I'd like to set it so I can tab tru all the field on the first pages and than to the first field of the second page and so on. I tried to set the cycle in the properties to current pages and current record, but it only tabs through the field of the page that is visible.

To add a new record either add a command button with the appropriate procedure on the on click event. Your query will be updated when you close the form. If you want to update the query when clicking the ADD button again you have to add the Me.Requery to the event procedure. If you want to...

I would appreciate suggestions in handling the following. My db allows the user to enter charges for specific services. The charges for these services change periodically (usually annually). So I have to be able to change the charges when appropriate (e.g. January 1), but the charges for the...

Tried that and it worked. Thanks

That's the way I have it now. Would to see it work with a command button.

In a table (tblProcedures) bound to form (frmProcedures) I have a field called Archive (Yes / No property). The form shows a list of procedures. Clicking on a procedure shows it’s specifics in a couple of textboxes. I would like to set a command button that when clicked would set the property...

Your graph should be bound to a query. Each time you update the table / query the graph automatically should be updated to. About the printing. I have graphs on forms and reports and never have to convert any of time. Difficult to say what you are doing wrong. Maybe some more feedback??

Having these show up multiple times usually means that you don't have the right relationship set.

I never have any problems with creating stakced graphs if applicable. Might have to look at your data to see if they will generate a stacked graph though. Maybe attach a small db and I'll look at it.

Assuming your chart is on a report. Open report in design View Click on the chart itself Click on Chart on the Menu bar Choose chart Type Click on Column in the Chart Type listbox Choose your the stack column display you like in the Chart sub-Type section That should do it Let know if it worked.

John I hope you can solve this. I did about the same and deleted the command buttons and refreshed the form with new ones. It worked for a while, but then the problem started again. Most of my similar setup work well though, but none of them have default settings for a field. I did that with...

Got your e-mail. Replied. Will look at db upon receipt. Marcel

Like to help you. Do me a favor and send me an e-mail without the attachment to the hotmail address and I'll return my alternate e-mail address (don't like to post all of them)

I got the copy of your db. I had a quick look and will check it in more detail later on (gotta go to a meeting). One thing I noticed is that your tables (and subsequent query) have a lot of default values. This might be a problem: when you requery it updates the underlying query / table, but at...

I'm surprised. Unless your attachment (database) is too large it should come over well. Try again. If it does not work because of the attachment send me a short e-mail and I'll reply with an alternate e-mail address.

Try this code on the On Click event of your command button Private Sub CommandName_Click() On Error GoTo Err_CommandName_Click DOCMD.SETWARNINGS FALSE UserResponse = msgbox("Are you sure you wish to delete the current record?", vbYesNo, "Delete?") If UserResponse = vbYes Then...

The reason for my question was because your post states " to requery the next form that opens" Do you want to delete the record, requery and show like the last or first record on the form you have open alreday?

How do you want the new form to open?

A textbox is limited to 255 characters. If you need more space use a memo field. There is code to restrict the size of a memo field if you need to do so.