Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: galar
  • Order by date
  1. galar

    How to make a browse button

    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.
  2. galar

    Alternative background colour on report listing

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

    Unable to automatically refresh subform!

    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...
  4. galar

    combo box filter

    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...
  5. galar

    form is continuous until next day then new records?

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

    form is continuous until next day then new records?

    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...
  7. galar

    Dsum Function In A Report

    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...
  8. galar

    How to set RecordSource property on the fly?

    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?
  9. galar

    AutoKeys Macro

    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...
  10. galar

    Archiving/Back up of an access database

    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
  11. galar

    List box

    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...
  12. galar

    combobox property

    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...
  13. galar

    Does the size counts?

    Thanks to all of you for the information provided.
  14. galar

    Does the size counts?

    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
  15. galar

    Export problem pls read...

    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.
  16. galar

    For those who tryed Office XP

    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...
  17. galar

    A question

    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.
  18. galar

    A question

    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?
  19. galar

    A question

    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...
  20. galar

    A question

    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...
    • galar
    • Thread
    • Replies: 10
    • Forum: Java

Part and Inventory Search

Back
Top