Tables --------------- tblItems: itemId (PK), & other item fields tblVendors: vndId (PK), & other vendor fields tblVitem: vitemId (PK), vitemReference (FK to...

Hi. I need to go back to the proverbial well again. Thanks for being here... I am creating a tooling database to track programs, tools, and part numbers. I...

The problem I have is that this database was already started and I am trying to get it to work and going crazy. The person who started it had lookups...

Hello to all. I need to design a database for tracking supplier's prices. I order items on an as-needed basis but there are humdreds of them. Basically I...

I'm in the midst of designing a comprehensive database for archaeological materials including tables for reports, notes, and photographs, but also integrating...

It would be very useful (not to mention a time saver from flitting back and forth between screens) if we could have a split screen between Outlook messages and...

I have a textbox for a name. I would like to put an input mask to force a capital letter for the first letter in the name, but I have a problem with names...

Early this am I posted a question on Access - Forms. Now I can not get back to the site to see if anyone was able to help me. All I get is "Newsgroup not...

personal tele phone diary or directory in access or in excel

I’m trying to build a table with custom fields specific to each company. I have 60 company names. Each company has fields that only belong to that company. ...

I have a small home business making name bracelets from silver beads, crystals (available in different colors), and silver alphabet blocks. The most critical...

Need help with the recall of a task that has the wrong dates on it.

Hello, I have been working on this database table design for about a month or so. Finally had some slower period here, so I proceeded to diagram it all...

Hi, I have a student database and wish to generate a report based on a query that contains: Student Last Name (from Family Info table) Student First Name...

i have a linked odbc table; i can manually refresh through linked table manager, but is there any way to somehow automatically refresh?

When I create an HTML access page in Access 2003 and save it to a share on a 2003 server, the page connector does not work. It will not connect to the data in...

I added a field for an actual year - the old data is based on the year data as 98 99 00 01, etc. I was hoping I could find out how to fill in this new blank...

Hi, Does anyone know how to return the name of a field index in an access database from within the front end? I have code to programmatically delete fields in...

Hi I hope someone can help.... I have a "BookingPayments" Table that I wish to redesign to be "normalized". Each booking has it's own reference by autonumber...

Hi Folks - I need some advice .... I have inherited an Access 2000 database with embedded pictures. Last week, it reached the 2GB limit (It turns out the table...