Search results

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...

Well I've made some strides today. I actually had a good brainstorming session with my boss and another guy that's a mentor of sorts. Unfortunately, all the information I wrote down was lost because my computer decided to restart on me... ya fun. I did more work on the DB today. In fact, here's...

Thanks, I've just started to recreate the Database. Originally I had this: Table: Technician Location Tech. Name Tech EID Comments -about old computer Table: Lease Refresh End of Lease Date * Shipping: Table same field Refresh Email Notification Sent Refresh Confirmation Received Dell E-Quote...

Just think of it as creating a Database from scratch.

RE: your question Sorry let me make this clear. We have an excel spreed sheet that we are using right now. My boss wants to go to an Access database because with a form it will be easier to input data and everything will be formatted. I have started building an Access Database and in the form...

Let me just start off by saying, I don't have any code to post as it is just an idea I have. This is a Lease return project for work. We have an excel sheet that is broken up into tabs. Master List, Not Returned and then a tab for every month. Here is what I would like to do. If someone checks...