Search results

I couldn't find a similar question already answered, so here it goes. I have multiple tables used to store information on different research materials: table Books: - BookID - Author - Title - Year - Cabinet table Papers: - PaperId - Author - Title - Year - Cabinet table Catalog: - CatalogID...

Hi there! I've been using this code to send an email directly from my form and it worked great with Outlook 2000. Now that I've upgraded to 2003, the email gets created but the message body is blank! Here's what I'm using: Private Sub Image137_Click() On Error GoTo err_image137_click Dim...

Is there a way to create a menu that shows up when the user right-clicks a record on my form? The same type of context-sensitive menus used in other windows applications. Thanks. daniel

A user recently showed me a problem he was having. We're using a split database with user-level security and this guy was changing his password for a new one that contained two capital letters in the beginning (e.g. ABcdef). Access wouldn't give any error messages but when trying to logon back...

Does anyone know if there's a way (or a freeware or the like out there) to print a report showing users, groups and their access level to database objects? Something showing that group A has read access to such and such forms, reports, etc.... This would be very helpful in documenting my...

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

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

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

Hello! I need to create a report that compares 2002, 2003 and 2004 data by month by week (defined as groupings of 7 days). I've created a cross-tab query with the data I need but am having trouble with the report... can someone help? See attached what I mean. The cross_tab_report.jpg is the...

Hi, I've searched the forum but couldn't find an answer for this one... if it has already been answered I apologize. I have a table with data for 2002, 2003 and 2004. I need to compare weekly data but we know that week1 in 2002 will not have the same number of days as week1 in 2003 or 2004. I...

Hi, I've searched the forum but couldn't find an answer to this one... I have a form based on a query that summarizes a table showing only ID, Name, etc... and a button to open a second form where I show the details of the selected record. I'd like that when I click the button, the form...

How to recover an autoformat option I accidentally deleted one of my autoformat options... is there a way of bringing them all back to the original settings? thanks! daniel

Hi there, I'm running Access 2000 and have the following problem: In my form, I have a text box (F_Path) with the file path to a word document. The code I'm using to open it works great, but when there's no path or an invalid path, it brings up an unfriendly error message with the options to...

I have a Dsum function in an event on a subform that reads: Totals = DSum("[Paid_Amt]", "tblPayments", "[Custcode] = " & Me.CUSTCODE) The problem is that when executed, I get the following error message: Run-Time error '2471': 'The object doesn't contain the Automation object 'ABC." (where...

Simple question: how do you do a word mail merge when you have the following table structure: table: Customers customerID customername customeraddress table: Invoices customerID invoice_no invoice_total It's a one-to-many relationship between those two tables and my letter in word needs to...