Search results

Yes, the option 3 looks nicer as you don't see the #Delete flashing on the form. However, on my continuous form, I use filter directly on it, and many other code, so when using this, I encount that kind of error such as: Record already being deleted, etc.

Hi, I just a simple question regarding deleting a data. I have a listed of record on my continuous form, so I am wondering which will be the safe/better way/quicker to delete record? 1/ CurrentDb.Execute "DELETE FROM tblname" & "WHERE id = " & Me.txtId 2/ DoCmd.SetWarnings...

Why so long code just for a delete action? I have tried tochange the delete code to: RunCommand Delete And I don't have that error anymore. Just wondering if that RunCommand Delete code can harm the process? Thanks

Hi, I have a form set to continuous, and on that form header, I have a : Combobox (to filter the continuous form) Command button (to clear the filter) Command button (to add new record) In the continuous data, there is a command button to delete that selected record. The user has to...

I came into a problem here. By using the recordset only, after deleting the record, and remove the filter, it will prompt the error "No current record", but if I use the recordsetclone, there is no "No current record" error. I had to put back the recordsetclone.

I have tested: But the problem with this is because I have a command button on each record to delete that record, so when the record gets deleted, it will focus me another record, so when i click on that command, it wont delete that current record. Unless I add the bookmark to it. So my...

Hi, I have a form set to continuous, and on the Details bottom part, I have added some field so that if they make changes on those field, it will also update the selected record. Kinda a split form way, but I prefer continuous because of its layout. My concern is, when I filter that continuous...

Hi, I am wondering between 2 way of calculating data, but I Wonder if there is any difference positive vs negative using either way. 1/ Set the Form to Continous Form, and use the "Detail" to load the record, and Footer to edit the record, etc. There will be also Filtering, etc on that...

Lol.. I get it, but by removing the link, the record will not load inside isnt it? OnCurrent then set Child Link then remove?

And how about to not current select a record of the subform2 that is child link to the subform1?

Hi, I have a parent subform on a Form, and when I load the form, the current record in the subform is selected automatically. I have another subform which has the parent link to the Subform 1, and whenever I select a record in that Subform 1, it will cascade data in the subform 2, and the...

The reason I want to prevent its because I has issue before and multi user add simple data to a database. It end up causing error and all the data were replaced by #error. So I lost a lot of data. I dont want to take anymore chances.

For the point 5: I have tested with the user beside me. And they are still able to edit the record, only after the user A leave the record. The User A goes in a record and edit it. The User B goes in a record but dont do anything. The User A changes the record in field 1. He saved. But since the...

About the point 4: With my experience in Access, I always use recordsource because my data needs to be edit. But you mention even in query we can edit the data? I have found on microsoft the following statement: 5. My concern is on a slow LAN, if a usrler make update a on field, then another...

Yes thats the issue. The LAN is quite slow sometimes, so I dont want to take chances. I have made a test with another user at work going to the accdb in the LAN at same time and both us modifying data at once. Its quite slow sometimes. 1/ If I program to audit track all activity on the table...

Hi, I will need to move my old excel to an access because the excel keeps bugging in Shared Mode. The user will have access directly to the table in the Access file accdb. My question is which way is faster: Let all my user access to that accdb in the LAN? Create a frontend that link the...

Oh no, I was just wondering why with ac will take me to record and without doesnt.. More a learning than a solving problem in my question.

acFormEdit will take to the record. Not Add for sure, not Property either..

No its not a number field but text field. Mix number and letter.

Hi, I am wondering why the use of DoCmd with Where condition does not work, unless I add Datamod to it, then it will work? If I use the code below to open a form from a subform, it will not take me to the student id as per sWhereClause: sWhereClause = "[student_id] = """ &...