Search results

I have a couple of reports using list boxes that do not show results when the values are null, that is basically why I have set many numeric fields to have a default of 0. After you guys have told me, I think I am just going to move all the records in position 1 to another position, and make 1...

I have a table with an autonumber field and a char field. I have a query that sorts that table by the a character field, and return the key field as well (the autonumber field). I also have a form with a combobox that uses that query as its source, it displays the character field, but saves the...

I created a form in access VBA that sends emails to our clients every month. The form has a textbox that shows the list of all the recipients to which the email was sent. ( a small report). I would like to be able to print that report and save it to a file as a plain .txt file. Could you guide...

KenHigg that was it... I guess I was thinking VB instead of VBA. :D One question though. What difference does it make to type the .text? It would work when the string was small, why?

Guys dont go to deep into what the form does. that does not matter. The fact is that I have an unbound text box in a form. I also have a String type variable which contents I want to assign to that text box. The string is very big, so when I try to assign me.txtErrors.text=strErrorMessage I get...

Rich, the textbox is unbound, it receives a string that contain messages put in there by a loop in vba that inspects the records. When a record can not be updated, another line (a message) is added to the string, stating why that record can not be modified. After running along all the records...

i am filling the text box with vba

Rich, can you tell me a little more? I hadn't hear of a zoom box before....

well, the problem is not the String data type. I just tested that. the problem is that the text property of the textbox can not handle very big strings...

it depends on the selections you make, but it can get as big as 400 lines, and as the db grows, the likely is the string will grow too. I am thinking on creating a little table, and saving the message per record, and then run a report, I just did not want to do that, I would like the user to...

The problem is not that the string does not show. It does, the scrollbar works ok, you can scroll down and see the rest of lines. But when the string is TOO BIG, I get a run time error message telling me that the setting for the property is too long.

Yes, I already did so. The problem is not that the string does not show. When the string is small everything is ok, but if it gets BIGGER, then the text box can not hold it.

Hello all, I have a little problem, hope you can help me. I have a form that selects a recordset, and make some modifications to the db. When it can not modify a record, it saves in a string the record nunmber and the reason why it can not be updated. After the form ends its process, I want to...

Yes my question was aimed towards overloading, I did not select the best example, sorry. In this example the return data type is the same, but I am interested in being able to return different data types, you guys clarified that anyway. Thanks.

yes, I can do that, I was just curious to know it VBA can handle polymorphic functions....

yes, I want to use this function below, so that the intDataToInsert parameter can be either a string or an integer 'Polymorphic version for integer Public Function SetSqlUpdateStatmt(RS As ADODB.Recordset, _ strTableToUpdate As String, _ strFieldToUpdate As String, _ intDataToInsert...

The title says it all. Is it posible? How? I have not been able to find a straight answer and/or example. Thank you guys for any help.

Thanks ChrisO, that is exactly what I wanted. I knew it was not difficult (although it was for me, I could not do it). I am posting the code here, so everyone else can read it. Thanks again. Private Sub Toggle8_Click() MsgBox "The caption of the buton is " &...

well, i just realized that option buttons in access do not have caption, they instread have an associated label, so I need to check for the caption of the associated label of the radio button selected, but even though i know that, i have not been able so solve this...l

ChrisO, I loved your code, the only problem is that the line in red does not work. The method is not supported. I have tried other methods, but can not figure out what to do. Option Explicit Option Compare Text Public Function GetSelectedOptionInFrame(ByRef ctlFrame As Control) As String...