Hi there, Does anyone know how to make the tab order go vertically along columns in a multiple entry form? It seems like that tabs will always goes along...

I am in the process of designing a table and I am not sure what the best way to approach the design is. In summary, I have one table, lets call it...

I split the db today into a fe/be because of the size. It did accomplish my goal of reducing the size of the be on the network, however, the front-end is...

When I close/open the relationship diagram, Access redraws all the tables and links. The Access version has orphaned tables, criss-crossed links, etc. My...

Hi there, I'm trying to keep a db of clients who take courses and the employees they send for those courses: TblClients ClientID (autonumber...

I've got a fairly simple db with only 4 tables. Only two are linked by a field called E58# with a one to many relationship. In the "many" table I want to...

I have a list of 1000 discrete passwords (and that list may grow from time to time). I'd like a system where when I click a command button ("Generate...

I am looking for a simple database that allows me to enter in expenses and invoices, which gives a summary table with net, vat, and total amounts. Many...

I need help in Access if someone could help me write the formula: An employee starts accuring vacation from the Date of Hire (conditions: if he starts work...

Hi. I’m trying to create a new db. And when I think of the trauma I had initially with my last db, I realize I could really use some input during the...

I am a new user and have set up a database and relationships in Access 2007. I was wondering if anyone could have a look at my design and offer any help or...

how do you create an auto number field in Access using DDL? the Auto things it an Auto..!

I want to creat an Access Data base that would start with my parent(s) page with their page having a drop down list of their children (me and 6 others) linking...

I have Microsoft Access 2003 and am trying to set the "Subdatasheet Name" property on a table to manually (i.e. not programmatically). When I set the property...

I have an Access database I've designed and is ready for deployment, however, the user wants to be able to enter all data in lower case or however it appears...

I have 2 tables, one containing information about the staff of an office (names, address, tel, etc.), and the other one containing their salary history...

I've searched through these forums and read alot of discussions regarding not using a lookup in a table. Instead, one should put that information in another...

In Access 2002 Help, under the topic "Improve perfromance of an Access database," there is a section on MDE files, in which it says: "To save a database that...

Hello, Can I have 2 primary keys where Access requires that they are both not the same. For example... Field1 Field2 a 1 a 2 b 2

Hi, Please help...I get "unknown" error when ever I try to open a table either in design or open mode. It does allow me to create a table but does not open it.