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 Chriss Miller 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: *

  1. TooGoon

    Help w/ Multiple Filters on Combo Boxes

    Not having read AceMan's code, the way I was thinking of it working: 3 combo boxes: cbo1, cbo2, cbo3 Click on cbo1 (Code filters row source to display all available options: as nothing is selected in the other cbos, every option is displayed). Select option 2. Click on cbo2 (Code filters row...
  2. TooGoon

    Gaaaah! Cannot delete records

    'sup I have a subform which calls a query, which contains to queries tied together by a relationship. Very simple. Very common. BUT, I cannot delete any records in it. The query tells me it is read only. But it is a dynaset, no controls are locked, referential integrity has cascade delete on...
  3. TooGoon

    Help w/ Multiple Filters on Combo Boxes

    Would you consider modifying the contents of each combo box when it is opened, so that it only displays possible options based upon already filtered criteria? I don't have any fancy code for this but attach it to the combo boxes' On Got Focus event and set the combo boxes' recordsource to an...
  4. TooGoon

    recordset.Update extremely slow

    Ok By changing a few things I've been able to bring it down to a minute. But that is still really slow so I'll give these a go. Gracias
  5. TooGoon

    recordset.Update extremely slow

    Anytime I use: Dim rst as recordset Set rst = currentdb.openrecordset(tblName) rst.edit/addnew ... rst.update The operation takes an exponential amount of time. Currently for a table with 600 records in it, with one field being edited, with a small amount of text being inserted, I've been...
  6. TooGoon

    ODBC Error Trapping

    I have the pleasure of working with a distinctly flaky odbc connection. It tends to fail on startup but it also fails randomnly throughout my time operating on the database. So I have two questions: How can I trap any and every ODBC connection failure message and deliver a custom error message...
  7. TooGoon

    Malfunctioning combo boxes

    That didn't turn out to be the problem, but thanks anyway hymn. I had a relationship in the query which was binding the .Origin field to its corresponding table. So everytime i tried to insert the numeric value of the combo box into the field, I was actually trying to overwrite the value in the...
  8. TooGoon

    Malfunctioning combo boxes

    'sup I have a form which has three combo boxes behaving rather mysteriously. The form calls qCourses, which has the fields: instructor, type, and Origin. Each of the fields is a numeric reference to a corresponding record in the tables tblInstructor, tblType, and tblOrigin. The combo boxes are...
  9. TooGoon

    Example HR Training Databases?

    Hi, Does anyone know of some Human Resources Trainging db's that are available for download, or at least just some pics? My boss wants some examples to go on, but google hasn't been particularly helpful.
  10. TooGoon

    spiffing up 2003 dbs?

    nice. Thanks faeryfyrre. But whats with conditional formatting being limited to only 3 optional formats? That's pretty lame.
  11. TooGoon

    spiffing up 2003 dbs?

    Hi, I've finished an overhaul of an old 97 database, but before it is submitted, my boss would like me to investigate the newer 2000-2003 features, and make the db just a bit more shiny for the users. So are there any tricks/tips as far as the UI in the new version of access that you like to...
  12. TooGoon

    Circumventingn exclusive locks

    ok. But would you recommend that if the reports are published several times a day?
  13. TooGoon

    Circumventingn exclusive locks

    My company has several dbs which follow the normal model of being developed and released to the users. However there is a unique and important db which is under constant developement by its owner, and is viewed by several users. So whenever the owner makes a new report, which happens rather...
  14. TooGoon

    Optimizing array comparisons

    A more 'traditional' approach would be to use a class to represent the data and assign the values via the class. Unless the form (design) is changing quite rapidly there is little need to asign the query fields dynamically." I'm sorry, I'm a bit new to this vba thing. Would you mind explaining...
  15. TooGoon

    Optimizing array comparisons

    thankyou for your more efficient code. It works quite well. Unfortunately, it does not make a noticeable change in speed. There are about fifty elements in each area, resulting in 2500 comparisons. Is it possible to remove an element from the array aName once it has been matched? I just tried...
  16. TooGoon

    Optimizing array comparisons

    'sup I am making an unbound entry form. I load all the names of the controls and their assigned values into an array(x, 1), and then load the names of the fields in the query where the record will be created into another field. After a bit of comparison based upon the names of the fields and...
  17. TooGoon

    Unbound Forms and Incrementing through them

    bingo. Thanks
  18. TooGoon

    Unbound Forms and Incrementing through them

    That is, I would like to get the names of the query columns in string form, eg. "ID", "Description
  19. TooGoon

    Unbound Forms and Incrementing through them

    Thanks RoyVidar, that helped quite a bit. Now for just one further question: I'm using Dim db As Database Dim rs As Recordset Set db = CurrentDb Set rs = db.OpenRecordset("Q_MdrData_wLogin") To refer to a query. It works fine. But, what I need is to see the names of each column in the query...
  20. TooGoon

    Unbound Forms and Incrementing through them

    Hi, I'm a bit new to this vba thing, so please bear with me. I'm trying to make an unbound form for data entry only. It will gather the entered information from all the fields in the form and submit it as a new record. I have managed to get this to work. However my method is EXTREMELY...

Part and Inventory Search

Back
Top