Tables
in [Access]
|
Year only in field Hello, I could use a bit of help in this. While it seems simple, maybe it is not the correct way. In a new table, I want to have a field for the YEAR. First guess is just create a new field and call it a number, then enter the number of the year. Simple. But shouldn't I be using the Date/Time and some ki... 22 Jun 2008 13:14
I'm looking for sample utility billing databases. I'm working on a utility billing database and having problems. Most examples I find are for product sales rather than regular monthly billing ... 21 Jun 2008 14:49
Field type txt or nos for relating to autonumber field ? Hi, Should I make the field called ID in my second table a number or text type of field when that field relates to my first table's primary key field called ID which is an Autonumber field or does it not matter ? This second tables PrimaryKey field will be called PhotoID by the way. Steve ... 4 Jul 2008 23:18
Default Values I want to add a field to an existing table which has a default value. The table already has thousands of records and the default only gets applied to new records. How do I automatically apply the default value to all existing records? -- Regards Andy ___________ Andy Roberts Win XP Pro Access 2007 ... 20 Jun 2008 17:24
2003 problems I designed a database in 2003 and was working fine. I upgraded the desktop to 2007 and the databse was working fine after resolving some security issues. When I attempted to to put the databse in the laptop some of the fetures stopped working. Closing forms buttons, calender buttons. It looks like that any procedu... 21 Jun 2008 16:51
Conditional Formatting Hey guys, I have a field in the subform that I would to change color after validating the item number. I am already using conditional formatting, but the problem it only limits you to 3 conditional formatting. I need to have additional conditional formatting so a total of 4 conditional formatting. Field called... 23 Jun 2008 08:36
ACCESS 2007 Splash Screen? I upgraded to Office 2007. How do you make a splash screen in Access 2007? I can't find that menu selection anymore. (It was easy in Access 2003.) Where did that feature go? ... 23 Jun 2008 04:32
add record to paytable Hi Friends I want to know how I can add data to pay table month after month automatically, may be I have to run a append querry :) or with the help of VBA ? The update to pay table will be based on the attendance leave status etc. I have written a querry which work out pay for current/running month. How I ca... 20 Jun 2008 07:07
modified date field Hi Guys, I have a table that has field [modified], which is a date field, can anyone tell me how I get this to update when details of the record are changed, are thier any default settings I can apply to this field to update when the records value is changed, other than an update query? TIA ... 20 Jun 2008 08:08 |