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...
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 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'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. :-)
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.