Recent content by Romio_1968

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

Sorry for the bracketing Yes, I do have a table Titles SELECT DISTINCT Title_ID FROM queryname; Can you please indicate how to do this?

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

Yes it is. I tried both Yes and No to CanShrink.

The issue is that the growing is not limited, but exaggerated.

I did that, as I told you before. I have rows with more then 500 characters, so there is no truncation.

Checked all controls in the row. All are set to heigth 0, and CanGrow = Yes

No. Just checked. I have some records with more then 500 characters and they are displayed corectly. Yet, the cell does not wrap properly .

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.

Thank You. It worked!

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

It worked like you advised. Thank you

Trying to work on that too I have troble in converting the Make Table query into an Update query. I get an error about non updatable query i I dont get a fix yet.

i don't get it. Sorry. Can you provide more info? I have to use Len(SQLConcRow("SELECT Inventory.Inventory_No FROM Inventory WHERE Inventory.Title_IDFK = " & [Titles].[Title_ID],",")) AS Len_InventoryNumbers? Isn't it a new field? What is the use ofit?

Didn't really understood the question, but The source table is Inventory. It contains as many records per Title_IDFK as copyes of the books, in the field named Inventory_No, a numeric field that contains up do 6 characters. The SQLConcRow concatenates all these Inventory_No into InventoryNumbers...