Search results

Looks like if you already have some values in a field, and if you add input mask, you can make a mistake and add duplicate values, because of input mask. So I had to remove input mask and set it as text. This happened with the phone numbers. I already had list of numbers in my table with...

Thanks. I think the problem was "ContactType" which should be and ID No. matching contact types. I removed that and it is good now.

I am getting this error:

I understand what you are doing. Basically instead of telling access where to place each imported column, you are matching the column headers in your excel to those of Access, if there is any that you don't have on Excel, you just create them and leave them empty. It is interesting approach. I...

I agree. That's why I asked in another topic if there was a way to tell Access which Columns in my Excel sheet should go to which fields in Access. I got no response. Do you know how to do this? http://www.access-programmers.co.uk/forums/showthread.php?t=137412

I wish I could post a video. I already deleted the mdb and all projects because I thought I messed it up. I used the Contact Management template and just modified it. I changed the source data table from the default one to the one I imported. I created a Combo Box, and I told it to Find a...

Thanks Jonathan, After doing this, I found another problem, sometimes that combo box info will not match the other information in the form. What happened was I typed something to the box, it didn't find, so I hit enter and went to next item. I realized that although the combo box went to the...

I am sure it should be right in front of me, but I can't seem to find it. I am using default Contact Management template of Access 2000, and I modified some of the fields and added a few new ones. I would like to import my own excel sheet into DB but I want to tell access, for example, to import...

I am not sure why it is coming up now. I set up a combo box with Auto Expand property set to yes, but now whenever I hover you mouse over it, I get this error. The field has been set as Text with 255 max char limit, and non of my rows have over 100 characters in that field. Why is this...

Wow, Thank You. I am loving this Access.

I understand. I used VB6 before but we never did DB on it. I may have to go back and check that. Thank You, I am downloading the runtime right now. I have another question, if you don't mind. Is there anyway to use Auto Complete in form view? As I type a name of the client, I would like it...

It is Access 2000. I will check as you suggested. Edit: OK. I got it In Design View, I can select it from drop down menu under DATA tab. Thanks for your help. I tried to design my own form, but I cannot find a way to use Form wizard to look like a one page form with all the information on it...

Hello, great to be part of this forum. I have an excel sheet with 9 Fields. It is like a customer database I put together. Anytime I have a new customer I add it there, and other fields are like phone number, person, address, email and notes.. that sort of thing. I tried to move this into...