Recent content by rdodge

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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