Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rider99

    Split function in VBA

    I received "Invalid precedure call or argument" when I tried to call Split function in Access VBA. Some users receive such error message and some don't. What kind of file is missing on those PC? Help!!!
  2. rider99

    Split function in VBA

    I received "Invalid precedure call or argument" when I tried to call Split function in Access VBA. Some users receive such error message and some don't. What kind of file is missing on those PC? Help!!!
  3. rider99

    open crystal report from Access 2000

    Thank you. That is all I need at the moment. BTW, why is it a good thing that Access can't handle ocx?
  4. rider99

    open crystal report from Access 2000

    I am very new to Crystal report, just got it today. Can anybody teach me how to open up a crystal report from Access. I tried to insert an Active X object into a new form, but it didn't ask me where the object should come from, ect. It is just blank there. Also available Active X object in my...
  5. rider99

    Refresh subform

    You made a great point here, that I am trying to edit a table behind the form while I am having the bounded form open. So I just made a change. I close the form before I call that function: Call updateRecord("premium", "1",temp_fromDate, temp_toDate) after that I open the...
  6. rider99

    Refresh subform

    Thank you for the reply. But I think the problem is more than that.(sorry to confuse you). 1. The button on the subform will go out and update the table underneath that subform. Here is the code for clicking the button: Private Sub cmdpremimupdate_Click()...
  7. rider99

    Refresh subform

    I have a bug on my subform. The main form is called [frmgroup] and the subform is called[subform], they are linked by group_No. There are three filed on the subform. When I click a button on the subform, it will go to another table, look up some data based on valuesin field 1 and 2,then update...
  8. rider99

    Save a recordset in Access 2000

    Fabulous!! Problem solved. I checked Q182867 and realized that the problem is in the data type. I have two fields with data type"Memo" in the table that underneath the form, OLE or MEMO data type are long value column, the jet engine attempts to read the long value page when reading...
  9. rider99

    Save a recordset in Access 2000

    Thanks for the answer. We are tackling the right area, but I have a few questions: 1. Why can Access 97 handle this, and 2000 can't? 2. If I put Me.dirty=false. The record will be automatically saved? 3. The other thing I forgot to mention is that the record was saved although I got that error...
  10. rider99

    Save a recordset in Access 2000

    Hi, After converting our DB from MS Access 97 to 2000, I encountered an error message whenever I tried to save a brand new record. The error message is" The Jet database engine stopped the process, because you and another user are attempting to change the same data at the same time.&quot...

Part and Inventory Search

Back
Top