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 didn't normalize my database as well as I wish I had. I have a table called EmpInfo that's built essentially as...

I am building a database catalogue of all our reports and want to include the SQL and VBA used in the reports. I have added a memo field to hold this data...

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

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

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

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

Hi all, I want to enforce referential integrity between two fields in two separate tables: tbl FishTaxonomy (includes the full name, common name, 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 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 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 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 have a database where they need to select, store and view either a diamond or inverted delta symbol to designate a certain item. Is there an easy way to do...

I have the same problem. All of the underlying Excel spreadsheets are maintained by other people. If one them opens the file for editing, you're locked out. I...

How do I get Access 2000 inside the table to make it recognized PhotoEd.exe in Insert Object dialog box so I can add .jpeg or .gif photo into my database OLE...

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