Search results

I have a table containing a Date/Time field The system date format is "dd-mm-yyyy" A weird thing happends If i am using Now() function to add a date value in the table using SQL, the month and day are inverted Example 1> ' Add 3 consecutive records in "TDJunction" table Dim db2 As...

I have a report based on the following query <CODE> SELECT GeneralLedger.AddDate, GeneralLedger.Inventory_No, GeneralLedger.Title_ID, GeneralLedger.Call_No, GeneralLedger.Media, GeneralLedger.Title, GeneralLedger.Publisher, GeneralLedger.PublishPlace, GeneralLedger.PrintYear...

I have a report with the fields CanGrow property set to yes. The row heigth i set to 0. It dynamically expands vertically to accommodate larger text values, yet the expansion is too large. It doesnt fit the text. Any ideea why and how can I fix this? Thank you.

I have a dropdown menu, Usualy, it is populated by the user by picking a value. In some situations, the dropdown value is populated from annother form, using the code [Forms]![AddTitle_Frm]![Domain1] = Me.Domain [Forms]![AddTitle_Frm]![Domain1].SetFocus [CODE] In this situation, the...

I am using this query to create a table SELECT Titles.Title_ID, Titles.Title, SQLConcRow("SELECT Author.Author_Name FROM Author INNER JOIN TAJunction ON Author.Author_ID = TAJunction.Author_IDFK WHERE TAJunction.Title_IDFK = " & [Titles].[Title_ID],", ") AS AuthorNames...

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

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

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

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

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

Any Ideea where from comes that Grey Bar on the bottom of the from and how can I get rid of it?

Based on a table called "Setting", containing fields "Menu" and "NavPane" as boolean, I want to run an AutoExec macro to show or hide the Nenu and Navigation Pane, I am able to work with the Menu and also to Hide the navigation Pane Anything I tried so far to Unhide the Nav Pane (value set tu...

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.

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

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

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

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

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

I need to take group action on controls on a form, based on their tag Let say, some of them I want to be hidden on load. I will assign them a tag "H" For other, I want them to be disabled. Tag "D" Other set to Null value. So some of them may be similtaneously in more than one group of action...