Search results

I found it. The Select should have said EducationResources.ID (instead of ResourceName). I also added a Me.Recalc so that the newly added records would show in the form. ~RLG

I am doing something similar so I would like to jump on this thread. I created this SQL stmt and put it on the On Click event of the button: DoCmd.RunSQL "INSERT INTO NavigatorInfoBreast " _ & "(PatientID, EducationResourceID) " _ & "SELECT Patient.ID, EducationResources.ResourceName "...

I'm jumping on this thread because I am needing to do something similar (or sounds like it at least). I created a query: SELECT ReferralCategory.ReferralCategory, Count(PatReferralTo.ReferralCategoryID) AS CountOfReferralCategoryID FROM ReferralType INNER JOIN (ReferralCategory...

Hi Guus, Thanks for your reply. I kinda thought that, based on the error message, that there were two different versions but I am running Access 2007 and these samples are from the Access 2007 Inside Out book so that just didn't make sense. I think the main problem is that there is a default...

Hi, I have downloaded some sample files from the Microsoft Inside Out book. My employer does not allow us access to our c:\ so I had to put the db on my assigned network drive. When I open the db, I get messages about broken or missing references to dll files and then a message about VB...

Hello Galaxiom, That is exactly what I needed to hear. Thanks so much! ~RLG

Hi, I inherited a database that has a ton of tables, some forms and some reports. The original programmer did not use the typical naming conventions for any of these so I have a table called FollowUp, a form called FollowUp and a report called FollowUp (as an example). I would like to change...

I have been modifying an inherited database. It has lots of tables that are connected every which way. I want to remove a couple of fields from a table but get an error because those fields are linked to other tables. When I display Relationships, it is a maze of lines all over the place. Can...

Hi MStef, I am interested in your DemoFind. However, I am working in Access 2007 and it doesn't like the STR function. I am a newbie to Access and don't know what the replacement would be in Access 2007. Could you help me here? Thanks so much! ~RLG

I figured out the sfmList issue. It is the name of the subform on the Main form and is populated with one of two forms. Al-righty-o! Keep on digging :D. ~RLG

Thank you for your great explanation. I am working in Access 2007. What version are you in? I couldn't follow the steps you outlined for setting up a query based on a form. I looked in my two books and couldn't find anything about it for Access 2007. So I am still trying to figure out that...

Hi JANR ~ I figured out some of my problem. First, the diagnostic table this form is updating had the field DiagnosticType instead of the DiagTypeID. Secondly, the DiagTypeToolsXref table had the DiagTypeID and the DiagToolID fields as Text instead of Number. So with those to problems fixed it...

I'm still stuck on this issue. Does anybody have other suggestions to try? Do you need any more information? Thanks so much! ~RLG

Good morning JANR, I did look at the link (and thanks btw for sending that; it, plus other pages on that site, look very helpful!). Here is what the Where clause now looks like: WHERE (((DiagTypeToolsXref.DiagToolID)=[Forms]![Patient]![sfrmDiagBreast].[Form]![DiagnosticTools].[ID])) But I...

Hi JANR, Thanks for taking the time to look at my question and finding my OOPS. I made that correction. Unfortunately, it still doesn't work. I'm still missing something. BTW - I am trying to reference a control on the subform, from the subform, not the main form. ~RLG

I would like to jump on this thread because I have a similar situation. I am trying to have the values displayed in field DiagnosticType (combobox) driven by what has been selected in the field DiagnosticTool (also a combobox). Here is the select stmt on the DiagnosticType field: SELECT...

Got-cha. I added that in and it works great now. Thanks so much! ~RLG

Thank you! That was easy. At least putting on the subform :). But I ran into a snag when I tried to update the links. I clicked on the Link Master Fields and it displayed this message: I clicked OK and the Subform Field Linker window popped up. Under the Master Fields I pressed the drop-down...

I need to remove a subform from the main form so that I can replace it with a new one. How do I do that? I don't want to delete the old subform just yet in case I need it later. TIA! ~RLG

Okey dokey! Got it. Thanks! ~RLG