Recent content by nstratton

I have a form based on a query where the data can be filtered by the AutoNumber ID. What is interesting with this is only certain ones will show data and others pull up blank. The function is to show an expanded view of the entry selected. The only criteria is this AutoNumber so something...

I will pass on that information and see what I get back. It is very possible I put in a sort. The crazy thing about it is the prompt only happens on the export from what I am hearing.

I have a button on a form that exports a query to Excel. When trying to export I get a prompt to enter a parameter value. I'm not entirely sure what would cause this. Everything has been verified as being spelled correctly and past that I am lost. I do not have access to the database and...

The properly configured dropdown is what was tripping me up with this whole thing. So simple a concept just took me forever to get it together

Well I realized I am dull and overlooked something really simple. I'm sure I will have other issues but I am good for now. Thank you everyone for your patience

Maybe it would help if I gave an example of what my project is: I have tblSuppliers, tblSupplierWorkType, tblWorkTypes. The main form is tblSuppliers and the subform will be tblSupplierWorkType. If I leave tblSupplierWorkType as is I get back the ID from tblWorkTypes. So I made a subform out of...

When trying to view the information of the junction table as described above I am getting it to show one record at a time. What I am wanting to happen is to display something like all the CarMakes belonging to 1 customer in a continuous form type of way. I'm not entirely sure how to make this...

Please excuse my ignorance here. I just can't seem to wrap my head around this concept. I'm going to try to explain what I think this all means. I have a "junction" table I want to edit/add/delete data from. I set a form with a record source to this "junction" table. I then create subforms for...

I have a form which I want to use to update data as needed. I keep receiving the notice that the recordset is not updateable. While trying to figure out why I came across this Now unless I am reading this wrong, this says I can make changes to the data on the "many" side without any issues...

Right, I've got that. So are you saying after I add the first category, "save it" via button or whatever then go back and add the next category?

I have a form that allows a user to add new suppliers to the database and add all the relevant information. The suppliers are grouped into categories and sometimes one supplier fits multiple categories. When adding the information, how would do account for the possibility of the supplier being...

This is more of a just curious type of post: Can details be grouped in a form like they can in a report? I have contractors that I am wanting to display based on criteria from an unbound form. There are some contractors that belong to multiple categories and this causes extra records to be...

I appreciate your help. The issue was the order in which I was trying to make everything run. I believe I was trying to group before data was placed into the Pivot Table

I did not think about that. I do not think I can do that since the data only has to be sorted for this one chart. Basically what is happening now is I am taking a query and copying the recordset to a sheet in Excel and then I am applying all these filters and what not to create the other charts...

Correct me if I am wrong in my understanding here: in tblWorkContractorJunction there are not multiple columns for WorkTypeID. Every contractor-work type relation is on a separate row. So the junction table would look something like below. JunctionID ContractorID WorkTypeID 1...