Recent content by jimbrooking

Suggest you check the Instr documentation in the online help. The "1" says start with the first character in the string being searched. The string being searched does need to be a string (per the online documentation). You may have to Dim strSomething as String and then set...

Use the Instr function If Instr(1,ActiveChart.ChartTitle,"111") then

Ravi, You can click on my name in any post and "Send a private message". Should be able to include an attachment. Be sure to Compact and Repair, and ZIP the database before uploading it. If you don't have a ZIP/UNZIP tool, my favorite is FreeZip. Jim

Yes, you'd be able to modify any field in any table associated with the form. But you need to think about making up a query that brings all the fields together for the main form (or else different subforms, each of which covers one of the tables). If it's a query make sure it's "updateable" (see...

You might check Access online help under Subforms. A subform whose underlying dataset is tblmaster (with parent and child fields the same auto id field) would change every time the field changed on the parent form. DLookups are VERY resource-intensive, and should be avoided whenever possible...

If the issue is screen real estate, you might consider using the Tab Control to avoid the need for dancing among three open forms. Jim

I have seen this on an ill-behaved database I was working on. You might try creating a blank database and importing all the objects (tables, queries, etc.) from the "bad" database. I assume you've tried compact and repair. I recall one instance of this was cured when I noticed a report with...

Access 2000 help, in my view, was broken in ACC2000 (compared to ACC97). It's much easier for me to find answers on the web than by trying to use online help except when I know exactly what I'm looking for, and the incantation needed to evoke it. For example, VB functions. That's a pretty sad...

ADO Solution Thanks to Pat and FLabrecque for the suggestions. The code Pat posted from Help came close, but I was unable to get it to compile - kept getting a compile error on the .CreateField statement. I finally managed to find an ADO help file on my computer, installed as part of the Access...

I have what I thought would be a pretty simple problem: add a new field to a linked table. The application is a large for-sale database installed at a number of client sites. I was intending to sneak into an update code to check if the field was in the table already using something like...

Thanks GabrielR (And Roger Carlson)! Jim

I think this might be useful to see what's different between two databases, esp. if it looks at queries, forms, reports, etc. So if you'd post the code so we could have a look.... Thanks, Jim

Updating Access I recently went through this issue, and saw Dave's solution as well as a couple of commercial packages. In my case they all had a fatal flaw: somehow you had to be sure you remembered - somehow - to get every last object you changed into the update database. I am, I guess...

Bob- Your function is simple and compact. I wanted to show what I was doing. It's the dormant teacher in me, I guess. Cheers! Jim

Date Math Define a form with two text boxes on it: tbxD and tbxOut. Put the following th tbxD's AfterUpdate event: Dim dDate As Double dDate = CDbl(tbxD) 'Convert date/time to Double dDate = CDbl(CInt(dDate * 96)) / 96 'Take the integer part of the number of...