Recent content by AnnabelleMarie

Sorry, dumb question. I figured out it had to do with using dual monitors (I'm on an undocked laptop now). The dialog box was off the screen, so after changing to a very high resolution, the dialog box was there. No wonder I couldn't figure this out by looking up Crystal specific stuff...

By the way, I am using Crystal Reports XI. Thanks in advance for any help!

I cannot find the answer to this question anywhere! Suddenly Crystal Reports is not displaying the Set DataSource Location dialog box when I select it from the menu. It is almost like it is there but I can't see it because I can't click on anything else and I must hit the escape key to...

I'm sorry I couldn't be of more help. :-( Hopefully someone else will be able to help you.

Try putting the requery statement in the Form_AfterUpdate event. I hope this works.

Try the requery method after updating: frmMyForm.Requery Hope this helps. :-)

I should have said combobox rather than listbox but it works the same as far as accessing the columns. You can also use this same concept to get any other data you need from form 1. Hope this helps. :-)

In the click event on form1 - Add_Customer form: Private Sub OK_Click() docmd.openForm "Add_Customer_Details" end sub In the form load event on form2 - Add_Customer_Details form: Private Sub Form_Load() Dim myCustomerID as integer myCustomerID =...

I'll try to help you some more if you can provide more detail. What do you have working now and what code do you have?

Try this: Err.Raise (-2147467259) Msg = "Error # " & Str(Err.Number) & " was generated by " & Err.Source & Chr(13) & Err.Description MsgBox Msg, , "Error", Err.HelpFile, Err.HelpContext Hope this helps. :-)

I'm not sure how your first form is setup. But one way that I do this is I will have a combobox on form1 with the id as a hidden column. Then from form2, I can get this id and use it in a SQL statement to get the right record on form2. So in form2, you can write: Dim myID as integer myID...

Use single quotes around a string in a SQL statement. "Like ' * '" &[forms]![frmfindstencil]![StencilNumber] & " ' * '));", dbopendynaset) Hope this helps. :-)

Use the Unload statement in your if statement. If you have no records, then unload form. Hope this helps. :-)

It looks like to me that you are only creating one objcontactitem, so it just keeps overwriting the one contact until it gets thru all of the records and then the contact that you are left with is probably the last record. Try putting the line set objcontactitem =...

In the form close event, try this: If A = X then DoCmd.OpenForm "form1" elseif A = Y then DoCmd.OpenForm "form2" elseif A = Z then DoCmd.OpenForm "form3" end if Hope this helps. :-)