Search results

Is it possible to allow AutoFilter arrows to only show up on two columns. I only want people to be able to filter columns E & G of a worksheet, but it seems like I can AutoFilter either one column or all of the columns. Is there code that could do this for me?

Okay, so one more question. I have a list of branch/plants that need to be EXCLUDED from the drop down list. On the query built to match the branch/plant to items, I created a criteria which filters out the listed branch/plants. Unfortunately, it doesn't work, it just starts duplicating the...

Ah, gotcha. Thank you!

What code should I use? The below code I wrote doesn't seem to work, but perhaps I'm going about it all wrong: Private Sub Plant_AfterUpdate() Forms![Placard generation table1].Requery End Sub

I have a form in which there is a dropdown for Branch/Plant locations. Upon selection of a branch/plant, the dropdown below that populates with all the items available at that branch/plant. The problem I am encountering is that if someone chooses the wrong branch/plant from the list, the item...

Unless there's a better way of doing this... I have one table that uses a query to match up to another table to generate labels in a report. I used the Microsoft report label generator function in Access to come up with the formatting of the label sheets I need. The thing is, I can't find a...

So I actually have this odd need to CREATE duplicates in a table. Accidental duplicates were always a problem, but intentionally creating them is quite another thing. I have a table, and the first record of the table needs to be duplicated 30 times. How would I go about writing a query to...

Well, I'm not exactly sure what is easiest. Basically, there are various fields in the form. I've attached a picture of the form. The first item (Select Plant combo box) refers to a list of our plants in one particular table. The second item (Select item combo box) refers to a list of all...

How do I make my form fields add new records/data into a table? After some thinking, I'd like to add this data into a table, then use the table to spit out the report. Does that make sense?

Also, do these forms need to update to a table? For instance, can I make it so that if someone enters this data into the form it will update the table with that information so I can easily generate the report?

Hi all! I have created an "unbound" form. Basically, people select data that they want from it, and it then needs to spit out a list of labels. I'm not trying to store data, just allow people to input information. What should happen is they first select the branch/plant from a drop down...

I have a database setup which uses forms to simplify things for people who need to run reports and enter data. I simply use a form to accomplish this, with the finished data outputting to an Excel spreadsheet. I am running into an issue in which I want to create a criteria using a text input...

Hi everyone, I'm having some issues doing a vlookup and hlookup on a particular page of a spreadsheet. All the pages are pretty much the same, just looking up different departments (Primary, NS, NRCC, 110). The issue is with 110 - it seems to refuse to pull up the data on the 110 Summary...

I ended up talking to people to determine why we have 2 coordinators for some jobs, and it appears we don't actually need 2 coordinators per job, this means someone made a data entry error. However, I still do have an issue with duplicates in the Kitting query, even though the SQL has the...

Well, most things are sorted out now. However, we do have a remaining issue with duplicates. Some jobs have two coordinators, and thus it is creating duplicate entries when this occurs. How can we sort it so that only ONE coordinator shows instead of making 2 line item entries that are...

I am having an odd problem with pivot tables. Basically, when I try to modify the column heading titles in a data sheet which feeds to a pivot table, the pivot tables "break" when I try to refresh the data, and a significant amount of data in them doesn't appear anymore. Why does this happen...

Well, the problem I am encountering with that is that it spits back at me the error "Operation must use an updateable query". I'm trying to pinpoint what it is that is causing it to occur, but to no avail.

Thanks Scooter! While I do find it easier to manage now, I'm unable to export the queries to a 4-sheet Microsoft Excel document. When it was using tables, I was able to use the "TransferSpreadsheet" macro function to export to multiple sheets within a document. Now, my only option is to...

Hi all, Some may be familiar with my saga earlier in the day with creating tables/queries. To sort-of springboard off of that, I'm looking to make each one of the 4 queries I built export to a Microsoft Excel document as separate sheets. When I had the tables, I was able to do this via...

Thank you! You have really made my day! PS: Thanks for pushing at me to get some of that data out of tables and into queries. Saved a lot of headaches, now I just need to re-write the macros. My day has gone from frustrating to happy!