Recent content by skunk711

[YourListControl].listview.clear that should clear the items.

I've followed up on my last idea and have got a copy of a recordset that contains exactly the data i need for the report (ie: blanks rows for the last rows of the recordset) but I can't assign the recordset as the recordset of the report when it opens. Is this possible???

HI, I have a report that needs to have 13 rows in the detail section of the report, with a report header and footer. My problem is that sometimes there will only be a couple of rows of data in the recordset, hence I am only getting two rows in my detail section. Is there a way to get around...

I'm not sure if this is possible, but I have a query that I want to calculate the max value in the table, and return both the max value and another field in that same row. The problem is that I can get the max value easily enough, but I can't get the id number at the same time as it spits out a...

Thanks for the links Wayne... There was a link inside one of the links you suggested that was to a technet article that has some useful suggestions for the problem. I'll let you know how they go in a week.

I am having a problem with one of the database tht I maintain. It is a split database with the Client file sitting on a local PC and the backend on a server. A couple of weeks ago the Client end kept popping up with the error message "MODULE NOT FOUND". So I imported all of the objects into a...

Well the answer to your last question is that I have a seperate record for each transaction. I may be wrong (or maybe what I am after is not a weighted average at all, perhaps it is a FIFO queue) but I was hoping to organise something along the lines of: Receive 10 items at $1.00 Receive 10...

I have a database that I have been maintaining for a while the serves as an inventory control DB. It supports the recevial, transfer, return and issuing of items. Everything works perfectly, but I'd like to extend the functionality of the DB to use a weighted average for the value of the items...

yeah, I was hoping when i first decided to imlpement a listView that it would be a matter of assigning a query as the datasource. However, I quickly found out that although they are great for having users resize columns, change column orders and sort by columns to find what they want, the...

Thanks for the reply! I had tried that previously and i had obviously used the wrong syntax. Your post made me try it again using: lvOrderDetails.listitems.clear() and it worked like a charm. I have another thing you may know something about, but I'm not so sure there is a better solution to...

Hi, I have a ListView activeX control on my form and I am looking for a better way of removing all of the rows from my ListView control than what I am currently using. At the moment I am just ittirating through all of the rows and deleting them until I get to the end of the list. This works...

Hi All, I am working on this DB that is quite big, and it is split. Last night whilst working on a form, another one of my forms completely stopped working. Whenever i tried to open it, nothing at all happened. Whenever i tried to design it nothing happened. The same for some of the subforms...

I have an Inventory Tracking Database that has a Head Copy that updates and maintains the Master Item list, and places this list on an FTP server for other Depot copies to download. The depot copies do all of the transactions (receiving, issuing) of items. I have now been told that the way...

Here is the function that returns a String of employees allocated to a Section: Public Function findPrep(st As String) ' This function returns a String of all staff members allocated to a section ' in the Responsibility Assignment Matrix. Dim rs As Recordset Dim qd As QueryDef Dim qrySt...

I'm probably explaining this poorly, but I'll try and give it another go. The query the list is based on has a column in it the concatenates multiple staff name together (eg: John Doe, Jane Doe). This column gets its data from a function I wrote that opens up a recordset, and loops through each...