Recent content by PCLewis

I can't reproduce that issue. Even when I create a column as Single data type with 2 decimal places, the output of integer values of that column remain as they should. No decimal places or trailing 0's. If you could tell me what the column typ eis and the properties, it might help.

You can't do it with just a query. If your query is bound to a report or a form then one approach is to create another form to open the object you are after (i.e. the report or form to open). In the popup form you can allow the parameters to be entered, and then in code, change the contents of...

Incidentally, for future reference, if you want to re-dimension an array, You can declare it and re-dimension it like this: Dim x() as String . . . ReDim x(20) as String ' this clears the data already in the array . . . ReDim Preserve x(30) ' This preserves any existing Data

No. If you need to allow both people to work on the same modules at the same time then you are ruined. You cannot do it unless they sit on the same chair and use the same keyboard/mouse :) If you want them to work on different modules/classes/forms then you could make two copies of the MDB...

If you are saying that myArray(1,4) = myArray(2,4) and that the instructions after the Then statement are being run there are only two possibilities. 1) you made a mistake - under no circumstances will Access do that. Perhaps myArray is not a simple data type - maybe you have declared it as an...

I tried posting this several hours ago but unfortunately there was some proxy problem at my end (I think) Well, if you set the report's recordsource to an sql statement, simply extract the criteria from Me.RecordSource and display it on an unbound text box in the section's Format event. If you...

If you were asking about editing records within the crosstab query then certainly you cannot. You can certainly have a crosstab query as the recordsource of a form but of course, no edits are allowed. I notice you useing the Case..End SQL in your example above. If you are more at home...

The Exit For in your code is not good. I assume VB is clever enough to unwind the If..Then branch that you are in at the time but it's not a good practice in my opinion. Especially when more logical alternatives are available. If you put the Exit For after the If..Then, it would be more...

Dir when called will look for the file or path provided in the first parameter. So if you provide a parameter of "Massive Attack - Protection.mp3 " and if DIR returns with "Massive Attack - Protection.mp3 " then you can be sure that the file exists in the directory specified. Since no...

You can use a query similar to your original query as a sub-query and use the IN clause if you prefer that over the domain aggregate function. e.g. DELETE FROM MB51YTD_Table WHERE MCP IN (SELECT MCP FROM MB51YTD_Table GROUP BY MCP HAVING Sum(Quantity1)=0) That might do it (not sure if...

What you are trying to do is called a crosstab query in Access. There is a limit to the number of columns though - maybe about 250 or so. What you should do, is start with a crosstab query that the wizard creates and then build up your criteria from there. I'd recommend considering using a...

Take a look at Right$, Left$, Mid$ functions in your VB help.

I agree. For your purposes, DIR is not ideal. Other examples of when dir$ will give you a result that you don't like could be filenames in your file that are directories. e.g. ".", ".." To answer your question though, I have never seen an example of DIR returning a non empty string when the...

r937 beat me to it and was rather more succinct ;)

My concern is that according to something I remember reading a long time ago, nothing guarantees that the top n records will be the same top n as next time unless you use a sort criteria. Access seems to return the same top n every time when no search sort is specified (It seems to return rows...