Search results

Does your contacts table have a unique index? If you don't have a field that you can use, create a key field and make it an auto-number type.

import Lotus db to access I have been doing quite a bit of this. First, I import the database table to Access. Check the formats. Then, rebuild the rest (forms, reports, macros, queries). I carefully print all of the stuff I can from Lotus and make notes to use for the convert. It takes a...

I recommend you keep a good backup copy somewhere, then compact and repair your database and see if that fixes the problem.

book recommendation This book was recommended to me, and I have found it to be very helpful: Access 2000: The Complete Reference by Virginia Andersen from Osborne/McGraw-Hill publishing.

import or append old data File, Get external data, Import and then give it the database and select the table. That will create a new table with the name of the old one with all of the data. If you have forms and reports, etc. then you need to Append the data into the tables you already have...

Actually, there is an update feature in Access that helps to keep your fieldname changes correct from table to query, form and report that also seems to reset the printer settings -- I especially notice it when I develop a database at my office and then take it to a user site. (Probably because...

change paper size in design mode Sounds like your changing the paper size while previewing the report. Instead, do into design mode and change the paper settings, save the report, and then you should be all set.

I have visited a few other forums, but I have learned the most from this site and have tried to return the favor to users here as well. Someone recommended this site to me and I passed it along to someone else. I am VERY glad it is here to stay. I agree that a new Topic of Terms is a good...

I like Audrey's second logo with the lines and the world moving. Just a thought though, maybe the box and key for Access with thinner lines so it does not overwhelm the map behind? Sometimes I can draw, but then I would have to use the scanner at work where creativity is not greatly...

correcting auto-number problem My guess is that wherever Access tracks the auto-number, the setting is wrong. Usually, you want the next auto-number assigned. To follow your example, 5001. To fix it, make a copy of your table, structure ownly. Change your auto-number field in your copy to a...

report running over Two thoughts occur to me. First, check your group headers. Is the Format option Force New Page set to None for Item Number? Otherwise, it could be creating the second page. Is the Item Number section so long that there is not enough room to keep it on the same page, thus...

store values that change I know that Access discourages storing calculated values and values that can be looked up in another table, but sometimes you have to store them. If your employee table is supposed to reflect the current rate, then you should probably add a field to the project table...

Is the 37th column a total? Access does not import fields that it recognizes as totals. Otherwise, try to create a second copy of the file with just the key field and the 37th column, import this second copy to Approach, and update the other table with this field joining on the key field.

Okay, I feel like a newbie now! The label was hidden behind the form. I had tried to move it before to get to it (must have had the hand and not the pointer) and even tried moving the fields in the form to no avail. Thanks for the reality check.

Background: I had a form with a command button to allow me to print the record on the screen. I have done this on several databases which works fine, but this time it blew up. (My forms have always looked fine this way.) I searched the forum, and found a recommendation to create a report...

Are you sure it would not be easier to set a field to M or F for male or female? Try this: Sum(Iif(((mid(person,9,1) mod 2) <> 0,1,0) will give you the number of males in your database. Count(person) will give you the total number of records. Therefor, subtract the first number from the...

option group Sounds like you have a Boolean field, which is probably what you needed initially for values of Yes or No. Now that you have a third value, Null, you should try an Option Group. Each option will have an integer value, then you need a lookup table 1 Y, 2 N, 3 Null in order to be...

I always set my reports to Print Preview, then I can always choose to File, Print whatever pages I want.

Check your totals carefully, it may look fine but be really storing 25.365. Just in case, here's an example using two fields [quantity] and [rate]: Int(([quantity]*[rate]*100)+0.5)/100

Create an unbound text field on the report. The control source = Sum(IIf([field1],1,0))