Search results

Is there a way that I can see the whole form in form view? I can't find a zoom button. The way it is now, I can only see the top portion of the form, and have to scroll down with each record.

What I did before reading your resonse was: I selected those salary amts that were added as new records to my main table, and deleted those records because they weren't matched up with names anyway. Then I went and deleted the append query that was responsible for it. So, basically I'm back at...

I may have done some damage - I broke out the book, followed the steps, and discovered I forgot the step to 'append query' So I found Sal01 field from LOS table (that was the one field missing) and dropped it into the main table. Maybe that wasn't the best decision. Now, I have a ton of sal01...

Ok, I selected the table as kavarin suggested and dragged the field to the grid in design view of the query (this was an append query), then I wasn't sure what to do next, so I clicked "!" run. This is the error msg I got - cannot find output table... Any ideas - please and thank you.

Thanks shacked... access.. sometimes you get tough answers, sometimes they're simple. Gotta love the simple ones

Is there any way to go back and get a field from a table that somehow didn't get included on the query?

Can tables be crossed over from one data base to another. There's information on a table in db1, that I need to add to a form that's in db2. Is that possible?

Nope Rich. Wasn't sensible at all. Dog-gonnit. Looks like I get to go back to the drawing board. I hate learning through mistakes

I had a great table 'comp master' which contained almost a thousand records. I used this table to query another table 'query2'. While in query2 I sorted data and deleted a particular company 400+ employees because I didn't need that particular co in the report. When I went back to comp master to...

I'm trying to make my form attractive, is there any way you can add a colored border to the outside edges? The drawing toolbar is unavailable.. I tried creating something in word and pasting it, any suggestions?

Thanks a million David. I printed out your response (I'll have to digest one bite at a time), and I'll put it to work! But from what I saw, it made sense. I have learned so much in a few short days. Thanks again. I'll keep you updated on my progress.

Good - I found it, through the 'open' from access menu - then chose "microsoft access databases".. and there it was, in my documents. Thanks so much!

David, I have a table #2 with the ssn and birth date information only. I have table #2 with many columns - two of the headings are for birth date and ssn. only the ssn data is entered. I didn't have the birth dates in the cells when I created table #2, just the heading. Now, I'm looking for a...

I have a table, most of it is populated..with exception of the Birth Date field. Instead of entering those dates manually on the table, is there a way to query them in using the social as primary key? All this information is to be reflected in the form also. Thanks for any help!

I have a table and a form, they both have the same name "comp master 2002", because I saved the table as a form. I don't know how to get into either of them without going through the start menu - documents. I tried going through program - access.. and it asks if I want to 1.blank access 2.access...

How did you set up your password? tools / security / set database password? I'm trying to do the same thing, and the last time I tried it, I messed up.. lost the whole form. I think I'll be more cautious this time.

You refer to the example in northwind. I have the Master Microsoft Access 2000 Visually... and I couldn't get into the northwind files through the "open existing files" menu. How did you get there?

I found it! Thanks Jack... That sure helps.

How do I find the 'data type'. I double clicked on the field in design view and searched the properties tab. Didn't see anything with that heading.

Somehow my field thinks it can only receive numbers. I compared the properties tabs to another field that will receive text, and they're both the same. What am I missing. This field didn't have any data from the orig table to determine whether to format text or numbers. Would greatly appreciate...