Search results

[/code] Wow thats great DBDamo, I will try it this afternoon Thanks Rkaria

Thanks David, but they dont log into the database.

Hi I am trying to write the code so when a user deletes a record they get prompt msg box to enter password. I have the below to delete the record but Im not sure how to get a prompt to enter password then if the correct one is entered to delete the record and if it isnt it will say wrong...

Thank you for your time. I used the below and it works a treat :) Private Sub text102_BeforeUpdate(Cancel As Integer) Dim SID As String Dim stLinkCriteria As String Dim rsc As DAO.Recordset Set rsc = Me.RecordsetClone SID = Me.Text102.Value stLinkCriteria = "[claimno]=" & "'" & SID & "'" If...

Thank you for your help, I know its not suppose to be letter by letter, but Im not to great with access, thats why I have posted this thread. what do you mean by the control? THanks again:)

Thank you for that, I have entered the data as I think is right but nothing happens, I can add the data like normal. can you confirm whether I have entered the data correctly below. The Text102 is the name of the field where users input data. warranty is the table name and claimno is the name...

Hi all Does any know the coding to to prevent users entering the same data twice in a field on a form? If they enter the same data I want a warning message saying you can not enter this data as data already exists. Thanks R

Hi All Im trying to edit a report that currently shows the number of warranties that have been claimed. It currently show the total amount for each department. I am now trying to show the total count within each department which of those claims are assigned to a certain fault code. I.E 01A=...