Tables
in [Access]
|
unique record numbers I am trying to create a unique PIN for members in a table (not the primary key) that will be 4 digits long, and would like each new entry to be incremental. I am very new, and would appreciate a detailed instruction (though I can get around access fair enough). Any help would be appreciated. ... 14 Mar 2010 15:26
Form Design I feel fairly confident that I have my tables and relationships decently set. My problem now is how to display it for my staff to work with. I need some help with form layout Here's my scoop. I am re-building a camp database that was laid out on one entire table!!! So many fields... So many empty fields too... 9 Mar 2010 13:31
Compact & Repair Bug After using the compact and repair function manually from the manage tab of Access 2007, a glitch occurs where i cannot rename, delete or cut any of my objects (tables, forms, queries, etc). The options are greyed-out when i right-click on the object in the left object pane. Any way to rectify this issue so i d... 4 Mar 2010 16:58
Intermittent locking problem Using Access 2003. I have two applications each with their own FE's and BE's and using .MDE's for user FE's. Each .MDB file is set to "Share", "No Locks" and "record-level" locking. Each app (FE and BE) is located in a separate directory with full directory access for users of the specific app. So not all us... 4 Mar 2010 11:13
autonumber is it possible to link two fields Hi, Iam trying to do a project for uni and i need to have a letter infront of the id number that is generated. pls help! I have 15 unique ids and 3 variables, the 3 variables are to specify if the game in question, a league, cup or friendly so i need a F,C or L infront of the id num, all three of the variables... 3 Mar 2010 19:48
Player availability list I am trying to record players availability for team matches throughout a season. For example I have say a possible total of 50 players and there are say 40 matches throughout the season. So far about 30 players have advised me for which of the 40 matches they are available. I wish to record this availability in... 3 Mar 2010 19:48
Student count for Class Registration Hi, The goal / Issue: I want to be able to register the student right after the user enters the student name and address. Currently, the user does this by simply clicking on the Registration tab and registering the student. While I know the maximum number of students allows in the class, I don't kno... 4 Mar 2010 22:33
Adding up days from Date/Time entered I'm new to Access and have a Table where I'd like to put in a Beginning date that an item was sent out on rent, and then put a date where it was returned from being on rent. I'd like to set up a record that sums the number of days that item was out, based on the previous two records. I'm looking for this to ... 4 Mar 2010 14:41
Set Mytable = MyDB.OpenRecordset Help, I am not much of a programmer, but I have managed to build a fairly good tool. The original code was written in 2003 but upon the conversion to 2007, I get a Type Mismatch on the following code. Const ProductTable = "Products" Dim MyTable As Recordset Dim MyDB As Database ... 3 Mar 2010 14:10 |