Search results

I would like to be able to use the actual code rather than named queries. Having a lot of named queries clutters up the app. If my install of Access is corrupted I can repair that. But it would be nice if I am still missing something that will make my union queries work. David

Greetings: I have been running a few tests and here is what I have seen. It is odd. (I changed the table name so employee is spelled correct.) In this example I used a field with an identical name in all three tables. The following code does not run with three queries but it does with any two...

Yes; the table is called MasterEmployeee since the very first day I created it. I did notice the typo for some time. The MasterEmployeee table is a stand in table It is in the database application so I can create a demo. It has only fictitious data and only the fields required for the demo...

For example, this union query runs fine: SELECT NonStaffDetail.IncidentID, NonStaffDetail.ID, NonStaffDetail.Witness, NonStaffDetail.Phone, NonStaffDetail.CofirmOtherStatus, NonStaffDetail.FullName FROM NonStaffDetail WHERE (((NonStaffDetail.Witness)=-1)) UNION ALL SELECT...

I thought the fields had to be the same type but not the identical name. I double checked this. If I run any two of the queries using the slightly different field names, the union works fine. It only fails when the third query is added. That is what has me stumped. Is it the case that...

Greetings: I have a union query to pull witnesses to an incident from three main tables for a report. Consumers, employees, and non-staff. Two of the tables are further linked to others. All queries work alone, and any two will form a union, but I get an error message saying the object could...

Brian: I want to take this opportunity to thank you again for sticking with me. I finally got it that when a button opens one subform, the rest of the lines of code for the button ensure that the other subforms are not visible. I now have four subforms opening off the main form. One of...

OK. Got it. I was having two unrelated issues. 1) somehow, the visibility setting for at least one subform kept getting set back to yes so one form opened either over or under the other. That is why I thought I needed another button to Hide them. I must have taken the subform out of the main...

OK I got that. SO, a button can only do one thing: either open the form or close it; Right? If I want the user to be able to close the subform so they could go back and edit a previous screen I should but another button inside the subform to close i; right? Perhaps in the upper right hand...

Thanks. That worked. I know so little about VBA that I did not grasp that when you wrote"_sub" it was part of your form name. I was also putting in too much code. I also did not grasp that the code had to go between the default lines, which are private sub and ant the end, end sub. This is...

Greetings Brian: The procedure you suggested is very close but I cannot quite make it work. I think the reason is the differences between Access versions. I have used 2003, 2007 and 2010 extensively, and one earlier version too, but, quite frankly, I get confused between all the different...

Tnaks. That is what I needed.

Thanks for responding. I tried the button with the subform embedded but it opened another copy of the form. I took the subform out and lost the master child relationship. Your surmise was right on. Some of the subforms are only required when a trigger event is entered in the main form...

I can open a subform with a button but it no longer has the master and child relationships it has when embedded. How do I retain that when using a button to open a subform? Thanks David

Greetings: I just finished a form like this. I took a different approach. I did not use 3 tables; I used two. The first has the respondent ID and the the questionnaire items as fields. The third is the response look-up table. (there could be a unique look-up table for each item.) In...

Thanks again. It worked perfectly the first try.

Thanks so much. I see how it all fits together. I am not sure I will be successful my first try. I also see that what I feared was an unusual issue is a standard issue. Therefore it should be covered in a good Access text such as the Access Bible. Thanks again.

thanks so much. I will try this in the AM david

Thanks. I have been to that screen. If the ID number is not already present in both tables, it does not seem to work for me. What am I missing? If I have the field name for the ID in both tables does what you suggested automatically enter the Id from the main table in the sub-table? Sorry...

Thanks. This is what I am trying to do? '... link the subforms with the main form by use of the subform control's MASTER/CHILD property the subform control's properties.' I can't quite figure out how to do that. David