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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: lr999
  • Content: Threads
  • Order by date
  1. lr999

    Creating a text file automatically

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

    Snapshot button need a code for a variable to separate snapshot file

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

    VBA sample code to use a control button to move a print doc to PDF

    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]...
  4. lr999

    Export from an Access Form to Exel one record at a time

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

    Required Fields on a Form entry

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

    VBA code for yes/no field on a form

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

    Count on a report not working

    Hello I've got to count a Verified field (yes/no) on a report which have a Funcmodule footer and a Report Footer. I need #Verified and %Verified ; So my code =Count([Verified]) and =Count[Verified])/([Verified Grand TotalCount]) on both footers. It's not working and I can't...
  8. lr999

    Count field as a variable

    I have a field with 0 or -1 value, I need to add a count for this field on a report. Can you provide a sample of vba code for this variable
  9. lr999

    vba for a print button on a form

    Hello How to code the print button on a form, for a single sript record, currently it's printing all records, i need to print only one. Thanks
  10. lr999

    print button

    how to code print functionality in the form
  11. lr999

    Combo Box sort

    how to sort data in alphabetical order in a combo box?
  12. lr999

    combo box list width

    I need to define a list width for a long text in a combo box, I have 5", but it's still not enough, the text is varying in size, the column widths is 1",4".
  13. lr999

    how to code an error msg " are you sure you want to delete?"

    How to code 'delete scipt' button with a custom confirmation 'Are you sure you want to delete?
  14. lr999

    how to code ms access alert

    How to hide MS Access alert ("You are about to delete one record")

Part and Inventory Search

Back
Top