Search results for query: *

Hi I probably want to create a user friendly form with command buttons to clear the old data table and reload the new montly data and than have a command button to run the macro! Thanks

Hi I probably want to create a user friendly form with command buttons to clear the old data table and reload the new montly data and than have a command button to run the macro! Thanks

Hi I'm new to access, so bear with me I need to move an Excel file on a monthly basis into an Access table and than create a text file. I created a Macro to TransferSpreadsheet and TransferText commands based on a table. How is the best way to automate this procedure for user friendly monthly...

Where the output name of the file is, which is 'script.snp' DoCmd.OutputTo acOutputReport, stDocName, acSnapshot, "L:\Hopes\UAT Management\Script Library\script.snp" thanks

Hi I need to add a variable to the output snapshot file, to be able to print the name with a new 'step#', when the user press the 'snapshot' command button on the form. Never done this before, My code is: Private Sub PrintPDF_Click() On Error GoTo Err_PrintPDF_Click Dim stDocName As...

Hi I tried the code, but I'm working in Access 2000, there is no PDF support, so acFormatPDF didn't work. Any other code samples?

I need to use the same print button for PDF. the following is the print button code: Private Sub Print_Click() On Error GoTo Err_Print_button_Click Dim stDocName as String Dim stLinkCriteria As String stDocName = "Script" stLinkCriteria = "[ScriptID]=" &Me![ScriptID1]...

Hello! Can anybody provide a sample VBA code to make the 4 fields from the Script form data in Vertical and ScriptDetail subform data Horizontal,on the exel spreadsheet at the time of export. Thanks SELECT Script.ScriptID, Script.[Script#], Script.ScriptEntryCriteria...

Public Sub ExportScript() 'Export Scripts to Exel Dim strmsg As String strmsg = "Are you ready to export the Script?" strmsg1 = "Export completed and the files are located in the directory:" If MsgBox(strmsg, vbYesNo, "export File") = vbYes Then...

SELECT Script.ScriptID, Script.[Script#], Script.ScriptEntryCriteria, Script.ScriptDataConstraints, ScriptDetails.[Step#], ScriptDetails.UserAction, ScriptDetails.SystemResponse FROM Script INNER JOIN ScriptDetails ON Script.ScriptID = ScriptDetails.ScriptID WHERE...

SELECT Script.ScriptID, Script.[Script#], Script.ScriptEntryCriteria, Script.ScriptExitCriteria, Script.ScriptDataConstraints, Script.Comments, Script.[Reviewer Comments], Script.ScriptDeveloper, Script.[Ready for Review], Script.Verified FROM Script WHERE...

SELECT Script.ScriptID, Script.[Script#], Script.ScriptEntryCriteria, Script.ScriptExitCriteria, Script.ScriptDataConstraints, Script.Comments, Script.[Reviewer Comments], Script.ScriptDeveloper, Script.[Ready for Review], Script.Verified FROM Script WHERE...

it's transfers all the records and I need one record at a time, my record have a field Script ID which is the key, whenever I press the button on the form EXPORT Script, I need Only one record to be exported to Exel ,for that Script Id key thanks

sorry of course it's data, but I need to transfer one record at a time: here is my code: Public Sub ExportScript() 'Export Scripts to Exel Dim strmsg As String strmsg = "Are you ready to export the Script?" strmsg1 = "Export completed and the files are located in the directory:"...

I need a sample VBA code to transfer a form to Exel by Script ID

Hello I need to make 'script#' and "script developer' required fields on script form. I used the following code: Private Sub Form_Close() If IsNull(Me.Script#) Or Me!Script# = "" Then Me!Mes.Caption = "Script# Can Not be Blank" Me!Script#.SetFocus valFields = False If...

sorry not working both ways: "=Count(Verified)" for the Total "=Abs(Sum(Verified))" for the 'Yes' count "=Count(Verified) + Sum(Verified)" for the 'No' count. or sum([fieldName]) * -1 : total true records sum([fieldName] + 1) : total false records...

That is some help you provided, thanks!!!

No I didn't get, because I didn't explain it right

Could you, please provide a sample of an OnClick code for a yes/no field on a form. When I'm trying to sum on my report this 'Verified' field, I get the words 'yes' or 'no', instead of counting, if the Verified Field is checked -it's a Yes, If it's not checked - it's a No. In Table 'Verified'...