Search results
-
K
Why! Text field imports to Access at a double
I have no idea why this is happening. But I wish it would stop. I have a csv file which I import into Access monthly. I have a field that is a SIC Code field. Essentially SIC codes are numbers but they mean nothing in terms of numbers so I have them in my CSV files as text. When I import... -
K
Access 2000-Biggest DB you have?
I am in the midst of developing a data base that will be updated every month form data from an ASP. The info will be archived at the end of each year to make room for the new year's info. My concern is: how robust is 2000? I heard that you can have 1Gig in Access 97 (that's what I am... -
K
Access 2002-Speach Recognition
Does anyone out there use Access 2002? I just got it and every time I launch Access, I get this screen telling me I need to activate the speach recogntion in order to properly use Access. It is driving me nuts!!! I have looked in knowledge base and other places and find zilch. Any... -
K
Field Type Error
Hi, I am using Access 97 I have a CSV file (that is coming from Excel) that I import into Access, I get this identical file every month (with the new month end information). There is a field called "Officer ID" which is a number, but of no numeric value, so it has been created as text... -
K
Having one field be one thing, depending on the field of another.
Hi everyone, Every month, I will be importing a csv file into Access. This field will be the same, but obviously the info will not. What I need to do is create a field that will base its value, on another existing field. The end result of this info. will be put into a report for management... -
K
Using "Before Update" to check for Nulls/Message Box Question
I have been working on this for the past couple of days and seem to have hit a stone wall. I have a form that is used to add a new customer/relationship. The four fields on this form are RelID, RelName,CostCenter & RelationshipManager. All of these are required and cannot be null. I have... -
K
Form Capbilities, Is this possible, or just wishful thinking?
I have finally finished my final table design, and am thrilled that my 40 Fields (all related!!) are now down to 7!! Thank you to everyone who helped me figure out that my tables do not have to be the size of the Nile River to capture all necessary info. My next task is to develop a form for... -
K
Auto Fill on Data Entry Form
I am an Access 97 user. I would like to create a form that has both a customer ID and customer name on it. I would like the form to automatically fill in the customer's name once the user puts in the customer ID. When doing research (the Access 97 Bible) on this, the only info. that I get is...