Recent content by galar

I can give you a link: http://www.mvps.org/access/api/api0001.htm I know several ways to make browse button, but this one is the best. If you want, I can explain you about other ways to make browse button if this one is not good for you - just ask.

You deserve a star. I would never come up to this simple and beautiful solution!

Try: Forms(Parent.Name).Controls("subform2").Form.Recordset.findfirst "subform2_Id = " & subform_Id This will work if the subform2 should contain one filtered record that should correspond with subform, otherwise...

I'm a little bit confused. Correct me if I wrong, but it seems that the subForm contains some information about the family and the combo should contain only the kids that are in this family. Ok, the easiest way is to define the RowSource property of the field this way: select child from Children...

Sorry, forgot to put "=" in : me.Filter = "return_date = Date()"

All you need for your form is a filter. The table, which your form is based on should contain a return_date field. This field will be filled automaticly when user enters a new record by the today date if you'll put in the "Default Value" property of the field the Date() function. So...

Been there, done it... with no success. You should create a function that will return the value of this variable: public functon get_Curr_Fy() get_Curr_Fy = Curr_Fy end function and then use it in your Dsum sentense like this...

I hope that thornmastr was right, although I disagree with him. I'm using the same code you've written in many cases and I don't have problems with it. Ususally, this message points on wrong sql statment. Maybe, you're trying to treat text type field as if it was a number type field?

I've defined some keys in the AutoKeys Macro (Access 2000). Usually they work, but on some computers they just refuse to respond. I thought that maybe different version of Access installed already on the computer somehow influence this strange behavour. However, I'm not certain about this. I...

I need to backup my back-end to the A: If the size exeeds the 1.44mb, how do I do this? I'm using the batch file connecting to the WinZip (using command line support) but it's not so comfortable. It must be a better way! Thanks in advance

I have a suggestion. You can put the listBox as dynamictiger described on the form that contains the button and not on the separate form. It'll save you from opening and closing this additional form each time. All you have to do is in the end of the code which inserts new data from the textBox...

First, you have a basic mistake in your code: cboBox.RowSourceType = "Value List" If Not rs.EOF Then Do While Not rs.EOF cboBox.RowSource = cboBox.RowSource & rs.Fields(2) & ";" rs.MoveNext Loop End If When you write it like...

Thanks to all of you for the information provided.

I have a large Application with numerous forms, reports, queryes and modules. And, unfortunately, I'm not near the ending. The question is, does Access application has limits to how much objects it can hold and whether it's size has an influence on the performance? Thanks

I've overcomed this problem when I first opened the Report with the specifyed "where condition" and then executed the OutputTo method. After I close the report.