Search results

I have a database with two tables, Buyer and Products, with one-to-many relationship. The key of Buyer is an autonumber ID, which is the foreign key to table Products. The problem is that i have two copies of this database with different records (with ID starting from 1 to each one) and i want...

I'm looking for methods to verify if an application is working correclty. Any suggestions? Thank you in advance.

Thanks everyone for the help :) I'm sorry for not having your experience and my english are not that good. Thanks for trying to help me though, next time i'll try to be more specific.

i think you didn't understand what i'm trying to do. On a field property i have a vba function that checks if that field already exists in another table. If it does, then i want to clear all the fields of the current record.

I want to clear the fields for a new record to be added

Can i clear all the form's fields without assign null value to each on seperately. (something like delete current record) Thank you in advance!

I found the error.I should had the code at afterUpdate property instead of beforeUpdate. Thanks for trying to help me:)

ID is allowed a value of null. The form is bound to table APPLICATION where ID is a member of APPLICATION.

I have the following code as a property to a field(beforeUpdate) Private Sub ID_BeforeUpdate(Cancel As Integer) Dim strSQL As String Dim rs As DAO.Recordset strSQL = "SELECT * FROM RETIREMENT " & _ "WHERE [ID] = " & Me.ID & ""...

That work thanks! :) Any ideas why that happened?

Hello all, I try to delete a record and i get this error message "The search key was not found in any record". The key of the table is an autonumber but for some reason in these two records i want to delete has value = 0 . Any suggestion how to delete these two records? Thank you in advance!

Ok both ways worked! Thank you both :)

Hello all, How can i get the records of a form based on a field ascending order (not the primary key), when i open it? Thank you in advance.

The Record Locking is set to "No Locks" but i still have the same problem. ...and as the records getting more the database locks more often. I don't know what else to try. If it helps most of the times the database locks when they are trying to insert a value from a particular combo box which...

I have a database with 10 users accessing it. Even though the database is in share mode they get this message "Error 3218 Could not update; currently locked." when they are trying to write a new record. Any ideas how to fix the problem? thank you in advace!

i used a total query with the avg fuction and works ok thanks, but i have a question. I know i shouldn't store calculated values, but what's happening if i want to group my records based on the calculated values?

thanks that works fine:)

Hello all, I have 5 check boxes on a form and one of them must be checked in order to get the correct result. If the user does not check any of the the five checkboxes he gets a msgbox telling him that he must checks one of the checkboxes. What i want to ask is if is possible to prevent the...

the problem is on the while loop. Even though i have more than one records with the same recordId i only get one record at the recordset. any ideas what's wrong with the while loop?

Hello all, this is the code i have on beforeUpdate property of a form (record source of the form is a table called tblApplicant). Private Sub Form_BeforeUpdate(Cancel As Integer) Dim strSQL As String Dim rs As DAO.Recordset strSQL = "SELECT * FROM tblGrades " & _...