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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by rdodge

  1. rdodge

    Connection Info in a FE/BE DB Environment

    I know about the user thing, but with the owners being so tight not to mention that's there's a major political thing that has taken place within the IT department, I'm basically stuck with using what I have to work with. To tell the truth, there's a lot of reasons why not to use Access for the...
  2. rdodge

    Connection Info in a FE/BE DB Environment

    If you talking about the LDB file, that file will be the same regardless if it's just one user connected or 100 users connected, so what other lock is there, if any? Can this lock be tested from the server side of the DB application for any one user/login that's connected to the BE DB? Soon...
  3. rdodge

    Linked table performance

    Setting up linked tables is not near as costly as using such things like the IN clause within a SQL statement. There are some very real reasons as to why there would be so many DB files, one, and probably the biggest reason deals specifically with the max size allowed for any one Access DB...
  4. rdodge

    Connection Info in a FE/BE DB Environment

    Given that neither DAO nor ADO coding has fully addressed the need that I have of when a user can go into edit mode, I have decided to use ADO coding with the Optimitic setting on it, and setup a central table to keep track of when users goes into edit mode on what records of what tables...
  5. rdodge

    If formula error

    Cajun brings up a very good point. Wherever you can, it's also best to modulate your code, which then you use parameters (arguments) to pass the necessary data/references to the modulated code. By doing this, it helps in many ways: Only having code in one centralized place Easy to Debug...
  6. rdodge

    I have an 'InList' problem

    AC97 uses DAO by default, so the part where I mentioned about DAO 3.6, that only apply to Access 2000 and later. I wasn't sure on the details of the setup, so that may have also been why it may have been a little confusing as I could only give General type information. Ronald R. Dodge, Jr...
  7. rdodge

    Reverse Engineer Code?

    I'm not so sure about reverse engineering type deal for learning how to work with API's, but here's a link to Windows APIs with a list of a lot of the different API's. However, be aware, some APIs may not work as expected within VBA as the API's are setup to use C/C++ programming...
  8. rdodge

    I have an 'InList' problem

    One way to do this is to create a Cloned recordset like: Dim drsCurRS = Me.RecordsetClone Then use either the Seek Method (Table Type Recordset) or one of the Find Methods (Dynaset or Snapshot Type Recordset) to see if the Batch ID is in the table. In this situation, you would rather use the...
  9. rdodge

    Cannot Auto Update Excel Graphs

    I have data in one set of workbooks, graphs in another workbook, and I use a combination of formulae and VBA coding to update the data from the set of individual workbooks to the main summary workbook. I'm assuming you are currently using Automatic Calculations, of which I do not use Automatic...
  10. rdodge

    If formula error

    Just looking at it from the Excel/Access stand point of view, the first thing that comes to mind is linked tables. Have you worked with linked tablesin Access and create a link to an Excel spreadsheet? As far as the Msgbox box question is concerned, you could put it on a line: before the If...
  11. rdodge

    Compare 3 cells and if equal then return 2 different values

    Had setup the formulae as if you were going to have additional data further down the Data page like how you showed an example of in your first post of this topic, or at least hinted at. However, if that is not what you had in mind, you can do one of the following: Manually convert the formulae...
  12. rdodge

    If formula error

    Given it said &quot;<Out of context>&quot; error message, you can edit the watch directly by remove the CLng() portion of it and then click out of it. By dong that, you can then see if the object itself returns it's value and what type of value it is. If that still shows &quot;<Out of...
  13. rdodge

    Access Form - Label Problem...Am I Losing My Mind?

    That is correct, if a label is attached to a control, it does not have any events associated with it. However, clicking on the attached label has the same effect as clicking on the control that it's attached to. That's how I have my switch board screens setup with Option Buttons within a...
  14. rdodge

    Query criteria - from different forms

    There's a few options you can use. You can setup a global variable and then run the query based on the value of that global variable, provided this isn't going to cause a conflict among the different objects that uses this query. You can setup the RowSource of a Combo/List box as a SQL...
  15. rdodge

    If formula error

    One thing that would normally help with coding for the debugging process, use indentions in an effective manner. Your use of indentions does get started in the right direction, but for nesting statements like 4 levels of If, Then, Else's, look at the following as a general example of what I...
See more

Part and Inventory Search

Back
Top