Recent content by rlmorgan

I think it's going to go away. The only reason that I added it was to show the users that they just used the Clone Record button and were now editing a new record. Thanks for the help.

I have a form that is populated with a combo box. The form data is from a table that has an autonumber column. How can I stop the form from displaying (AutoNumber) in the field before the form is populated? This is strictly cosmetic. :p

Thank you for bearing with me thought out this. Greatly appreciated and Thanks sent.

Thank you for bearing with me thought out this. Greatly appreciated and Thanks sent.

With that said it sounds like I would just use a standard Append query and ignore the errors. Would that be a correct assumption?

And now the blind shall see. That makes sense now, let me give that a try.

Okay, I'm not fully understanding what you are suggesting if you want both the “Htag“ and “ProductID” fields set as Primary Keys. It is my understanding that a Primary Key cannot contain duplicate entries. Yet both of these fields must contain duplicate entries.

First of all everyone, thanks for the help. At this point, following the all of your suggestions, been able to accomplish importing the new data. I am not sure that I am describing my problem well enough for everyone to follow me. The data in the “tblHTags” table is based off of a SMS query...

I tried your suggestion but Access won’t let me. It states I have duplicate records and will not let me proceed. Sorry, I renamed the field from "Name" to "HTag" :p

I have reviewed numerous posts both here and on Google and can’t seem to find the right solution to what I thought would be a common problem. I have a table named “tblHTags” that contains 5 columns, two of which are “HTag” and “ProductID”. The original “tblHTags” table was created from a CSV...

The only thing I was going by was a few comments found in other posts while researching the above problem. I do have Access '07 and '10 available but neither is approved for use in our environment yet. Just watch, as soon as I finish this project, management will want me to upgrade the DB to 2010.

I will keep that in mind. Is it true that this method may cause upgrade problems going from '03 to '07?

Problem solved. :D I decided to go about it another way and it may allow the DB to be converted to Access 2007 or 2010 with fewer problems. I simply added a Criteria to the query that the form is based on. On the “Title” Field of the query I set the Criteria to...

Thanks for the fast reply. I know just enough about Access to get me in trouble. Your suggestion makes logical sense now that you’ve pointed it out. I have tried setting the Filter and FilterOn properties of the form in various ways but still can’t get it to work. I have tried the...

Hi, I have a rather complex from based on a query. The form is populated using an unbound combo box. The query has 50 records and the combo box will successfully find the first of 4 matching records. All this is working great with one problem. The forms Navigation Buttons are showing record...