Search results

Thanks for the advise. I think I will try and run an append query monthly. I also noticed that Excel doens't do many things I would like. I live in New England and all New England zip codes start with 0. When you put any CSV file into Excel it will automatically delete the first zero in my...

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

I have heard the info. about the 2gig limit by an Access developer who had to swich to Access 2000 because his Access 97 DB grew over 1Gig (the limit in 97). He told me that when doing my project roll-out I needed to at least switch to 2000 to give myself that extra gigabyte of storage. In...

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

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

Do you know when whoever installed Access whether or not they did a standard install, or an advanced or custom install where the user chose what they wanted installed. I had a similar problem and I had to re-install the wizard component so that I could use things like the sub-form wizard and...

Good Idea, I will try that. So what you are saying is if I link the table, I will no longer get the import error because I am no longer importing. That makes sense, doesn't it :confused:

When you run the append query, you can append it to a new database, so you don't clog up your current. I just tried this and it worked like a charm. Good Luck

Because sometimes I need to do work within the Excel data, and I don't want the result to show up in Access. My company looooves Excel, and they like all kinds of options for spreadsheets. Therefore I keep the same info. in two different systems (Access & Excel). Is this the right way to...

Thanks to both of you for the suggestion, the problem is that the field (officer ID) is no longer in my original table (the one I am using) because of the import error. The data error table (because of the data type error is all by itself, and that is where Access puts my officer ID field. It...

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

I will give it a shot. Thanks

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

As member (still newbie though) I can understand general frustration when a post is posted here that has previously been posted numberous times. I do have to say that the search function on this forum is decent (I wish I could say the same about about Access Help, the help section is good, once...

Thanks for responding. In the table design I do have all fields tagged as required. What I will do is add my message to validation text, within the table itself and see if that works. I am so anxious to start learning code, that I think I may be ignoring the obvious and easiest way of doing...

Well I gave this a go and while it worked MUCH better than my sorry structure previously, I still have some quirks. Quirk One. When using the following: MsgBox ctr.name & " is a required field." I get a message like this: RelName is a required field. What it is doing is taking the name of the...

Wow! I thought it would look a lot more complicated than that. I will give it a go. Thanks

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

Thanks to Both of You!! I will give it a go tonight..

Thanks for replying If I do that, and the user needs to change the fields (there is a remote possibility), can it be done?