Recent content by James Deckert

Try eliminating part of it by running UPDATE TBL_DocReview_SingleStudy INNER JOIN TBL_LOA ON TBL_LOA.MemberName = TBL_DocReview_SingleStudy.Member SET TBL_DocReview_SingleStudy.DateLOA2 = TBL_LOA.Status in the query builder (after copying your db first - OF COURSE) and see if this query gives...

Sounds like jjake wants a sum, not a count. Use the Totals button on the ribbon and only include the value field in the query and you'll get a total. Same as what Alc suggested, but using Sum instead of Count. So Select Sum(field to sum) from QryShowingNullFieldRecords

you can reference an open form like so. Forms![formName]!formcontrol

I created a new video to speed up my presentation, so deleted the old one. Here is the new one. https://www.youtube.com/watch?v=nJXqMJC60oY

I made a youtube video for combobox lookups. If you need more help than what arnelgp has, here is the link to show you how to edit the query behind the combobox. https://www.youtube.com/watch?v=nJXqMJC60oY

How is the .txt file formatted? Can you show a piece of it?

I think you'll need to supply the data layout for the tables involved in the form/subform you are having a problem with. Also supply the 'link master/child Fields' properties for the subform. A pic of this form might be helpful also.

Thanks Boyd for the feedback on crossposting. I regularly look at 4 different Access forums and had posted at the other with no response for a couple of hours, so decided to try here also. I should have included my original link :( I knew to mark the thread solved. It is frustrating to be...

Thanks Boyd, The problem was not with any code. I narrowed the problem down to something in one of 4 tables. But if I create a new db and import all objects, then import the 4 tables, this seems to fix the problem.

I'm trying to implement the J Street Relinker on a db which has just been split into FE/BE. I've used the relinker on another db and I don't think the problem is the relinker. If I rename the BE, then when loading the FE, I get the Access attached screen as if no db was loaded. If I select the...

I don't think so. Each control name must be unique,therefore each will have its own on_click. You can make each call a common function so you don't have to write 100 routines if they all do the same thing.

Maybe if you included a screen shot I'd understand what you're talking about, because I don't understand what is different from you explanation and my previous post. The way a combobox record lookup can work is to select the item you want to display on the main form, and a subform will...

I typed http://www.imdb.com/find?q=127%20hours on the url line of the browser and it worked, but it gave me several choices. Spaces are normally converted to %20 in this kind of thing. Stop the code in debug on the followhyperlink and look at searchterm. Copy and paste it into browser and see if...

How do you know if a record is appended or not?

If you create the form and subform at the same time when using the Form Wizard, the subform will only show records related to the master form. So the combobox lookup should filter the subform automatically. This has to do the the "link master fields" and "link child fields" property of the subform.