Recent content by kurtis51

A better question would be, how should I go about entering data?

Each Table does have it's own form now, I finally realized that a week or so ago. So that's all set. Then how am I able to populate the data for this DB? I can't use Queries because there is no data to speak of.

Sorry wrong section :S

This is possibly a silly and simple question about recordsets. When does one use them? Should one use them for every table they create or for one main table? All of the books that I've read have said to use them, but in what context does one? I'm just drawing a blank on this...

I'll have to look into that for displaying. Here are my following issues: 1) I have no front end main Form. I need a front end in order to have my colleagues at work be able to enter Data on one screen. - Reports and Sub-forms can come after that, and I will probably go with Sub-Forms. 2)...

Wow... touchy much? I'm sorry if I happened to hurt your feelings. But with my eyesight as bad as it is, give me a bit of a break for taking the time to read most of it.

Well that seems kind of counter productive to put a password on the database, even if the reason is that someone may / may not steal it from your class... :confused: Also, even if any of your classmates did stop by here and happened to see it, wouldn't they have the same information at their...

Unfortunately, I need all the fields in each table. I mean the only reason why I created multiple tables in the first place was because logically they fit into those tables and it would make grabbing data from them easier in the long term. Plus, if I wanted just one long table I would of...

Sorry I've been working with linking multiple tables recently, the common problem I see is that when you do a Lookup from one Table to another, that Access always adds the Primary Key (TaskID) to the first Lookup Column, rather than the column you are trying to retrieve information on (Task)...

Might want to try the simpiler route: Create a Lookup to the Tasks table and sort ascending by the Task rather than the TaskID first

That is the question: Whether 'tis nobler in the mind to suffer with VBA Programming and the outrageous errors, Or to take up arms against a sea of Access troubles. Sorry I was in the mood for Shakespeare. A quick summary first: In the attached file I have my Relationships. One main table...

I appreciate the help Rabbie and while that does help a bit, I'm looking more for the confirmation: 1) my relationships are good 2) that I can in fact take say the EmployeeID field in my Form and split that into three separate fields on the Form, one for Last Name, First name and their Employee...

Trial and Error is good, however... I ended up redoing my tables. I think that I got it right this time around. Anyone's thoughts as per usual if you please. How am I going to get the main form to recognize that the ShipperID, TechID, ComputerID and StatusID fields in the Workorders Table...

I found that Database for Mere Mortals that you suggested Alisa. It's a good book I must admit, thanks :) Problem is, now I'm looking at my Tables as shown above and I'm thinking that the tables just aren't fitting right. There seems like there is almost too much data in the Refresh Table...

Actually I got the Dummies book 9 in 1 and it's helping a bunch. I haven't DB / VB programming in about six or seven years really since College. I'll see if I can find that book online as well, Thanks :) As for the business process, I've laid it all out there. It's more time consuming than...