Search results

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

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

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

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

I have a list box that uses a hardcore vb function to populate one of the columns in it. I don't want the list box to get requeried every time I add a new record, or change to another tabbed page an then back again. Is there any way to stop the list from being requeried all the time, only...

I'm having a problem where docmd.sendObject will only output the e-mail the first time I click on the button. Every other time after this, it executes the code all the way to the docmd.sendObject statement and does nothing. There is no error being thrown either. Any ideas?

I'm having problems with a subform that has a list box and three fields under the list box. All i want to do is have the fields under the listbox display with the record clicked in the list box. I've done this heaps of times before, but can't quite work out why this one is any different. I...