Creating new records in Microsoft Access

This is a discussion on Creating new records in Microsoft Access within the Tech Board forums, part of the Community Boards category; I'm trying to make plans for my 2D RPG game. I originally used Excel, but it's hard to get a ...

  1. #1
    Math wizard
    Join Date
    Dec 2006
    Location
    USA
    Posts
    582

    Creating new records in Microsoft Access

    I'm trying to make plans for my 2D RPG game. I originally used Excel, but it's hard to get a glance at how something is, especially since the field count measures in the dozens, mostly as simple numbers. I thought of using Word and making use of tabs, but adding and rearranging fields is time-consuming since I have to do the same thing each time dozens of times over. So, the solution I have is using Microsoft Access. I made the form, table, and query that is supposedly needed, now I just want to fill out the form for each aspect of a group, such as the list of the game's spells. I don't care for searching, filters, or any of that stuff, I just want an easy-to-see interface where I can look at the specs of spells at a quick glance, done by looking through the records. Trouble is, the "new record" button is grayed out. What do I need to do to make new records? I took a screenshot, removing confidential parts, to show you what I mean.

    View 1920x1440 screenshot

    Any ideas what I may be missing?
    High elevation is the best elevation. The higher, the better the view!
    My computer: XP Pro SP3, 3.4 GHz i7-2600K CPU (OC'd to 4 GHz), 4 GB DDR3 RAM, X-Fi Platinum sound, GeForce 460, 1920x1440 resolution, 1250 GB HDD space, Visual C++ 2008 Express

  2. #2
    Registered User whiteflags's Avatar
    Join Date
    Apr 2006
    Location
    United States
    Posts
    7,656
    It looks like you are trying to modify a table from a form which is not a very smart idea. If your forms are not read only then you can do it, but it shouldn't matter: Edit the table you should have created. It's the safest, especially if any of your tables have a relationship. I've never heard a compelling reason to edit a database from a form.

    The form should be updated automagically when you save the table.

    Queries will need to be ran again, though.

    You can also edit from queries, (delete records, etc.) but this may actually corrupt the database depending on the tables you reference and their relationships, so make sure you read your help file (it's been a long time since my last database course; you can probably tell).

  3. #3
    Math wizard
    Join Date
    Dec 2006
    Location
    USA
    Posts
    582
    Filling out the form updates the database based on the input. The table is just for what types of content goes into the field (such as text or numbers). I found the problem now and it's working. I've got 2 records so far - fewer than expected due to a problem I spotted in my main plans. That's the nice thing about planning before you make it - you can spot potential problems before making it, otherwise it's a lot more work having to redo sizable chunks of code from one small mistake in a detail.
    High elevation is the best elevation. The higher, the better the view!
    My computer: XP Pro SP3, 3.4 GHz i7-2600K CPU (OC'd to 4 GHz), 4 GB DDR3 RAM, X-Fi Platinum sound, GeForce 460, 1920x1440 resolution, 1250 GB HDD space, Visual C++ 2008 Express

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Problem building Quake source
    By Silvercord in forum Game Programming
    Replies: 16
    Last Post: 07-11-2010, 09:13 AM
  2. Apps that act "differently" in XP SP2
    By Stan100 in forum Tech Board
    Replies: 6
    Last Post: 08-16-2004, 10:38 PM
  3. Another Microsoft joke
    By Panopticon in forum A Brief History of Cprogramming.com
    Replies: 9
    Last Post: 02-02-2003, 11:53 AM
  4. Microsoft rulling
    By Sentaku senshi in forum A Brief History of Cprogramming.com
    Replies: 1
    Last Post: 11-02-2002, 02:50 AM
  5. Random Access Files
    By Unregistered in forum C Programming
    Replies: 1
    Last Post: 08-29-2001, 08:06 AM

Tags for this Thread


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21