Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by 3rdRail

  1. 3rdRail

    Function Not Available in Expressions in query expression date()

    Found the answer! http://support.microsoft.com/support/kb/articles/q194/3/74.asp
  2. 3rdRail

    Function Not Available in Expressions in query expression date()

    I'm using an append query that references a form for the data to be inserted into a table. The only field that does not reference the form is DATE. I'm using the Date() function to insert a date stamp to the table. I have other databases that performs this without a hitch. I'm not getting...
  3. 3rdRail

    Preview Report Window Size

    Radman,<br><br>In the properties for the report, look for two Properties, one called &quot;On Open&quot;, the Other &quot;On Close&quot;<br><br>In the On Open property use the code builder and add this:<br><br>DoCmd.Maximize<br><br>In the On Close add this:<br><br>DoCmd.Restore<br><br><br>The On...
  4. 3rdRail

    Events triggered when move to new record

    Rory,<br><br>Here is a less cumbersome method that was discussed yesterday.<br><br><br>Try inserting one line of code behind the &quot;On Lost Focus&quot; for each field. Use the code builder behind the property and add:<br><br>DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ...
  5. 3rdRail

    Saving Query Criteria for a Report

    Here is another method if you don't want to reference the form.<br><br>Enter this in a text box on the report header or page header.<br><br>=&quot;Date Range: &quot; & DMin(&quot;Date&quot;,&quot;Query1&quot;) & &quot; - &quot; & DMax(&quot;Date&quot;,&quot;Query1&quot;)<br><br>substitute Query1...
  6. 3rdRail

    Saving Query Criteria for a Report

    Hi Tom,<br><br>Here is one method to consider.<br><br>Make a form with two text fields.&nbsp;&nbsp;Name them StartDate and EndDate.&nbsp;&nbsp;Reference the query to the form:<br><br>in the query grid, date field criteria type:<br><br>Between forms!YourForm!StartDate and...
  7. 3rdRail

    Bypassing the append message

    I usually eliminate the &quot;Append/update/delete query Notifications&quot; with:<br><br>Docmd.Setwarnings FALSE<br>DoCmd.RunSQL strSQL<br>Docmd.Setwarnings TRUE<br><br><br><br><br>
  8. 3rdRail

    Forms based on multiple tables

    This is one possible solution;&nbsp;&nbsp;&nbsp;<br>Check the properties in both the form and header section.&nbsp;&nbsp;Look for the DISPLAY WHEN property and make sure they are both set to &quot;always&quot;.&nbsp;&nbsp;The 3 possible settings for the DISPLAY WHEN property are...
  9. 3rdRail

    Record-locking

    No problem xtreme1.&nbsp;&nbsp;Thanks for the update on the command.&nbsp;&nbsp;I'm using access 97 at home and 2000 at work and I'm still learning the new commands.
  10. 3rdRail

    Unable to format 3rd and 4th Datapoints in a Graph

    I Figured this one out...<br><br>I used the graph wizard on the first 2 data sets and added the other 2 manually.&nbsp;&nbsp;The one's I added manually didn't show up in design mode.&nbsp;&nbsp;Maybe a flaw/oversight on Microsoft's part.&nbsp;&nbsp;I re-ran the wizard on all 4 datasets and they...
  11. 3rdRail

    Using Cancel to Prevent Save

    A solution might be to build a couple of temporary &quot;buffer&quot; tables that look exactly like your existing tables.<br><br>The idea here is that the data that they are entering is going to a temporary storage area.&nbsp;&nbsp;When the user hits the save button, an append query runs which...
  12. 3rdRail

    Unable to format 3rd and 4th Datapoints in a Graph

    I'm using Microsoft Graph version 9.xx to plot 4 data points on the X axis.&nbsp;&nbsp;The 3rd trend line is defaulting to yellow which is to light when I print the graph.&nbsp;&nbsp;When I am in design mode on the graph, only the first two trend lines show up.&nbsp;&nbsp;The only apparent way...
  13. 3rdRail

    Record-locking

    Here is a quick solution that usually works for me.<br><br>Use the SaveRecord command before closing the update form that is based on Table C.&nbsp;&nbsp;Here is the code.<br><br>DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70<br><br>Chances are you have a button to close...
  14. 3rdRail

    Limiting Records in a Query

    Is there anyway to limit the number of records a query returns to 5 in a local table<br><br>The Access help says that the MAX RECORDS property is only for an ODBC source.&nbsp;&nbsp;I'm using a local mdb and trying to return the TOP 5 records.&nbsp;&nbsp;The problem:&nbsp;&nbsp;If there is a tie...
  15. 3rdRail

    HOW TO QUERY A TABLE USING A DATE RANGE???

    Here is a way to reference form fields back to a query:<br><br>Create a form named&nbsp;&nbsp;Test_frm<br><br>Create two text boxes on the form:<br>&nbsp;&nbsp;Name the first one : StartDate<br>&nbsp;&nbsp;Name the second one: EndDate<br><br>In the criteria field (in the query) type...
See more

Part and Inventory Search

Back
Top