I want to achieve (in Access 2003) what the built-in function in Access 2007 does by allowing users to select multiple items in a combo box or list box. See...

I have an Access data base that has acumulated 7 years of HR info. We plan to moving this info to HR Application. The new application has a field called field...

Hi All A database I created for a client some years ago has a macro which contains an append query. This macro repeats itself until a condition is met and...

Hi all, Just created a database to keep track of case management for clients. I have all demographics, types of case management intervention, but I'm having...

I'm new to Access and really don't even know how to ask what I need to know, but I'll give it a shot and maybe you brilliant folks can figure out what I...

I know this might seem technically wrong and therefore, I haven’t found advice on how to do it on these postings. I have an Access 03 table...

There is an DB that was create well before my time at my job and I have very little experience with Access and need some help here. Access 2003, XP SP3. ...

I am needing some assistance in creating a solid table structure in creating a database that stores vehicle permenant waiver items (items that will not be...

I am trying to design a budget database and I want to have consistent categories and expense. I have a table with Category and Expense It looks something like...

I am working on updates to a couple related databases (not linked by any tables) and have a question about virtues of Make Table vs Append queries. Make...

I am trying to create a validation rule for a table field that will prevent the use of the ampersand character (&). InStr(1,,"&",1)0 does not work. What is...

I used the table analyzer on imported data. good. Noticed that a SELECT statement on the imported data includes the term as noted in the subject line, as xyz...

I have a table named Items, in this table the items are defined by Name, Size, and Format. When first setting up the table I added a few of my items to get...

I didn't normalize my database as well as I wish I had. I have a table called EmpInfo that's built essentially as...

I'm building a database for my personal training business, and currently I ran into a huge pickle and don't know how to bite it. My problem is this, a client...

I need to do an update to change all blank fields to a 0 (zero). In the criteria, I have tried IsNull and it is not returning any of the blank records. I...

I developed a table that includes 245 records (competitors) for an upcoming Taekwondo Tournament. Along with the table I also developed a form, query and...

I need to (very quickly) create a program that is user friendly that would be used by a small corner store to track sales/inventory/expenses/employees/etc. ...

I’m about to finish my first database and am in the planning stages to create another. I want to express my gratitude to all that helped me with this. I...

### How can I use relationships to auto-create records in my subform? ### Please Help! Using Access 2007, I am trying to create a "Classroom Database" where I...