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  >>   Employee Training Database Hello, I'm in a position of having to develop some type of training db for my company. I must admit I'm not the most enthusiastic MS Access person but have been trying to work my way through. I've taken a few classes but the information covered was not relevant to what I need. It seems so complicated building the different tables and then making sure everything is linked together. I th... 9 12/19/2008 2:35:01 PM event help I am in access 2007 and I have a table called inventory with the following fields included: I have a field called [restock level] and it is numeric a field called [current purchases] which is numeric and a field called [current inventory level] which is numeric I created a query and included a calculated field called todays inventory which subtracts [current purchases] from the [current ... 1 12/19/2008 10:52:01 AM Main form and loading a few subforms I'm running a db for a Facilities report. I have 8 kind of facilities. I've created 1 table that includes the fields that are identical in those facilities – "T_Facility" (such as PK, facility name, facility location, facility manufacturer, etc..), and separated the rest of the fields into 8 different tables, each table relate to a certain facility. In the table "T_Facility" I have a f... 9 12/19/2008 9:57:01 AM Hyperlink shown as a date field - how to do this ? Hello - I Have a table that includes Date field, and Hyperlink for Document Status. I'm exporting this data to Excel (with the help of the query builder in Excel, and update the Excel from the access file everytime it opens). I want to create one field that will show the date, and will act like a hyperlink field. (e.g. Display text is the date, and hyperlink will remain linked.) Is an... 7 12/19/2008 9:52:00 AM Part II - If conditions question The code works (Thanks, Stefan Hoffmann) that checks the employee survey number against the table and allows the survey to activate (or become visible). How do I keep people from putting the same number in and taking the survey twice? Here's the original code that works for part 1 - access to the survey. If DCount("*", "64EmpSurveyNumbers", "ValidationNum = " & [SurveyNumber]) > 0... 11 12/19/2008 7:29:00 AM Monthly Progression I am building a database in which I will be keying in monthly expenses for projects. Each month each project will build expenses indefinitly. I am listing my projects on one table and then the expenses on another. There are five types of expenses for each project so I need to be able to do this monthly. Is there a way I can auto progress months? Ideally the table would have January ... 2 12/19/2008 4:56:28 AM Error msg: The Command 'SaveRecord' isn't available - Help Hello - I'm running a code to send a record from my DB_A to DB_B. The function "M_Valid_sMissingValAlert" checks whether the entire required fields in the form were filled properly. It receives the form as reference and the definition of the tag, which represents the required field (the "req" is in the tag property enter by the programmer). Me.sFKContact is the foreign key that supposes ... 1 12/18/2008 9:10:20 PM How to Report Delta on Queried Data? I am Access challenged so I thought a few questions before diving back into the application might speed my delivery of a requested report. I have a SQL database which contains a data field that should be updated every day. I think - I want to import this data into an Access database to create a new table each day so that I can then compare the records in two tables against each other for... 4 12/18/2008 9:00:02 PM Duplicate records in split database I am working on a shared split database that has an inventory list with purchase and invoicing tables and forms. The inventory items are entered as a specific number with a description. When purchases are made I enter the total cost and quantity. This generates the unit price. If a purchase of, for example, paper #20005 is made for a quantity of 10 for one location and another purchase o... 6 12/18/2008 3:52:37 PM Normalised Stock Table Hi, I'm trying to figure a way of having a single stock table that can handle items that are bought and sold in multiples (eg. Spark Plugs bought by the hundred) for which I use a modified version of Allen Browne's OnHand function to calculate current stock quantity from Invoice & BookIn tables. So each product line only has one record in the table. However I want to include Wholegood... 9 12/18/2008 8:49:01 AM Normalization? Hello; Hoping someone can help with a design issue. I have to learn C# for work. Part of my work will be calling information from a database. Not sure of the type. I thought that it would be good practice to design an application and integrate it with a Jet database. I understand that much of the work will allow me to migrate to SQL or mySQL if needed. So, I am building a grocery sho... 4 12/18/2008 7:05:01 AM Variable Field Names? I am trying to set up part of my database to track employee time. We have been simply doing this on an Excel sheet. I want to be able to enter the employees name and the amount of time that they worked on any particular work item. Given that there are hundreds of work items, Creating a field for each seems to be the wrong way to go. Could someone please help?... 9 12/18/2008 2:45:01 AM error message changing data type getting error message - "too many fields defined" I can not change any data type. I have 170 fields, some I need to change to text and decimal or currency. I can not change any.... 5 12/17/2008 7:51:00 PM Form Autoformat not working right Why does autoformat work in Northwind but not in my databases? It appears fine in the downloaded Northwind Database, but layers appear to be missing in any I create myself. I get a color change, but none of the gradients or graphics in the header. I cannot find any different settings in properties or Access options. Please help. I am working in Access 2007... 1 12/17/2008 5:45:01 PM Creating an Employees' Training DB - Advice on Design Hello, My workplace have asked me to look at creating a database to keep track of staff training/ professional development.They currently keep it all in an Excel spreadsheet and mail merge into a Word transcript that lists all courses completed during the year. These are the rules used: * All employees must attend some form of training. Most of the time, this training session occurs "in... 7 12/17/2008 6:55:45 AM Size restriction? Hi, I will need to create a database with 10 fields and 500,000. Iss that something that Access 2003 will be able to handle. I could find that Acces 2003 can handle up 2 gigabytes, but I do not know how to calculate if 10 x 500,000 data will pass that limit. ANy idea. Many thnaks, Dan... 3 12/16/2008 5:40:15 PM Designing a database Hello to all. Let me first of all extend my sincere apologies for such a ;ong mesage. I am very sorry. I am new at this, just beginning. I have been trying to create a database. I can do most of it but the only thing and probably the last I really would like to know and do is to desing a form to have more than one tabs (I think that's how it is called). A good example is the (customer se... 7 12/16/2008 3:05:01 PM Access 97 and 2007 on the same machine We installed access 97 and 2007 on the same TS 2008 however everytime I would work with Access 97, then open 2007 I get a window pop up saying something along the lines of “Please wait while we install Microsoft Office 2007 components”, and likewise for Office 97. Then after working with office 2007 and going back to 97, it changes the file associations Can someone tell me if access... 3 12/16/2008 3:03:01 PM Need timesheet for law students working on client projects I need each law student to record their time worked for their clients on a weekly basis and then summed up at the end of the quarter so we can produce a summary. ... 3 12/16/2008 2:08:07 PM Creating database and wish to automate I have been working on a database (for a really long time) and getting nowhere. I am stuck on how to get data in a field from one table into another. Specifically- I have a table listing patient demographics in separate fields (MR#(Key), Last Name, Address...). The next step is to go to a table (Relationship is the MR# field) that l list each hospital episode data (admission date, diagno... 5 12/15/2008 10:07:23 PM Triggering an event based on two conditions My before update event written like this: Private Sub SurveyNumber_BeforeUpdate(Cancel As Integer) '320 Or 420 Or 520 Or 620 Or 311 Or 411 Or 511 Or 611 Or 365 Or 465 Or 565 Or 665 Or 382 Or 482 Or 582 Or 682 Or 303 Or 403 Or 503 Or 603 Or 351 Or 451 Or 551 Or 651 Or 379 Or 479 Or 579 Or 679 Or 371 Or 471 Or 571 Or 671 Or 331 Or 431 Or 531 Or 631 Or 358 Or 458 Or 558 Or 658 Dim validnum A... 5 12/15/2008 6:39:01 PM My MSAccess App for MAC How do I enable my clients using MAC (that have MSAccess running on their computers) to use my apps created on MSAccess?... 4 12/14/2008 11:19:00 PM Linked Comboboxes. Breakdown in levels. Hi all! Access 2003. Probably this issue is due to an incorrect database design phase but I post here because I find the problem building a form. I have a series of data logically connected each other that I manage with linked comboboxes (maybe this isn't the right definition). I have a cboSector, a cboBranch, a cboOffice, a cboDuty and so on. Right now, writing code, I discover that for... 2 12/14/2008 7:53:26 PM Generate Account Numbers with Text How can I generate account numbers with the first 3 charters "ALS" then numbers after? Example: ALS3000 ALS3001 ALS3002 can this be done in the table or must it be done on the form before update? Thanks, Arlend ... 4 12/15/2008 2:06:01 AM access for others I am running Access 2k--as part of Office 2k pro. I work in a church leadership and am designinga database to help us manage the day to day of the congregation. we all have laptops but not all have access. Is there a way to put it on a server without access and let them all beable to use it even w/o having to buy access?... 8 12/16/2008 2:07:50 AM 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  >>