Search results

OK, here's a head-scratcher for the more knowledgeable amongst us. In the Design View of the source query, I changed the definition for Expr3 from: Expr3: [Forms]![BridgeRptsF]![CostSF1] to Expr3: [Forms]![BridgeRptsF]![CostSF1]*1 Now, Expr3 is a calculated field, and reports for duty every...

Sadly, database is too big to post to the site. If I right-click on the query or report, I get prompted for the values from the form as though they are parameters. When I enter them, the UnitCost value shows up in the report. When I use the macro-button to launch the report, the query...

OK, almost completely buttoned up but something is giving me fits on the report. In the SQL statement for the Select query, I changed the references from Expr3 to the forms reference, and all the calculated field that use this value are coming in correctly. IOn the report, I included a textbox...

I have a query-based report with a macro button that exports selected items from the source query to an EXCEL template. The query previously took two explicit parameter entries; now, I have the data in unbound text boxes on the form where the report is created. I did this so I could validate...

pbaldy, you strike again. That was the problem; the report populates just fine now.

Here's an excerpt of the SQL. Thanks for your time. SELECT NbiBridge.StateStrNum, [Forms]![BridgeRptsF]![CostSF] AS Expr3, NbiBridge.CurrNbiDeck, NbiBridge.CurrNbiSuper, NbiBridge.CurrNbiSub, MaintItemsT.MaintItem, MaintItemsT.ItemDate, Sum(([MaintItemsT]![Quant]*[MaintItemsT]![UnitCost])) AS...

It's just asking for Expr3. I went back and double-checked the name of the text box and it matches.

I have a query that serves as the data source for a report. Previously, I had a unit cost value that the User entered as a parameter, but I wound up adding an unbound text box on my form so that I could validate the input before executing the query. So now, the parameter is coming from a form...

Success! :) Thanks for your help. Private Sub SingleCulvertRptB_Click() Dim NumRecord As Integer NumRecord = DCount("[StateStructureNum]", "NbiCulvert", "[StateStructureNum] = " & Forms!CulvertRptsF!SingleCulvID) If NumRecord = 0 Then MsgBox "Structure ID not in database. Please...

Thank you for such a prompt reply! Your advice worked like a charm; I'm going to bump my status up to mixed success. Could I impose on you again to double-check my use of the DCount function? I can verify that the proper query is being run if the User-supplied value is in the table, but if...

I have form with a button on it that launches a parameter-based Select query (which served as the source for a report). I didn't have any validation measure in place, so if the User supplied a bogus value, a blank report was generated. While not technically an error, it would seem more...

I'm researching Run Time Error 1190 in the meantime and it looks like it's a registry-based issue. So the problem may not be associated with Access at all but rather be located in the guts of Windows itself. Looks like the solution might involve un-install/re-install of Access on this other...

OK, here is the string from the Immediate window for a typical location. This launches Google Maps on my machine. http://maps.google.com/maps?q=37.634235,-77.503828&iwloc=A &hl=en When Google Maps is launched, here is the URL that displays in the address bar when this location comes up...

Here is the expression for [MyCoord] from the source query: MyCoord: "http://maps.google.com/maps?q=" & [CoordX] & "," & [CoordY] & "&iwloc=A &hl=en" Hope this helps. Thanks again.

OK, I just slipped over to his desk and I get the following error message when I try to run this module in Access 2007. Run-time Error '1190' An unexpected error has occurred. When the Debugger opens, it is pointing directly to Application.FollowHyperlink. Many thanks for the quick response...

I am developing a database for a client that will be run using Access 2007. I have Access 2010 installed on my machine but have a gentleman in my office with Access 2007 that helps me test the database by entering data, beta-testing macros for compatibility, etc. The subroutine below works...

Finally got it up and running, thanks to everyone for your help. Private Sub CBR_Click() Dim oExcel As Excel.Application Dim oWkBk As Excel.Workbook Dim oWksheet As Excel.Worksheet Dim strFile As String Dim qSource As String Dim rs As Recordset strFile = "P:\Transportation\60277443\400...

Useful dialog, helped me greatly with my project.

OK, adding the Microsoft Excel Object Library took care of that error. Now I'm seeing that the OpenRecordset command needs two parameters. Hmmm.... CurrentDb.OpenRecordset("qryExcelWriting")

Sorry to bother, I got the code in and got all the object names updated. When I tried to run it, it gave me "User-defined type not defined" and highlighted the first line (Dim oExcel as Excel.Application). Am I missing a library reference? I've seen this declaration in other posts,so was just...