Search results

I have 3 tables. tbl_Notary RefNo Name Surname tbl_Volumes VolID RefNo Volume tbl_Contracts ContractID Date Folios ContractTypeID Party1ID Party2ID VolumeID tbl_Notary has a 1 to many relationship with tbl_Volumes with the ID RefNo. tbl_Volumes has a 1 to many relationship with...

I have the following sql statement and I cannot get the value saved in the variable title which is of type String. Any help please? strSQL = "SELECT [Title], [ContractNo] FROM [tblActInfo] WHERE ((([Title] Is Null) or ([ContractNo] Is Null)) Or (([Title] Like ' * & title & * ') or...

Hi, I am planning to have a form that acts as a query to search my table. I was thinking of doing the multiple fields and give the option to search by one or multiple fields along with the option to choose whether they want an AND criteria or an OR criteria. Ex: Search by name and surname...

How can I check if a txtField in a form is not equal to a word? I am assuming i cannot use <>

Hi, I have imported an excel sheet in a table, with one of the fields with dates in the format such as 19th December 1803. Apparently, I cannot use any functions in excel to format the date as a date field instead of a text field in excel. Is there a way on access?

I am trying another insert statement sql = "INSERT INTO tblCaseInfo(NotaryRefNo, Volume, Title, ContractNo, DateOfCreation, Description, Subject Terms, Page/Folio, Language1, Language2, Language3, PlaceOfCreationNo, TypeOfContractNo)" & _ "VALUES(" & refNo & "," & Volume & ", " &...

Why is this SQL code giving me an SQL error? I am still getting used to the delimeters...it is really confusing me sql = "INSERT INTO tblNotaryIndex(NotaryRefNo, Volume, [Date Start], [Date End], ShelfID) " & _ "VALUES(" & refNo & "," & volume & ",'" & Format(dateStart...

I have 2 tables: tblNotaries: NotaryRefNo (PK), NotaryName, NotarySurname, etc.. tblNotaryIndex: NotaryRefNo, Volume (Composite Key), etc... I am trying to create a form where one selects the Notary name and surname being populated from tblNotaries and then the according volumes are shown to...

Hi, I went one step forward and one step backward with my code. The code is working fine now in the sense that when I insert a new record this is inputted in the table. I have a compound primary key of a refNo and a volume. When a duplicate record is inputted, the table is not updated as it...

I have a form from which I want to save the details entered. I have coded a save button but somehow it is giving me a syntax error and I cannot seem to find it. Any help? I am a newbie so bare with me Private Sub btnSave_Click() CurrentDb.Execute "INSERT INTO tblNotaryIndex(NotaryRefNo...

Hi, I am new to normalization and I am trying to work out this questions. First one MemberID MemberName SportID SportName CoachID CoachName M123 White S12 Judo C02 Cassar M123 White S14 Karate C09 Delia...