Tables

Access Log in
We developed a SQL application with an Access front end. Works great in central office but field offices can't log on. Field office can access server and can pull up application but when they enter login name and password (part of our application) Access doesn't do anything. Field offices have installed appli... 16 Jan 2010 20:33

Data Fields Changing
I have a Master Table in a Master DB linked to a few sub databases. The input forms (to update Master table) are in the sub databases based on queries also in the sub db's. The field names in the Master table change names occasionally. Is there an efficient way to update code in modules, forms, and control/f... 12 Jan 2010 20:48

Can't change data type
I was trying to update field size in table design. I get a message saying 'You can't change the data type or field, it is part of one or more relationships. If you want to change the data type of this field, first delete its relationship in the Relationships window. I have deleted the relationship and I sti... 11 Jan 2010 15:24

Report
I have this code on my database that show certain records based on a training modules completed selected by the user from a drop down list. SELECT [Training Sessions].ModuleName, [Training Sessions].SessionDate, [Training Sessions].SessionTimeFrom, [Training Sessions].SessionTimeTo, [Training Sessions].SessionVe... 11 Jan 2010 14:16

setvalue macro
Terry this post is on my unanswered list, so i figured i would check on it.. Tou mentioned a concern about speed with a bunch of subforms.. Check out the TAB control and put each subject or subform on a different tab that way access doesnt even open the sub unless you click the tab. so you can have 15 tabs a... 8 Jan 2010 22:53

Lookup fields referring to tbls w/o relationship
I created a db and in reading now about db structure, I've seen a lot of mention of relationships. My db started out very simple with the tables that I used for relationships all being one-to-one and now I'm considering adding to it. In it, however, I also have some tables that I used (not w/ the Lookup Wizar... 8 Jan 2010 12:49

AutoNumber vs. Natural Primary Keys
Dear all, As a relative newbie to the art/science of database design, I was wondering if there was any consensus view on whether it's better to use an AutoNumber field as primary key for a table rather than select a (human-understandable) natural key, assuming one exists that you can guarantee will be unique. ... 8 Jan 2010 11:41

Design theory for maintaining historical address communication
I do have an invoices table, are you thinking that there should be the address for each invoice created or if thre are two addresses a secondary table that would have invoice id and the address so it is kept like that? And each period addresses are written to this table as invoices are created? I was trying t... 7 Jan 2010 13:34

How do I break a link to an external database but keep table data?
I am trying to break the link to an external database while keeping all the data in the tables housed locally. It is possible I will loose access to the external database due to updates that will be made. In order for me to work efficiently, I will need to house all the data locally and manually update all the ... 6 Jan 2010 17:42

making a row height automatically adjust to cell contents
In a form that I'm developing I have 4 columns and 5 rows. I would like for the row height of all rows to automatically adjust to accommodate the text entry in any given colum/cell. Is there an easy way to accomplish this? Will it make a difference whether the worksheet is protected or not? -- John ... 6 Jan 2010 18:49