Search results

Hi. Welcome back! You can certainly automate some repetitive tasks in Access. For example, you can try to use an Update query to edit a bunch of records at the same time.

See if this page helps. Scroll down to the code tag. https://www.access-programmers.co.uk/forums/help/bb-codes/ Edit: Oops, looks like I forgot to send this.

I still haven't found a way without using extra columns. Please let us know if you do find a way to get rid of them. Good luck!

Hope you don't mind, I've reformatted your post to use code tags to make it easier to read.

Just in case it helps, have you seen this? https://www.devhut.net/ms-access-vba-export-recordset-to-excel/

What error messages were you getting?

Just in case it might be useful, look up TempVars too. I think you can use them directly in Control Sources without using code.

Hi. Welcome to AWF!

Hi. Welcome to AWF! It would be hard to work with Access without VBA enabled, but I suppose some functionalities are possible using only macros. If you need help with your macros, consider posting a sample db.

Have you tried? Status<>"Rejected"

Hi. Glad to hear you got it sorted out. Good luck with your project.

I am guessing the error is showing up due to referential integrity is enabled. Just as a test, see if the error goes away if you temporarily turn RI off.

Yup! That's another way of doing it. Good luck with your project!

Hi. Welcome to AWF!

Actually, "tags" make more sense in Access than just simply connecting products together. In that case, when you want to list all products with a certain tag, it would be easier to query the tables by simply providing the tags as a criteria.

Hi. Sorry, I was at work yesterday and didn't have access to the file we were using, so I couldn't tell you what I did. If you open the file and go to the PivotTable Analyze tab on the Ribbon, you can click on the Fields, Items, & Sets button and select Calculated Field. From the dropdown...

I was about to say the same thing (using phone, so a little slow typing). Since you said a product can relate to multiple other products, a junction table makes sense. But, it could also mean, as already mentioned, creating two separate records to describe a single relationship.

I used a Calculated Field to add the formula to get what you wanted. I tried to do it without adding the extra columns, but calculated fields work well with number columns rather than text ones. There's probably a way to do it without adding those extra columns, but I thought I would give you a...

Okay, not sure if this is the best answer, but I hope it helps...

Hi. Welcome to AWF! As you can see, we can do this in Access. I am not sure though how you will do it Excel using a pivot table to supply the criteria.