Recent content by Halifax

Say your form is called: frmMyForm Create a textbox called: txtFindThis (unbound) I assume you've already created the subform and that it shows data from the underlying table/query correctly, you just want to filter it for whatever is typed in the textbox Open in design view, the query upon...

You don't say what you're doing when you receive the error. First..before you begin..make a backup copy and store it in a safe place on your harddrive. 1. Create a new database called (say) Backend.mdb 2. On Menu (F)ile; (G)etExternalData; (I)mport. Choose your current database 3. click each...

In your query that extracts the data for each combobox, open thequery property sheet and make sure that the UniqueValue propery = YES<br>

Int(Now) = Just Date not time<br>So if your field with Now() stored in it is MyDateField<br>Int(MyDateField) will return the Date part only<br>

Try the DLAST()&nbsp;&nbsp;function<br><br>From MS FAQ Q109380:<br>DFirst() and DLast() ignore sort orders and indexes, even Primary Keys. These functions are intended to return data from the first or last record entered into the table, not the first or last record in a given sort order...

Go into your query and look at the properties sheet.<br>If you're linking two (or more) tables, look at the Unique Values field. It is currently &quot;NO&quot; Change it to &quot;YES&quot; and run the query. Did duplicate rows dis-appear? They will if ERERY field in the output was the same. If...

quite right Peter. I mis-read the original posting.

How about:<br>DCount(&quot;ID&quot;, &quot;MyTable&quot;, &quot;SSN = 12345678&quot;)<br>If the result = 0 then let the user in<br>If not zero = don't let them in, give message box that returns persons name, and employee id etc etc.<br><br>Put the code in an if statement in the OnOpen event of...

(depending on version of Access)<br><br>In Access97: go into (T)ools;Options and click ShowSystemObjects = TRUE. Apply; OK<br><br>Go to Database window, click Tables<br>Go into MySysObjects<br>The TYPE field will indicate Table, form, report etc.<br>The name field should be self...

It depends on which version of Access you're using<br>In pre-97, it's true that saved, compiled querydefs were faster, because they were precompiled, and the Jet had built an execution plan.&nbsp;&nbsp;This however, is true if the dataset that the query was tested on was a similar size to the...

This is a posting I;ve had for some time: I have never needed it because I do daily backups&nbsp;&nbsp;&lt;grin&gt;<br><br>&lt;On Thu, 15 Apr 1999 15:29:51 -0600, &quot;Danny Lesandrini&quot;<br>&lt;<A HREF="mailto:dlesandrini@hotmail.com">dlesandrini@hotmail.com</A>&gt...

you haven't used string delimiters for your variable<br>try:<br>strSQL = &quot;SELECT * from Answers where No_Employe = '&quot; & frmPassword.txtEmpNo.Text & &quot;'&quot;<br><br>