Search results

Hi I have a Subform within a form both in datasheet view. I want to put a code behind it when I click on the Hiearcy + button to close. It seems that the form in data sht view is not closed or unloaded or deactivated but just hidden in this datasheet view or something and my code will not run...

Hi, In my table I want to put a default value of 1/4". Is there a way to do this I have tried "1/4"", '1/4"'. It seems it will not let me use the " symbol for inches. Thanks Bryyan

Hi, I was using Dwayne Hookam Concatenate function I was trying to Concatenate 2 different Tables but I am not sure of the Syntax TestClosure: Concatenate("SELECT DISTINCT [Nde(ClosureWeld) tbl].[ClosureWeldNo] & " * " & [FWelds tbl].[WeldNo] FROM [FWelds tbl] , [Nde(ClosureWeld) tbl]...

Hi, Can some help me. I'm not sure of the syntax I wanted to double click in text box and Add the LastRtgNo + 1 I have this. The way I wrote the [LastRtgNo] + 1 is not right. I tried with a ([LastRtgNo]) + 1 and a few other ways Can't figuire it out Private Sub RtgNo_DblClick(Cancel As...

Hi, Could you please help me. I was looking to use a combo box to filter on a sub form. The form I have is called - DrawingNo(AddDrawingMultiLines) fm. (I know now I should not have used parentheses and a space in my name and I didn't want to change my form name because I would have to do a lot...