Recent content by 3535

Thank you Lehtoant and Elizabeth. The build button helped me get my code stright and I put in Combo39.requery. I think it may just work. thanks again Ray <br>

In the properties section for my ComboBox the RowSourse code looks like the following.<br> <br> SELECT[Table1].[CompanyID],[Table1].[Name]<br> FROM Table1 ORDER BY [Table1].[Name];<br> <br> Would like some help on adding a WHERE [Table1].[Terr] = Text59, but I cannot get code right. <br> <br>...

Really do appreciate your through response. Ray<br>

The line that say's: SQLStmt = SQLStmt & &quot; (Table1.Terr = &quot; & Me.Text59 & &quot; ) &quot; sets a filter to whatever terr(itory) number I input into Me.Text59.<br> What I would like to do now is also add a Sort on DateField to the same SQLStmt.<br> Final outcome would be a database...

I have a line of SQL code that looks like:<br> If Me.Text2 &lt;&gt; &quot;&quot; Then<br> SQLStmt=SQLStmt& &quot;(Table1.Terr = ' &quot; & Me.Text2 & &quot; ')&quot;<br> Endif<br> <br> Instead of getting the number from a Unbound field called Me.Text2, I want to get the Number from the answer...

Bound? How do I bound or how can I check if my tables are bound? Thanks, Ray<br> <br> <br> <br> <br>

I set up a phone field and set IndexYes NoDuplicates to it.<br> In Table view, it works fine and does not allow Duplicates.<br> On my form it does not prevent duplicates.<br> Is this correct? How can I prevent Duplicates in a field on my form ?<br> <br> <br> <br> <br>

Thanks Rochelle, once again your advise works great. Ray<br> <br> <br> <br> <br> <br>

Works fine now on Text field, one more question, how do I get this code to filter to Number field ?<br> <br> <br>

Thanks Rochelle, will try it again. Ray<br>

Can anyone tell me what is wrong with this line of code, I get error &quot;2448&quot;<br> Me.Filter = &quot;Territory = &quot; '& InputBox(&quot;Get Territory:&quot;,&quot;Get Territory&quot;)&&quot;&quot; '<br> <br> <br>

Culshaja,Had put a sort on the form, but it is removed. <br> Elizabeth,No. There are 3 tables with no other sorts.<br> Please send me any other ideas.

I have a form based on a Query. One field is checked marked decending sort. The records on my from do NOT show sorted. I am new to Access 2000. Any ideas where I might be going wrong?<br> <br> <br>

The problem turns out to be an AutoNumber field in my Access table with an Index set to NoDuplicates. Once I turned off the Index, I did finally get the screen that ask's "Do you want to add to an existing table". Thanks Rochelle. Your help appreciated.<br> <br> <br> <br> <br> <br>

Find it, I find the Dbase file and ckick on it.<br> MS Access says successfully imported, it made a new file called greast3, but I wanted the file added to an existing table called table3.<br>