Search results

Hi, I have a form based on table tblX. I need to update some date on this table openning a recordset and dynamically update the data on the form. Unfortunately I can't change any record on the table since the form is open, recordset.update doesn't work. Do I need to close the form and open...

Hi, I have a union query. I tried to union it whit another query output building a new union query. Although all the fields are matching, I'm receiving "OVERFLOW" error! This is the first time I'm facing this, where am I wrong? What can be the possible causes? Thanks in advance Murat

Thanks Travis, I tried what you wrote, still in trouble! By the way, I'm using ADO. Thanks again murat

Hi, I need to update several records of a recordset depending on the values on a form. I open the Recordset and apply Seek method to find the value I want. When I find it I update the record setting a value to a field. Then when I apply Seek method again and try to set another value to that...

Hi, I inserted the ActiveX control "TreeView" onto my form. But, there is no help about this control. Is it possible to download its help somewhere? Thanks Murat

Hi, Is it possible to change the format, color, etc. of some items in the list box? Thanks in advance Murat

Hi, I've got below piece of code; Dim cr,rd Dim strSQL As String Dim rsa As New ADODB.Recordset Dim cnn As Connection Set cnn = CurrentProject.Connection cr = txtCur rd = txtRateDate strSQL = "select " & cr & " from tblRates where ExchDate=" & "#" & rd & "#" rsa.Open...

Hi, I have a continuous form (myForm) with two text boxes on it (txt1 & txt2). What I need is a sample piece of code to show me how to use FormatConditions with a user defined expression. I'd really appreciate if someone can post a simple sample or let me know where I can find such thing...

Hi, I'm using A2K and developing a desktop application. But recently I faced a problem with one of the forms. When I try to open that form I received an error "CONSTANT EXPRESSION REQUIRED". I've been using that form but didn't get such an error. When I delete On Open procedure the form opens...

Hi, I'm using A2K and developing a desktop application. But recently I faced a problem with one of the forms. When I try to open that form I received an error "CONSTANT EXPRESSION REQUIRED". I've been using that form but didn't get such an error. When I delete On Open procedure the form opens...

Hi Travis, Thanks for your answer. But I couldn't see any code from you to be used on the events which you indicated. Appreciate if you can send send some sample code. Thanks again murat

Hello, I have a continuous form containing two text boxes, txt1 & txt2. What I need to do is to disable txt2 in code depending on the values returned in txt1 i.e., let's say six records returned. For each record where txt1 less than 5, txt2.Enabled is to be set to False. I tried to do...

Hi everybody, I try to open a ADODB recordset writing below lines; rs.Open "select * from tblItems where ItemId In (strList2)", _ cnn, adOpenKeyset, adLockOptimistic, adCmdTableDirect strList2 is a string consisting of concatanating selected Items' ItemData on a...

Hi, I have a multi-user application and want to set AllowByPassKey True or False depending on the login user name. i.e. if the username written in the Login box is not a specific one I don't want this property to be active. How can I write such a code to be executed at startup? Thanx in...

Hi, I have below sub on the click event of a command button on a form which has a query as a Record Source. Dim rst as Recordset set rst = Me.RecordsetClone On the secont line I received " Run Time Error 13 - Type Mismatch " Why can it be? I saw many similar codes in some books... Please...

Hi, I've written below sub. Public Sub Coun() Dim cnn As Connection Dim rs As New ADODB.Recordset Dim r As Integer r = Me!txtRef1 Set cnn = CurrentProject.Connection rs.Open "tblItems", cnn, adOpenKeyset, adLockOptimistic, adCmdTableDirect cnn.BeginTrans...