Recent content by MarcelMegens

I was hoping for an easy way to simplify overcomplicated iif statements. I agree with you both that I sometimes would have to step back, decide that a function is more suitable and rewrite the iif... ;(

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

MEGA MEGA Thanks!!!

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

Examples if YearZero=3 this field should be something like this: 0A: [0]*[Models].["y"&YearZero] and should give me 0A: [0]*[models].[y3] And A1 1A: [0A]*[Models].["y"&YearZero+1] should give me 0A: [0]*[models].[y4] (The duplication by not linking the calculation Model is intentional, so 6...

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

Better example and Table attached here! Thanks! Helps a little, but not what I was looking for. I have attached a visual example of what I want. I have also created a Sales table with the right field names. Hope you can help.....

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")...

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

I want to find out how much KB space an existing table uses Yes Indeed, I need to know the (approximate)size of a table so I can determine for which large table I should consider revising/optimizing. (Hup Holland hup!)

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

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

:) 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...

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

Try this See attached doc. Basically use the wizard of the Task Scheduler to fill out the basic stuff. Then alter the properties of the created icon. If this doesn't work, let me know what error message you get.