Recent content by 3rdRail

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

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

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

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

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

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

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>

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

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.

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

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

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

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

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

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