Threads Replies Last Post 152 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   many types of absences Hi all! Access 2003. I need suggestions, advices and/or tips to solve a problem raises during the design phase of my DB. this DB will be used to manage human resources in a farm. All employees can go on vacation (and it is enough natural) but they can use several types of benefits like short absence (1 day to recovered in the future), holidays (a different amount of days used all in one t... 3 12/31/2008 4:30:00 PM unable to "share" database I have an aceess 2000 database being viewed in Access 2003 (can't change DB to 2003 as not all users have 2003). When the database is opened by one user (2003 Version) then other user (also 2003) can open the DB but can't make any additions or changes to the database. It is set up as a shared with the parameter set to "open databases with record level locking" but default record lockin... 2 12/31/2008 5:08:09 AM Database Design Hi, I wonder if anyone can help. I am trying to create a bowls pairs league database. At the moment I have 6 tables, league, fixture, game detail, team names, players names & score which are linked in relationships league (can have many fixtures), fixtures (can have many game details). The league table consist of league ID (primary key) & league. The fixture table consist of fixture ID (... 2 12/30/2008 8:02:26 PM Table Design I've created a table called country with fields: CountryID (PK), CountryName. For each Country I've created a separate schedule table with fields: CountryID (FK), Low, High, Base, TaxRate. There are btw 4 to 5 rows of data for each country's shedule table. In relationship mgr, I've linked each country's schedule table to the Country table via the CountryID field. My problem: The Coun... 6 12/30/2008 6:59:45 PM Call Management Database Access 2007 Hello Everyone, I have spent time online doing training and have just finished Oreilly's Missing Manual for Access 2007. While I am better now than when I started I am still stumped on what I think should be a very simple DB. I am an account manager for an insurane company. Basically a travelling salesperson for all intents and purposes. I need a database that I can input all my dail... 12 12/30/2008 6:06:01 PM Keeping A Diary/Appointments in Access DB I am writing an app in C# which keeps my diary appointments in an Access 12 DB. Accessing one off appointments is fine but I have to do a lot of calculations in respect of repeat appointments. If I have a weekly appointment that started on 1 Jan 2002 and I want to find out if it should be displayed today I loop through the record adding 7 to the start date until the date is => than... 7 12/30/2008 6:04:08 PM CONSTRAINT [pk_SwitchboardItems] Helllo: In the table structure of the following, can anyone explain what is the meaning of : CONSTRAINT [pk_SwitchboardItems]? CREATE TABLE [Switchboard Items] ( [SwitchboardID] LONG NOT NULL, [ItemNumber] SMALLINT NOT NULL, [Language] TEXT(50) NOT NULL, [ItemText] TEXT(255) NOT NULL, [Command] SMALLINT, [Argument] TEXT(255) , CONSTRAINT [pk_SwitchboardItems] PRIMARY KEY (... 2 12/30/2008 9:30:51 AM table redesign i thought i posted this yesterday, but i can't find the post, sorry if this is repetitive. i have a table for tree demography info. each record has a tag id, census date, stage, and size. there are 1700 trees and 5100 records. instead of having multiple records with a unique key for each, i want the tree tag id to be the key. i know this runs counter to the idea of a key, but it's easie... 4 12/30/2008 2:23:24 AM Employee Hours Database I need to design database that tracks employee hours. What I need to be able to do is input an employees daily hours week by week and get the total hours at the end of the week. How could I go about doing this. Jon... 4 12/30/2008 1:17:31 AM Pulling records based of another tables, column Hello all.. I am really really in need of a help. This query of my project has hold me back now for months. The project is to develop a database. I have two tables, table1 and table2. Table 1 has the following columns and rows: ID Audit 223 2 234 3 225 1 226 2 The column ID is unique, have one record per row and Audit is not unique. Here are the columns and r... 3 12/29/2008 11:26:56 PM Cannot view postings Hi all, This is very strange. I posted a question few days ago about "Table Design". I got the email notice that I had a response, but when I log into the forum, I cannot see my post or the response(s). I tried to search for it by "Table Design" but I cannot see any. All I saw were postings date back all the way to 12-23-2008. I switched between Firefox and IE, but none worked. ... 2 12/29/2008 8:32:05 PM Forum moderator, help...lI can't see my post thread Hello forum moderator, I got a email notification for response to my post, but unfortunate for some reason I cannot see my post or the responses to my post. I got an email notification that I have response to my post, but I can't see them when I click the link. In fact I cannot even see my post. Can the forum moderator please help? Thanks, Ben http://www.microsoft.com/wn3/a... 3 12/29/2008 7:53:01 PM Table design Hi all - I have a list of employees and I wanted to know if you can share with me how best to design the table so that it implicitly reflects the hierarchy. The list of employees contains employees from multiple division. 1.Each division has a division head 2.Below the division head, is a department head, there can be multiple departments within each division. 3.Within each departm... 5 12/29/2008 7:52:01 PM ATTN: Ben who asked for the forum moderator: there is no such person >Hello forum moderator, > >I got a email notification for response to my post, but unfortunate for some >reason I cannot see my post or the responses to my post. I got an email >notification that I have response to my post, but I can't see them when I >click the link. In fact I cannot even see my post. > >Can the forum moderator please help? > >Thanks, ... 2 12/29/2008 7:31:10 PM custom numbering which resets when new year is entered Hello, I would like to assign sequencial numbers to invoices (YYYY/sequecial number), where YYYY - year: 2008/1 2008/2 2008/... but when a new year is entered I want the sequencial number to be reset automatically: 2009/1 2009/2 2009/... I don't want to use Autonumer to keep numbering consistent in case data entry is cancelled. Do I have to store the custom numbering in a... 9 12/29/2008 1:56:51 PM set ALOWEDIT property to "YES" i have set AllowEdith property in my form as "No", now i want to change it to "Yes" again, how should i do this... 2 12/28/2008 3:27:52 PM organization and keys i have data concerning tree demographics: census date, stage, size, species, tag id. currently, the table has unique keys for each tree for each year. there are 1700 or so trees and because of multiple censuses, there are over 5100 records, each with a unique key. i want to be able to use the tree's tag id (how it is identified in the field) as its key, so to speak. i understand keys... 5 12/28/2008 1:19:56 PM auto field update I tring to use the date in one field in a database to update another field in the same database automaticly (Primary date {field 1} – 280 days =secondary date {field 2}) Please break it down barny style I’m new at this. Thanks... 4 12/27/2008 6:30:25 PM Add 7 days to last record date? Hello, I am still a novice at database design so maybe this will be easy. I would like the default value for my date column to continually increase by seven days. It is a schedule and the date value needs to be every Monday.... 5 12/25/2008 11:35:00 PM Timesheet design help I am having problems normalizing my database. The staticTime table is the time that the employee receives at the begining each year and was rolled-over from the previous year. The Time table holds all the transactions. Employee Table EmployeeID (pk) EmployeeName StaticTime Table Autonumber (pk) EmployeeID (fk) Date (always the first day of year) BeginningSickTime BeginningAppro... 2 12/25/2008 2:33:46 PM Help will pulling records based of another table Hello all.. I am really really in need of a help. This query of my project has hold me back now for months. The project is to develop a database. I have two tables, table1 and table2. Table 1 has the following columns and rows: ID Audit 223 2 234 3 225 1 226 2 The column ID is unique, have one record per row and Audit is not unique. Here are the columns and r... 2 12/25/2008 2:26:18 PM Need to eliminate the [form name] in access2003 application title don't want it to show the [form name] wreckcheck-2008-[tab:form] when i open a form in application just want it to stay at wreckcheck-2008 which is the application name.. also, don't want it to show wreckcheck-2008-[] just wreckcheck-2008 it is possible, i did it couple of years ago, but i forgot please and thank you san diego cal -- Joe Sr... 2 12/25/2008 2:24:50 PM Recursive Table I need to store and retrive hierarchial data. The data represents categories for a product catalog that can have an undetermind number of subcategories. i andt to use a recursive table but am not sure if that's right. I have the recursive idea down but my problem is finding the lowest level category so i can store it in a new product reecord without knowing that it is lowest level becaus... 5 12/25/2008 11:54:52 AM Expression Question I have a series three of drop downs on my site. Each one establishing a criteria in a text answer. Each text answer has a scroe attached to it for example Question 1 answer 1 = 5 points answer 2 = 4 points answer 3 = 3 points Question 2 answer 1 = 5 points answer 2 = 4 points Question 3 answer 1 = 3 points answer 2 = 2 points Total Points Is there a way to ... 2 12/24/2008 6:58:56 PM E-mail links to Outlook in Access fields In MS Word, if you type an email address, it becomes a link automatically. If you click on that link, it opens Outlook with a new message, ready to create and send. I have a field in an Access form (Text Field) for email addresses, and I would like to have the same functionality. I tried changing the field to a hyperlink, but it took me to the web instead. Any suggestions would be m... 2 12/24/2008 5:10:39 PM 152 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>