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.
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...
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...
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.
I'm working with Access 2000. Since I've been exeriencing some problems, I've been directed to download the Service Pack for Access 2000 that should fix several problems.
However, I thought that maybe the easiest solution will be to start working with Office XP, hoping that the bugs that were...
I like Swing too. Slowleness is an important factor, but it does look "cooler" and easier for use. I think I'll go for it.
Thanks to all of you for answering.
Well, I know the advantages of Java on VB, beleive me. It based on a little experiance.
The question was is what better to use when designing the application in Java - the regular GUI or the Swing?
Thanks to all of you.
Ok, I get the idea.
mcowen, I was doing just the same, but it seemed to me that there's another way to do this. Maybe, it's because I'm working with VBA right now and the conseption is very different. I would like to build the same application that I've made in VBA with...
I'm new to Java, so I'll have to ask some stupid quetions in this forum.
This is my first one:
I want to get records from my DB (this one I know how to do) and I need to show them on the screen - here is the problem. How can I make it happen?
For example, I have a Customers table and I want to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.