Search results

I am considering moving my access DB and front-end application from Access to C# with MySQL or Microsoft SQL Server. Has anyone done this? Was it difficult? Is it worth it? Do you have any advice for the move? I really like the Free and Open Source advantage of MySQL over SQL server, any...

I have a popup input form that I am using to accomplish 2 separate tasks. When viewing an RMA, a user can input new or edit an existing labor entry. There's a button on the RMA form that allows them to enter new, and there's an edit hyperlink with a click event for each entry that allows the...

I've been coding in VBA for over a year now but I haven't really dug into recordsets and handling databases as objects too much. From what I have read DAO seems to be the most appropriate for my use, but that's the most I've been able to grasp on the subject. What I am trying to accomplish is...

I have a form for our Repair Order form, and it has a subform that displays all of the technicians' hour entries for that repair order. It shows it in a datasheet view, but I would like to add a button to edit each specific entry, as the data comes from a query. I know the theory behind it, I...

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...

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...