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

yes please it would be my pleasure...that would really really help

Sorry ignore my previous post...I realised I was writing the integer value incorrect in the sql...however I still think that the title is written wrongly as it is giving me wrong results. I outputted the sql and I attached it below. I think the sql should read: Like "*" & "cattle" & "*" How can...

I think the syntax is good now but the result that I am getting is all the records...I entered only the contractNo expected that I am searching by contractNo and the title field is blank I will get the equality of the contractNo...this is how the query looks in the design view. Am I missing...

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

I wasn't sure if <> works with text that's why! :) Thanks

I mean text ex: Me.txtField <> "Fish"

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

Thanks so much...so those commands I assume I should insert them in VBA code. I am working on an archiving database, that is why I have dates that are so old

Unfortunately all the dates in my excel sheet are pre 1900...most of them are in the beginning of 1800

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?

Still Syntax error on the Currentdb.execute...this is how my sql looks like now: sql = "INSERT INTO tblCaseInfo(NotaryRefNo, Volume, Title, ContractNo, DateOfCreation, Description, Subject Terms, Page/Folio, Language1, Language2, Language3, PlaceOfCreationNo, TypeOfContractNo)" & _...

I did the quotes as I mentioned above but nothing :( it's driving me crazy!

Included quotes but still getting a syntax error sql = "INSERT INTO tblCaseInfo(NotaryRefNo, Volume, Title, ContractNo, DateOfCreation, Description, Subject Terms, Page/Folio, Language1, Language2, Language3, PlaceOfCreationNo, TypeOfContractNo)" & _ " VALUES('" & refNo & "'," &...

1-3 is text yes I have amended the sql as follows: sql = "INSERT INTO tblCaseInfo(NotaryRefNo, Volume, Title, ContractNo, DateOfCreation, Description, Subject Terms, Page/Folio, Language1, Language2, Language3, PlaceOfCreationNo, TypeOfContractNo)" & _ " VALUES(" & refNo & "," &...

I am posting the whole code of the sub below: Private Sub btnSave_Click() Dim refNo As String Dim Volume As Integer Dim Title As String Dim ContractNo As Integer Dim PlaceOfCreationNo As Integer Dim DateOfCreation As Date Dim Description As String Dim subjTerms As...

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 & ", " &...

The dates are date types...It used to work until I put the shelfId which is the last type...it is a number type

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