Search results

  1. M

    Flow chart from VBA IIF function

    I frequently use complex iif statements in queries or in VBA and after a certain number of months when I look at these functions, I first have to manually draw a flowchart to see what the statement actually does. Is there an automated way/tool which could do this for me. (then I could also...
  2. M

    How to generate in VBA a "File, Open window"

    I have created an VBA from a macro See below: The name of the text-files varies from time to time, the rest of the process doesnt. Can someone point me in the right direction (or send an example) how I could replace the hardcoded filename"C:\Documents\CHK.csv" with the code that would open an...
  3. M

    Build a Dimensional fieldname in a query

    As example, I have a table with an Item number, introduction year and a number of historical and future Sales periods set per year, these sales columns are listed Y1990, Y1991, Y1992....... Y2015. Based on each items introduction year, I want to list the first 5 years of sales. I wanted to...
  4. M

    First 10 months of sales, seems simple, but proven to be a horrorcase.

    I have a table with historic sales values, so an Item has 36 months starting (Field names are ranging from "Oct 04", "Nov 04", "Dec 04" ... to "Sep 07") I also have a column name First month of Sale. which is filled with for example "Dec 04", for the next Item is might be "Jun 05" or "Aug 06")...
  5. M

    Docmd.sendoject("query A") where [query A].[Invoice number] = SearchInvNr

    I would like to use the sendobject function but in a way that I only get lines where a certain criteria is met. E.g. Dim SearchInvNr SearchInvNr = "12345" and then Docmd.sendoject("query A") where [query A].[Invoice number] = SearchInvNr note: [Invoice number] is the field name in the...
  6. M

    How do I know how much space a table uses within an MDB

    Hi there I would like to know how to find out how much space a table uses within an MDB. is there a analyser of some kind available that you know of? Thanks
  7. M

    VBA to add a closing record in a CSV file

    I have exported a CSV file from a table in access using transfertext in a macro. This works fine, but the receiver of this file wants to see a 9999 closing record in the CSV file without any junk after it. I have tried adding a 9999 record, but this results in 9999 followed by a bunch of commas...
  8. M

    Stored flexible filtercriteria in a table (novice)

    :) I have 2 tables: 1 with 3 columns (Partnumber,Types and Functions) containing product information and 1 with 3 columns: Types, Functions and Partsgroup containing Filtercriteria. In the end I would like to have 1 query that shows me the first table with the Partsgroup added. (looks simple but...
  9. M

    Email Parameter dependant copies of 1 query to different emailaddresses

    Based on the a parameter given (Representative code) I want to be able to make a selection in a sales report so the Rep only receives data needed for his sales. In the end I want to start 1 macro which would trigger (12 representative dependant queries) and email them automaticly (I don't use...
  10. M

    make table query with an index field?

    I use quite a few make table queries, the only problem that I have is how to automatically create an index field(other than generating it manually through table design) I have no problems working with access macro's but I'm a "no-go" as far VBA is concerned (unless I can copy a piece of VBA...
Back
Top Bottom