Search results for query: *

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!!!

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!!!

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

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

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

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

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

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

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

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