Search results for query: *

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. :-)

I had this problem also. I was going between Access 2000 and Access 2003 which may have created the problem, I don't know. The format function comes from the VBA library. Go to references and see if you have a reference to Visual Basic for Applications. I unchecked this reference and then...

No, I'm in a loop, opening a workbook, updating the range, closing the workbook (and saving). So, there is only at most 2 workbooks open at one time: the main workbook and the one I'm working on. Have any ideas on what I can do? Thanks.

I have an Excel macro that slows down tremendously when I save the changes to a workbook: Workbooks(fileName).Close saveChanges:=True If I do not save the changes (saveChanges:=False), the macro runs pretty fast. But of course, I need to save the changes. I'm opening about 100 workbooks...

I'm sorry chartee but I can't replicate your problem. I went into Access 97 and used the Analyze table in Excel command which automatically put the table columns into Excel. I then inserted 2 blank columns (A&B) and added some data to them. I hid them and then saved the file. After I opened...

Sorry I misunderstood your problem. I'm going to experiment with this and see if I can replicate your problem. Hopefully we'll figure this out! :-)