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 Rhinorhino 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: errolf
  • Content: Threads
  • Order by date
  1. errolf

    Workdays And Holidays

    I am using the the following Function to calculate Working Days. I have a table of Holidays with 2 Fields Holidate(Field Type Date) Name (Field Type Text) The Code works fine when the day in the Holidate field of the table has more than 1 digit but it will not work when it is a single digit date...
  2. errolf

    Comparing data between years

    I need to compare the data between 2years. I have a query that is run from a form that uses parameters between 2 dates from the form. Ineed to compare the date from the same period in the previous year. eg Between begindate a endDate and between begindate-365 and endDate-365. This gives me the...
  3. errolf

    Dynamic update of Text Box

    I am using a form as a General purpose switchboard for an application. One of the functions of the form is to update data from text files exported from another application. I am using a text box to display the date of the last update using the function =DMax("[INV_DATE]","SCEX").Unless I open...
  4. errolf

    Using Function for field headings.

    I am using a function Modified() that calculates when a file was last modified. I want to use this function to create a heading in a query eg. [Stock_On_hand] As SOH & Modified. I am using the following code in a Command Button but cannot get it to work. Private Sub CmdMthly_Click() Dim db As...
  5. errolf

    Dynamic Crosstab Report does not print as shown in Print Preview

    I am using a report that uses code to generate Dynamic Column Headings. The report appears correctly in the print preview mode but when printed the report only prints multiple records of the last record on the report. Any help appreciated Errol
  6. errolf

    Parameters in Report

    Iam using a form to send Parameters to a Query used to generate a report with Dynamic Column headings. I can get the report to work to work until I use a second Query to get further data. The error message is "To few parameters expected 5" The following is The query SQL:- PARAMETERS...
  7. errolf

    Input Mask in Text Box on form

    I am using a text box on form to input records to a table. I need to to prefix each record in the table with the letters CPFE. The Input Mask that I am using a present is "CPFE"&&&&&&. This shows correctly in the text box but only the numbers are transferred to the table and not the CPFE...
  8. errolf

    Transferring value from Combo Box

    When I use a combo box on a form to transfer a value to an update query the value transferred appears as a small square and not the value in the combo box. Combo box code SELECT T_PICK_STATUS.NO_STATUS, T_PICK_STATUS.ID_STATUS FROM T_PICK_STATUS; Command Button code Private Sub CmdStat_Click()...
  9. errolf

    Counter on Output File

    Iam exporting an Access report to to an RTF file. I want to rename the file on each output by an automatic increment of 1 EG Order1,Order2,Order3 and so on. I am using the following code Private Sub CmdExport_Click() On Error GoTo Err_CmdExport_Click Dim stDocName As String stDocName...
  10. errolf

    Hiding a text box on a report conditionally

    I am using a report that creates a Price List. Under certain categories I dont want a second price to appear. I am using the following code in report to try and make this happen. the code works for the first condition but will not operate on the "And" section of the line marked in red...
  11. errolf

    Crosstab Query

    Iam using a crosstab query that uses a function that should return a possible 3 values Commercial Retail or Not Valid the function code is as follows Function RetGrp(MyGrp As Variant) Select Case MyGrp Case 1 To 11: RetGrp = "Retail" Case 22: RetGrp = "Retail" Case 25...
  12. errolf

    Column Headings

    I am using a Form to run a crosstab query that has date column headings, I want the column headings to change according to the dates in the selected parameters from the input form. I am us the following SQL at present Private Sub CmdSelect_Click() Dim db As DAO.database Set db = CurrentDb...
  13. errolf

    Removing Fields From Query using form

    I have a query that gets its criteria from a form. Is it possible to remove or replace fields in the query from the form in order to increase or decrease the data required. TRANSFORM Sum(round([NETT]-[gst])) AS Sales SELECT SCEX.AC_NO, DREX.NAME, DREX.CLASS, retgrp([SCEX].[CLASS]) AS GRP...
  14. errolf

    Insert section into Access report

    I have an access report that produces a price list. I need to insert into the report a special section to cover retail products that are alredy in the price list these products are already shown in their respective categories and I need them to still be in their general category but if they have...
  15. errolf

    Report in 2 formats

    I have a report that needs more columns in first six pages and for the first six pages to be printed in Landscape format. The rest of the report is printed in Potrait format with a lesser amount of columns. Is there any way to change the format with code so that I don't have to print and...
  16. errolf

    Moving data in one field up 1 row

    I have a table of imported data with 2 fields,I need to move 1 field up uniformly 1 row in order that I can use the imported data eg: P/N Supplier 1234 Null SuppName Change To 1234 SuppName I have been putting the data into Excel and moving 1 column up 1 row but I would like to get...
  17. errolf

    Deleted appears in fields on forms

    I am trying to use a form to enter data in a table. The form has a button in it that first deletes all the records from the table then runs an append query that adds the records to the table for editing in the form. However when this operation is carried out "Deleted# appears in every text...
  18. errolf

    Change size of InputBox

    Is there any way to change the size of an input box created with the InputBox function. Thank you in anticipation Errolf
  19. errolf

    Test to see if table exists

    I am using the following code to extract text and write a report, however I need a line of code to test if the table exists if it exists continue if not jump the line and continue. Function ImportData() Dim Message, Title, Default, MyValue M
  20. errolf

    Index page for report

    I have a report and I use the the following function to create an index Option Compare Database Option Explicit Dim db As Database Dim toctable As Recordset Function InitToc() ' Called from the OnOpen property of the report. ' Opens the database and the table for the report. Dim qd As...

Part and Inventory Search

Back
Top