abw1987

Hello hello!

I need to create a database for my company, and I'm having a bit of trouble. I could easily do it in php/mysql, but for some reason my boss wants it in Access with forms and such, and that's proving to be a difficult task.

I've been able to set up the tables in Access, but I'm having trouble with the forms.

Basically I have three major tables: one for Store Locations, one for Employees, and one for their Job Titles. (I also have associative entities between the tables, since employees can work at multiple locations, and can have multiple job titles.)

I'd like to have two forms:

FORM 1 - Be able to search for a store location by name, by address, by state, etc. The form will list the results, and let me double click a result to open it up in Form 2.

FORM 2 - Be able to enter a store ID to list that location's employees. I'd like to be able to edit current employees and add new employees right from the form.

The real issue is that I don't know VBA code at all. I've put together some basic forms but they have issues of their own, as they omit any results that have blank fields.

Does anyone know of any sample databases or tutorials that might be able to help me?

Thanks in advance!