Search results

I have a Access 2003 database called HA_PAD.mdb on a shared drive. My colleague created a workgroup HA_PAD.mdw file. But I'm not sure if the HA_PAD.mdw was created correctly. We are asking new users to join the workgroup manually by following the directions below: Open MS Access. (Via a...

I got it! I replaced this: Set rst = CurrentDb.OpenRecordset(qry) with this: Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim prm As DAO.Parameter Set db = CurrentDb Set qdf = db.QueryDefs(qry) For Each prm In qdf.Parameters prm.Value = Eval(prm.Name) Next prm Set rst = qdf.OpenRecordset...

Bob, If you're still there... Is it possible to use your code to export to Excel if the query I want to send to Excel is a crosstab query that has 2 parameters? (The parameters are 2 values from two combo boxes on my form). One parameter is called [Forms]![frmEscalationReports]![cboEscalation]...

I figured it out! Yeah. If anyone is interested, my Value SQL for my Crosstab query is: Expr2: IIf(First([CodeGrouping]) Is Null,Count(tblEscalationReportsDetail![Criteria Code]),IIf(First([CodeGrouping]) In ("Dev Underrun","Dev Overrun"),First(FormatPercent([dev cost...

Anyone have any suggestions for me? thanks,

some more information. I'm almost there... I'm trying to write an IIF statement for the Value of my Crosstab query. If you open the attached database, chose a Report and a Date and click the button, you'll see the query (qrySummary) shows 2 columns of percentages. Then there are '1's in the...

Just wondering if anyone had any suggestions. Thanks!

You're right, the query is a crosstab query that takes 2 values from two combo boxes on my form. But, you know, I can live with keeping: DoCmd.OutputTo acOutputQuery, "qryTest", acFormatXLS, XL, True If you are interested, here is my query SQL: PARAMETERS...

Now I'm getting: 'Too few parameters. Expected 2' This is what I have: Private Sub Command28_Click() Send2Excel ("Qry KPI Detail Report- Escalation Summary") End Sub '--------------------------------------------------------------------------------------- ' Procedure : Send2Excel ' Author...

Now I'm getting a message: "Loop without Do". It highlights: For Each fld In rst.Fields ApXL.ActiveCell = fld.Name ApXL.ActiveCell.Offset(0, 1).Select Loop

I am getting 'Type Mismatch'. This is what my code looks like: Private Sub Command28_Click() Send2Excel ("qry KPI Detail Report- Escalation Summary") End Sub '--------------------------------------------------------------------------------------- ' Procedure : Send2Excel ' Author : Bob...

Can I write an expression in a crosstab query to do a calculation for my Crosstab Value? Please see frmEscalationReports in the attached database. Choosing values from the 2 drop down boxes and clicking on the button opens the crosstab query. Currently my Crosstab Value just gives a count...

wow, impressive! i tried the code, but i have a query, not a form. therefore, i tried to change: "frm As Form" into "qry as QueryDef". But then it didn't accept: "Set rst = qry.RecordsetClone" Can this code be used for a query? thanks!

Instead of making a Toolbar, can I write code to automatically show my query data in a temporary Excel file? The code would be behind a button on my form. The 'temporary' part is what i'm struggling with. When I try: DoCmd.OutputTo acOutputQuery, "qryTest", acFormatXLS, XL, True it prompts...

Great. Thanks. This is very helpful. thanks again!!

Great. Thanks. This is very helpful. thanks again!!

Thanks for writing. I followed the link's instructions and was able to create the menu toolbar. But instead of creating this custom toolbar, there's not just a way to make the Access toolbar I want appear when opening up the query from the form? For DateSerial(Year(Date())...

2 questions if I may: 1). In my Access 2003 database, under Tools, Start Up, Allow Full Menus is unchecked. I have a form that opens a query. When that query opens, I would like to activate the Tools, Office Links menu. Then when the query closes, I would like the Tools menu goes away again...

Perfect!! it works. Thanks!

Can I make a crosstab query that filters from a value in a combo box? When I try, I get a message that "The Microsoft Jet database engine does not recognize 'Forms!MyFormName!My ComboBoxName' as a valid field name or expression." Please look at the attached database, at the form called...