Search results for query: *

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

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

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>

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>

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>

In Access, I want to ADD records to an existing table from Dbase IV. Everytime I go thru the import process Access creates a new table from the Dbase file. I have the existing table open, but cannot get Acess to ADD records from the dbase file into it.<br>

In Access, I want to Import and ADD records to an existing table from Dbase IV. Everytime I go thru the import process Access adds the Dbase file as a NEW table. I have the existing table open, but import does not give me the option to add to the existing table, it just automatically adds a new...