Tables
in [Access]
|
Optional Input mask I have a field for Employee ID. I need to have the field have 3 different input masks. Can I do this in the table or do I have to do this on the form and an event? If on an event, which event should I use? The click event? Thanks, Arep ... 18 Jun 2008 23:02
Proper Table Design and Combo Box Help I have 3 tables in my database. The Employees table contains information regarding each employee that are included in the Transportation Hours table and the Payroll table. Some information is repeated in each table and I believe that it would better if some fields were removed from some tables and relationshi... 18 Jun 2008 23:02
Vertical Page Tabs Is it possible to produce vertical page tabs in Access 2007? I would like my form to appear like a binder with index dividers on the right hand side. Thanks, Billiam ... 18 Jun 2008 23:02
Database creating Need help with business order It should be like this example: BUSINESS ORDER Id Order: (ex. MK 01/01, MK 02/01, MK 03/01...) Date: Customer - Name Customer Order - many activity (ex. 1. cutting material, drilling material, up to 10 or more activities) Work hours - (ex. cutting - 2h, sawing 5h, drilling 3h .... 17 Jun 2008 07:03
Wanted: help with minimal ADO.NET in VS 2008 I have created a simple three column database where the first column is auto-increment. Can someone help me change my program so that it reads the entire table and appends a new row and saves that new row in the mdb file? I'm trying to use a strongly typed dataset called DataSet3 and the line 28 never execu... 18 Jun 2008 23:02
Handling Transfers I am attempting to create a database that will mainly handle transfers of materials between dealers. This is an aerial application business, so dealers bring us chemicals that we apply on crops. Dealers are responsible for providing us with the correct amount of chemicals for the fields they need sprayed. We... 18 Jun 2008 23:02
Convert Dates in Text Field to Date Field We are using a database that now has over 4000 records in it. When the database was created (not by me), the majority of the date fields were created as Text fields. Now, while trying to create a query to select data from one of these date fields, I have encountered a problem in that the query selects 2007 da... 16 Jun 2008 18:50
rework a table so that old columns are new values Hi all, I am a access beginner. I am using it to organize some data and have a question. I have a table (1700 records) with 6 fields to hold census data for sites in my program. This format (I'm giving an example) comes from a legacy system. Sites Species Fall Winter Spring Summer Riversite YellowBird ... 17 Jun 2008 11:39
How do I make Church Progam. I am tryin got make Profgams for my Church, do I need to have a certain type of software to accomplish this. ALso I need them to be in bi-fold. ... 16 Jun 2008 20:22
Add new field in SQL Server causes db corrupted? I added a new field in SQL server. After I refreshed the link in the frontend of Access 2007, it became corrupted. I wanted to close the db, but it wouldn't let me. I have to "kill" it and re-open it again. This time, it pops up an error message saying, "The db cannot be opened b/c the VBA project contained in ... 16 Jun 2008 11:39 |