Search results

Very simple code piece. Felt like I should contribute something, however minimal. This will clear a multiselect listbox. I use these a lot as I have a few "power search" forms to run complex reports on the fly, and I use a lot of multiselect list boxes to allow the user a lot of flexibility with...

In the small business that I work for, we have a small ( < 5MB) access database with a front end application. We subscribe to office 365 so we have sharepoint available if we want to move there in the future and the tables are all web compatible. We host our back end on our local on site server...

That works perfectly. I tried the 2nd option but it said the joins were ambiguous and to make each join its own query. I wasn't about to make 5 queries, so I tried the 3rd option which made them all right joins. Then I saved it, and tried the SQL again and it works great. Thanks.

I fiddled around and you are correct. But the problem still persists because I am using a slightly different approach than I had previously specified, I thought this would be a simpler resolution, but it looks like there's more going on than I realized. If I make my SQL SELECT statement based...

Yes it is a date/time field, not text.

I have a table that I am trying to filter by a date field. I want to find all entries will null or blank values in the DateOut field. The table has a number of entries, about half have dates in the DateOut field, and half do not. I have tried: WHERE DateOut Is Null; WHERE IsNull(DateOut)...

I have a number of web tables for the back end of the database I made. I have a non-web front end application for offline use, because the web friendly macros that access provided made me want to throw my computer out of a window. It will be published to the web in the future, but for now...

So I have heard it said by numerous people here and elsewhere that lookups are evil and are possibly worse than Satan himself. So with that said, from my new experiences with Access 2010 Web databases, they essentially force you to use them. Is there any way around this while still maintaining...

My name is Micah, I've been programming with VBA for over a year now. Started with access 2007 and I just moved exclusively to 2010. I have a BS in Computer Science and experience with Java, C++, and C#. I live outside of Norfolk, Virginia. I work for a small family owned robotics repair...