Search results

  1. H

    SQL retrieve break in dates

    Preface this with thanks for any assistance in resolving what I hope is a relatively easy fix. So, I have a table (sellable_prod_inv) with products (column_name: product_id) and inventory date (column_name: inventory_dt (mm/dd/yyyy), which contains a snapshot of inventory values by day, dating...
  2. H

    Help with DateSerial Criteria

    Preface this with thanks for any assistance in resolving or guidance, as I am sure this is simple but my VBA is limited at best. Basically, I have a DB form with a calendar date picker for a user to select a beginning date (txtClick1) and ending date (txtClick2), with the on current properties...
  3. H

    Combine 2 separate queries to achieve single result

    I preface this with many thanks for assistance. High level, I have a table source (sales) that houses both sale and return activity. I have 2 separate queries (a)qry_sales to retrieve sales and (b) qry_ret to retrieve returns by day and product the current year and previous yeard and aggregating...
  4. H

    Assistance with code to export/name file

    Hello, thanks in advance for any assistance. I have DB with a module that exports a table 'tbl_test' to a MS Excel File 'Load File,xlsx' and launches MS Excel, formats and saves the file based on a set of values. This works great (thanks to the unknown user that created) when the file is saved...
  5. H

    Query to return last date by & group

    Hello and thanks in advance for any suggestions. My issue surrounds retrieving the last (based on most recent date) set of records based on the most recent date. I have query, containing 2 tables as the sources for the query results. Currently, the query yields: Field A Field B...
  6. H

    Wingding characters with decimal values

    Thanks in advance for suggestions. Within a specific report, I have a field named ‘Rating’ that will have a numerical range from 0.0-5.0. Basically, I was hoping to insert a ratings view by utilizing special wingdings characters. I can achieve the results I need until the introduction of a...
  7. H

    Repeating dates

    Thanks in advance for any assistance. I have a basic report that lists product records by date for each date/product occurrence. Example here: Date-----------Product 1/1/11---------ABCD 1/1/11---------EFGH 1/1/11---------IJKL 1/2/11---------12345 1/3/11---------98765 1/3/11--------111111...
  8. H

    Assistance with BobLarson Code-Transfer object,format

    Many thanks to Bob Larson for the code found below!! This helped me tremendously and I am hoping that someone could assist in adding some additional pieces. I would like to add a 'save', close and exit spreadsheet function to this code, however, I have been unable to do so. Much thanks for any...
  9. H

    Split Worksheet Into Multiple Workbooks

    I preface this with "Thanks" to any assistance provided. Basically, I have a workbook that contains a single worksheet named "Details". Within this sheet is a column named "Location" (Col B), which will be used as my criteria to perform the split. What I would like to do is create a new workbook...
  10. H

    Extract nontext values before character

    Thanks in advance for any assitance. I have searched the forums and was unable to return any results (perhaps the incorrect combination of keywords to search). In any event, I have a spreadsheet that contains a text field in column C. The data in the text field is comprised of OEM part...
  11. H

    Clear Contents In Excel & Transfer Sprdsht

    Thanks in advance for any assistance! I currently have a DB in which a "transferspreadsheet" function is called and 2 tables are transferred to a "template" workbook in MS Excel named PM Upload. The tables transferred to Excel are (1) Listings & (2) Details. This is fine. What I am...
  12. H

    Report Export Issue From Form

    Preface this with thanks in advance for any assistance in resolving this matter. I have a form with a command button that is set to print an invoice report on the on click event. Code as follows: Private Sub cmdPrint_Click() On Error GoTo Err_cmdPrint_Click DoCmd.RunCommand acCmdSaveRecord...
  13. H

    Consolidating Records

    I have a table that contains specific customer transaction data. In this table there are the following fields: Document Vendor Vendor Name Units Value There are instances in which multiple records could exist for one document number. Such as: Document-----Vendor-------Vendor...
  14. H

    After Event Scan

    Help with scanning and sound. By utilizing the search feature, I have discovered issues that are somewhat relative to what I need assistance with, however nothing specific. So here we go… 1. I have a table named tblManifest. Within this table is a text field named PRODUCT and a text field...
  15. H

    Delete Records Based On Date Criteria

    I have a table that stores records by "return date". I would like to create a delete query that removes all records that fall outside of the date range entered on a specific form (frmMainMenu). I can deleted the records that match the form criteria, however that is not what I need. The...
  16. H

    Msg Box Based On List Box Selection

    I have a form that contains a list box with 11 separate options. Within this list is the option named "None". My desire is to have a message box displayed when any option is selected other than "None". I have searched various threads, however I have been unsucessful nailing down my issue. Thanks...
  17. H

    Record Consolidation

    Can someone offer guidance here? I have a table that stores liquidated inventory records. I want to design a make table query to dump selected records into a new table. Some of the more important fields in the table are as follows: Vendor Location Units Type 9998...
  18. H

    Form Background Design

    I have reviewed several threads relative to custom background designs within forms and have retrieved some great information. My question is such: Is there a way to apply a MS PowerPoint presentation design template as a background design within a form? If so, I would be appreciative of...
  19. H

    Date & Time Stamp Formula

    Good evening! With all the knowledge contained by individuals monitoring this site, I am confident that someone can offer advice to my issue. Basically, I have a table that contains productivty performance by user id. The table also houses date & time stamp (hh:mm:ss) data as it relates to each...
Top Bottom