Search results

Mile, my code is attached to the first message. thanks.

How did you clear your listview items? I'm having trouble with that. By the way, my listview is based on a SQL query to populate the rows. thanks! daniel

Yes, I tried that, however the answers given did not help me at all. I'm not a VBA expert so I may have misunderstood some of the directions or applying them to my particular case. If someone could take a look at my code and point me to the right direction I would be very very very thankful! :)...

I'm populating a listview control with a query from an 'onclick' event of a command button on my form. It all works fine up until the point where I want to supply a parameter (combo box) to my query so I can re-build the listview with the filtered result of my query. Pasting the SQL code on a...

Forget about it! Just got the answer by searching on another forum. For those intersted on how to do that, here goes the code: Private Sub ListView_ColumnClick(ByVal ColumnHeader As Object) ' When a ColumnHeader object is clicked, the ListView control is ' sorted by the subitems of that...

Hi All, Couldn't find an answer for this one... I have a listview control in a form that is being populated from a query. I would like to give the user the option of clicking on column headers to sort the contents of the listview. Is there a way to do this? I know there's a sort property I...

I have an Access 2000 database split and each user has a copy of the frontend file. I've configured user-level security using access security wizard and created different groups with different security rights. OK, the problem is: I grant a group the "delete" access to a particular table. I...

I have created several reports in my database (Access 2000). The last one, however, seems to have a problem. When I finished with the design and clicked the preview report icon, it opened, closed and went back to design view. I tried again but it didn't open in preview mode. I closed the...

I have a report that shows how a rep is doing in sales in a particular month. The sales of the rep are broken down by two lines of products (ProdA and ProdB). For example: ======================= Rep..........Product.........Sales JOhn.......ProdA...........$5,000...

Not quite Pat, If I do what you suggested, I'm going to get as result of my query something like: Family A - $$$$ Family B - $$$$ And the query will add all items in all invoices that belong to each of the families. The problem is that in invoice # 3 in my example (1st message on this...

This query may be simple but I can't make it work... Here's the situation. I have several products, each product belongs to a product family. For example: Family A contains: Product A.1 Product A.2 Family B contains: Product B.1 Product B.2 I have the following invoices: Invoice #1 Product...

Hi Brian, I got sidetracked the past few days but am back to the database again. I did a workaround that consists of passing the value of the combo box to a text box on the same form and referencing that combo box in my query. With that it is now working... not sure why it would accept the text...

Year is being pulled from another combo box in my form. With that, however, I'm not having any problems...

I tried using Between as well but the result is the same... Looking more into this, I discovered that when I enter "1" and "2" as parameters, the results are: 1 10 11 12 2 It seems that it's considering my entries as text and not as number. The field I'm querying is a datepart of a date...

I'll try that. Thanks, Pat. :)

If that was the case, if I hard coded the numbers in place of the forms syntax (forms![...]) it wouldn't work... but it does! daniel

Hi there! I've tried everything and can't figure out what's happening... I have a query that has a criteria based on two combo-boxes I have in my form. Although the combo-box works and the field names are all correct, the query messes up. Here's what I have for my query criteria related to a...

Can I use a Dsum function in a control box in my report and point the Dsum to a query that is not the recordsource for the report? I tried the following in a text box in my report: =DSUM("[quota]","qryQuota_Qtr") I get #error as result... this qryQuota_Qtr is not the query in my recordsource...

Forget about it... I solved the problem by using a sub-report based on another query that gives me the totals per year. :)

Not yet done Oops! It seems I got ahead of myself... another question related to this report: Is there a way I can add yearly totals at the end of the report? something like: Year...Total 2002...$$$$ 2003...$$$$ 2004...$$$$ If I use a calculated field and have in the control source...