Search results

OK, the this seems to be working but with some strange results. The first time I created this and ran it, all worked perfectly. I got the results I was looking for. Then I saved it. Ever since then it is now asking me for a Parameter Value for GroupingField everytime I run it. Why is it...

Sorry....there was a typo. The second ID should read MH-E11-0003.

Here is an example for manholes MH-E11-0002 and MH-E11-0003: Date - ToMH - FromMH 27/10/2011 - MH-E11-0001 - MH-E11-0002 27/11/2011 - MH-E11-0002 - MH-E11-0003 27/10/2011 - MH-E11-0058 - MH-E11-0003 27/10/2011 - MH-E11-0003 - MH-E11-0077 This should produce two 'groups'. One for MH-E11-0002...

Hi, I'm trying to group based on two fields. The FROMMH and the TOMH contain ID values for manholes and I want all of the results for (as an example) MH-G10-0001 to show up in the same group, regardless whether they are the FROMMH or the TOMH. I've tried to set my grouping expression to...

That's exactly what I needed. I think I was getting messed up in the UNION query by not giving a common alias to each one....like MH. Here is my final query: SELECT DISTINCT MH FROM [SELECT JETTING.toMH as MH FROM JETTING UNION ALL SELECT JETTING.fromMH as MH FROM JETTING UNION ALL SELECT...

Hi, I have two tables with similar data. Table A has ToMH and FromMH. Table B has MH. I need to get a comprehensive list of all MHs from both tables, grouped so there are no duplicates. How would I do this in a query? Thanks,

OK, I figured this out. I can download the PNG file from GoogleMaps, save it to a file, and then show the downloaded image in an Image object on the form. Here is the code for anyone interested. Option Compare Database 'This is an API we can use to download the Google Maps image to a file...

Hi, I'm trying to create a report that would use a static map image from Google Maps on each page of the report. I use some GPS coordinates from the database to help generate a URL to show the image from Google in a Web Browser ActiveX control. Is there a way I can use this ActiveX control on...

This works in .NET. Just modify it for VBA. Public Function FileInUse(ByVal sFile As String) As Boolean If System.IO.File.Exists(sFile) Then Try Dim F As Short = FreeFile() FileOpen(F, sFile, OpenMode.Binary, OpenAccess.ReadWrite, OpenShare.LockReadWrite)...

Hi, I have a couple of SQL queries that I use in .NET to update some tables in my database. After I replicate the database, one of the queries no longer works. The first query updates the parent table. The second query uses the RECORDNUM from the first query and updates the child table but...

Yes, it appears the Nz function causes issues. Thanks.

Hi, I created a query in my MS Access database. I'm trying to add the query to a dataset I've created in VS2008 by dragging it from Server Explorer into my dataset. My problem is that my query shows up under 'Functions' (ie. NOT under Views), and when I drag it into my dataset I get a Merge...

Hi. Thanks for the help, but that isn't quite what I am looking for. It gives me the grand total, but I only need the total for a given week....not all weeks. I figured out how to do it using three queries: 1. Query all the Road Patrols by week (qryAllRoadPatrolsByWeek) SELECT...

Thanks for the advice. I still can't get it to work. I'm not totally sure where the Nz function is supposed to go, after trying it on various fields. I've attached the DB with some sample data in it. Could you have a look at it and show me where I need to alter my queries?? There are 13...

Hi, I have a table that has a record each time a road gets patrolled. I have another table, that has all of the roads. I also have a query that tells me how many times a road was patrolled in a week. What I want to do is get a list of all road patrols for the current week for all roads, but...

Awesome. Thanks for your help. I guess having that extra RECORDNUM in the query made the difference. Why does it matter though?

OK, I've attached my db to this post. The report with the issue is rptWinterNightPatrol (access it through the Reports, not the form that pops up on start up). Other than some formatting, the report comes up as I want it, but I want to get rid of the 'Missing Parameters' dialog box.

Hi, I have a main report that is working fine. Once I add a subreport, link the two using the RECORDNUM in each, and then run the main report, I get prompted to enter a 'missing parameter' called 'tblWinterNightPatrol' .... which is the tablename of a table in the main report. I don't get...

OK, so here is the problem. If you had the report open in Design View, you cannot reference the OpenArgs. The report has to be completely closed, and then opened via the form for this to work. Strange, but true. I guess it's just one of those MS Access 'things'. Thanks,

Hi, I'm trying to pass a value from a form to a report. In my report I do this when a button is clicked: DoCmd.OpenReport stDocName, acPreview, , , , "2008" On the report in the _Open event, I do this: Dim dateString As String dateString = Me.OpenArgs I get an error saying 'Invalid use of...