Search results

Most of the titles are much shorter then 255 characters. Yet, there are authors that are creating gigantesque titles. Well... their book, their title. Anyway, if I add a calculated field that cuts the first 100 characters, combined with publisher, year, and I set the composite to unique, the...

Yes, the title is „long text” I do have title codes and author codes. I may try using that. The ideea is that for a new title i wold like to have some check for duplicates, but not only for the title itself but for all thos variables combined.I am not interested in how often a title can repeat...

I have few fields that ar not unique, but i need the ”sum” of them to be unique. For example, a book title is not unique, the publisher is not unique, the author is not unique, but a book of a given author, edited by a certian publisher in a certain yera must be unique I was thinking to a...

True... I changed it into a function and it works But i discarded it. Messy job Thank you,

Hello World... I have a procedure in a standard module and I want to run it in AutoExec Macro For some reason i don't understand, Access does not recognize the procedure, so the macro fails. I tried to run call the procedure using the Run Code in the macro. The procedure is compiled. Here is...

Actually you have right. I have an autonumber. I remember somebody asking me to remove it :) Yet, it is still there and here is the use of it.

The problem is the risk of having two records in the same second... I know that is quite hard to do it, but you never know

I think i can do that. Actualy, that was my first approach, but I tought that having a Rank field will be a reinforced sollution

I have a continuous subform linked to a query that adds records to a table Here is the code of the query SELECT TAJunction.Title_IDFK, TAJunction.Author_IDFK, TAJunction.Join_ID, Author.Author_Name, TAJunction.Timestamp, TAJunction.Rank FROM Author INNER JOIN TAJunction ON Author.Author_ID =...

I fixed the SOB. Created two textbox controls that based on the Opt. Group takes the extreme values and i used >Control <Control as Criteria, so there are no more IIf statements. Not that much elegant, but it works

Above is the query Works fine for Optvalue = 0 and 2 It returns no result for OptValue = 1 SELECT Titles.Title_ID, Titles.Title, SQLConcRow("SELECT Author.Author_Name FROM Author INNER JOIN TAJunction ON Author.Author_ID = TAJunction.Author_IDFK...

On a form called "SearchTitle_Frm" i set an option gropup called OptGroup, with 3 mutually exclusive opt. buttons, that returns 3 possible values and it is never empty: 0 - for depleted supply 1 - for existing supply 2 - for all items Based on this value, a textbox called OptValue receives...

I have a textbox set to 0.527 cm heigth. Scrollbar: vertical Can Shrink, Can Grow the form is a single form There are 2 issues with the scrollbar 1. The text goes under the scrollbar 2. The scrollbar doesn scroll at all If I double the heigth of the textbox, then everithing works, multiple...

?

Yes... this is working. Thank You

In the criteria field of the query design (without the WHERE condition)

I tried this Like (IIf(IsNull([Forms]![SearchTitle_Frm]![Inventory_No]) Or [Forms]![SearchTitle_Frm]![Inventory_No], "*", ";" & [Forms]![SearchTitle_Frm]![Inventory_No]) &";") Failed to retrieve all records for Null or Empty And also tried yours, with same result

this is not working at all. Same result. Numerical is found, but emty fails to retrieve all

You are right, and not right. Yes, for a user that is fluent on using Acces, it is pretty hard to set fences. Probably for that case an .accdr or even .accde is a bettrer. Yet, for an librarian with minimal knowledge of Access, the bypass is atomic science. Usualy they are doing stuff without...

I have a string Query field with the following structure ;1;14;8;17;62; So they are numbers that are allways sided by semicolons The field will contain at least one number ;n; I need a criteria that based on a control value to return all the records for the case control is Null or empty, or the...