Search results

Is there any way to crete a Compact & Repair button and a module or macro to execute? The user will not have access to Ribbon and nav Pane, so that's why the need.

Yes... that was it. Checked for Me.Control.Textx and the custom behavior comes up. Thank You

Tried... no change The very first key is entered, the default error handler is triggered and any other action is canceled. On form level is not set an errorhandler

I have an unbound textbox, with format set to 'General Number', no decimals. When a non numerical key is entered, the default error message pops up: "the value you entered isn't valid for this field" To prohibit user for entering such values, i set an On Change event for the control Private...

Probably you noticed that it poped into my mind that reports are a better way to do it. The funny part is that the topic was about mousewheel and navigation buttons. Only one pertinet answer until now. "Don't use unbound controls on subforms" On the other hand, assuming that I am crossing the...

Thank You. I am changing a bit the approach. Yet, that mouse wheel stuff is quite a nuissance :). I removed the scrollbar property, so the problem does not exist anymore. (Yet, is down there, in the shadows, waiting...)

ebs ebs17 I didn't know that is a place reserve for extra, ultra, mega, maxi professionals. If so, please receive my apologies for disturbing the sacred silence of the Ivory Tower where only grand wizards are levitating on clouds of knowledge and wisdom, and the newbies are only allowed to...

That is easy stuff... I used it in some Title-Domain related operations. But here are returned 3 sets of records for a title with 3 domains. If I add the Author_Name as criteria, it will multiply the records by the number of authors per title. Adding Inventory_No, will multiply again. So, imagin...

Yeah... Doesn't make too much sense, I know. Yet, that subform should "present" data in a compact and recogizable way and I didn.t found a way to "Group" the record in a query and doing text opperatins. I know that the meaning of form is not for presentation, but for working on data, yet I...

arnelgp, you mean Form_Current()? Ity is in Form_Current() First record Second record by clicking the navigation button: The same second record, but on scrollbar On screen is the 2nd record data, except the mess from lower three rows. The numbers are ok, as in query reuslt, but the...

Hello, I have an Continuous subform linked to the following Query SELECT Titles.Title_ID, Titles.Title, SQLConcatenate("SELECT Author.Author_Name FROM Author INNER JOIN TAJunction ON Author.Author_ID = TAJunction.Author_IDFK...

Noted and answered. Thank you.

Pat, you are right. Record_ID does not have a obvious reason to exist. The most important key is Title_ID. It is unique and hanndled by code, not by user. There is still something. The Title_ID is a little bit "cleaner", at least on the last record. He take it's value on an +1 increment, so if...

Holly ... It actually works So SQLListe does the concatenation of the fields in two separate subQueryes. Then you have a simple query based on a Titles table, with the concatenated strings as calculated fields. What a charm! Thank you

I have the following table structure and relationships I created a query that extracts data from the above tables. The SQL code for this Query is: SELECT Titles.Title_ID, Titles.Title, Author.Author_Name, Inventory.Inventory_No FROM (Titles INNER JOIN Inventory ON Titles.Title_ID =...

I posted above the solution in the "RESOLUTION" part, with alterations of the initial joins. There was the issue. Still a many to many, yet different. Thank you

Hello, I have the following tables about a book library One title can have many authors. One author can write many titles. A Many-To-Many relationship is set using TAJunction tables. This table is used to achieve the relationship between table "Titles" and "Authors", using joins betwen...

I don't know how it is supposed to work but it doesn't. And moreover, it falls into runtime error

Is there any way to search for matches inside the row source of a combo based 'Like *something*'? To be more clear: Let say I have some strings in the combo row source, The default behavior is to search as you type from the begining of the string. I wonder if I can change this behavior. For...

Yes... It works and it is updated in the original post. Thank You