Search results

Here you go! I am currently working on the form labelled "Subform Vendor List". It should write to the "Inactive" field in the "Junction Events-Vendors".

I eventually don't want to have it visible on there, but I put it onto the form for troubleshooting and I am still getting the errors shown here. Yep, stand by.

You'd think by the time they had like...20,000 rows someone would have been like "There has to be a better way than this." But the power of inertia is crazy!

Nope. Returned Error: "Microsoft Access can't find the field "Inactive" referred to in your expression."

This video walks you through how to import records: How to Import a CSV. This one shows you how to export records: How to Export a CSV.

I have a continuous form filtered to a query, so that it only shows entries where the inactive box is NOT checked. When I click a button, I want the current record to update to change the value of the inactive field to 'true'. The query which is the record source for this particular form looks...

Hello, it sounds like you want to use Access to filter down the data, right? Since doing a macro in Excel will take so long to run on such a big dataset. You can easily import to Access by going to External Data > New Data Source > From File > Text File. Filter the data using a query and save...

Sorry, I misunderstood it the first time and was confused. I understand what you mean now and I understand why Access uses the 'default' value in that way.

Just for documentation purposes, this is what I ended up doing. First, I made it so that when this form is opened, I set a default value for the listbox: Private Sub Form_Load() Me.EventTypeSelector = 1 End Sub Second, I added in error handling for null values in case something went wrong...

I don't think it should matter in this case because this particular form isn't updating to a table so it isn't creating a new record at all. I'm basically using it to put together a wizard. Neither the form nor anything on it is actually bound to anything. What's meant to happen is that the...

It is not a multi-select listbox. I thought that I had something selected since I set a default but apparently, that doesn't work to set the value and returns a null value. If I actually select the default item, it does work. That kind of sucks though...maybe I can set the value when the form...

I am basically trying to create my own wizard using an Access form. On the first step, the user needs to make a choice between two types of events. Because this is a wizard, I don't want to store the value they choose in my database, but I *do* need to use the choice to call something else. I...

Thank you, I will do that!

Hello! I'm an experienced Excel wrangler but only recently learned about the magic of Access through my new job and am LOVING it so far. Now I'm using it to build a database for an event planning business I want to start. Happy to meet you all!

Oh geez. Yeah, that works fine. I've been pouring over threads for the last hour and never noticed that the AND operator goes inside the quotes not outside it. Missing the forest for the trees. Thank you!

I am trying to display information in a form using DLookup based on multiple (in this case two) criteria. The form is linked to an event table but is referencing a related table (in this case, a junction table it shares with a customer table). For the purposes of troubleshooting, I'm using...