Search results

Thank you , gays! I'll try! Happy Easter!

Hi, all I have some drop down list. In the list I view only 8 rows. How I can view 24 rows, for example

Ok, and sorry about dummy questions :rolleyes:

Happy New 2010 Year! how to properly? I use procedure to clead fields of form Me!FieldName1 = Nothing Me!FieldName2 = Nothing ..... Me!FieldNameN = Nothing but I can't to use fields after clearing :(

ok, MStef and k.rowinski, thank you, I knew this I was problem with Date and now I resolved it Thank you people!

Thank you, very much! Banana, I try this but is not working too. But, I use JANR's resolution and I have success with Format(Date, "mm\/dd\/yyyy") :):)

Hi, guys, how I can to write condition in SQL statement I have DoCmd.RunSQL SELECT * INTO SomeTable FROM Logs WHERE (((Logs.Date) = " & Date & ")); and Access return me message "syntax error" Why?

HiTechCoach, thank you! I have success :) thank you, thank you, thank you, very much

Hi, guys. It's me again :cool: I have a form with subform and combobox. Record source of combobox is Sql: (SELECT ID, Name FROM [Contacts];). Subform based on Querry, Default view is Datasheet, recordset type is Snapshot. When I choose Name from combobox (I use AfterUpdate event) and...

I try to find in access 2007 .... how to open pop-up form in center of display :o

Thank you, gays! I resolved the mistake with older method - I just added new text boxes :rolleyes: Have a nice day!

I fill data "asd1234" in the filelds trought subform. I save it with button There is code: ""Set dbsTasksMNG = CurrentDb Set rstTasks = dbsTasksMNG.OpenRecordset("Tasks" , dbOpenDynamic, dbAppendOnly, dbOptimistic) With rstTasks .AddNew !Problem = Me!AddProblem !ProblemBG = Me!AddProblemBG...

Ok, I will try to optimize my application (I use link manager yet :)) .... somewhere I read that Access 2007 dosn't support MDE, becausethat I save my work in 2000-2003 format ....... Gays, thank you about your opinions! But is not normally to save some Memo field in table with...

... I'm not sure, but when I write code to Delphi I don't use direct access to table .... and I think that is better to work for the network app;lication Is this a right?

Are you sure? :) you can to access the items of list box by column and row MsgBox Me.myList.Column(1, 1) MsgBox Me.myList.Column(1, 2) .... MsgBox Me.List90.Column(i, j) Or (if I understand you wrongly and the upper idea is not proper!) Your columns property are = 0cm;2cm and you mean that...

You are right. My button make this .... with rstTable !Field1.value = me!textbox1.value !Field2.value = me!textbox2.value !Field3.value = me!textbox3.value end with ....... ......... I know thatt the "wrong" is behaind the keyboard :D

Do you mean about two fileds to show in list box like the picture? :) It is possible if you use Row Source Type as Table/Querry and Row Source as SQL for exapmle "SELECT Products.ProductID, Products.ProductName, Products.UnitPrice FROM Products ORDER BY Products.ProductName;" or Row Source...

Now I have other question. I have form with unbounded textboxes. After filling I save them with button rstTable!Field1.value = me!textbox1.value and etc. When I put data in the fields I have problem with 2 of them. I use some text boxes to fill long text in 4 Memo fields. But in 2 of them...

Thank you, missinglinq I will take note about that! Nave a nice day.

Thank you, Cris! I tried to use "If [Forms]![EditAddTasks]![AddProblem] Is Null Then MsgBox ("Please, enter some data about problem.") ......" but is not waorking .... Thank you again!