Search results for query: *

What am I missing here? Private Sub CloseForm_Click() On Error GoTo Err_CloseForm_Click Dim STCA As String If Me!STCA Is Null Then MsgBox "You Did Not Enter A Short Term Corrective Action", , vbCritical DoCmd.GoToControl Me.STCA Else DoCmd.Close acForm...

Try This. Private Sub Command20_Click() On Err GoTo Err_IssueClosed_Click Dim SQL As String Dim mu_id As String Dim tech_num As String Dim Name As String Dim SBC_ID As String Dim veh_num As String Dim page_num As String Dim vts_num As String mu_id...

I am writing an "Insert Into" query that when activated (via a check box event procedure) will insert into table "NCStatusChange" the following fields: NCNumber SystemNumber DateTime UserId via a SQL query. The data is being pulled from a form called "frmEngByNCNo". Unfortunately it is not...

Ok. This ws more of an honest effort...but I'm still missing something. It's now giving me a "syntax error in FROM clause" SELECT [Forms]!ReturnedFromInspect.systemnumber, [Forms]!ReturnedFromInspect.PartNumber, [Forms]!ReturnedFromInspect.QtyReturnedFromInspect...

Thank you for your reply. And in answer to your question I'm afraid that the answer is "Yes, very much blah, blah, please". Below is where I am currently at in the update form. QtyReturnedFromInspect is the field that I am updating with the manual transaction. "PartSentToInspect" is the...

One workgroup file should be sufficient for all databases as long as you are useing a command line in the sortcut to specify the location. For example: "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "Q:\Austin Site\QA Austin\Copy of Receiving Inspection Log.mdb" /wrkgrp "Q:\Austin...

I am using access 2002 xp. my database is tracking material movement through a production floor. When a qty is moved from "inspect" to "hold" I am trying to make one transaction count as two by: click on "hold" button. systemnumber partnumber userid date time all autopopulate from current...