Search results

Hi, Currently I am using 3 queries to come up with the results I am looking for, but I would like to figure out the proper way to combine these 3 into 1. What I am doing is looking at a table of inspections and picking out the ones that meet a certain criteria. Here are some details: My...

Hi, In my report when the Group Header and the Detail section will not fit onto one page, it prints the Group Header on one page, and all of the Detail on another page. Is there a way to keep them together? I have already tried the 'Keep Together' option in the Sorting/Grouping window...

For some reason I can't get this to work: I have a form, with a tab control on it. Each tab has a subform to display data. One tab is meant to be a summary tab of the rest, so I want to pull data from certain controls on each of the other tabs to display on the Summary tab. If I set the...

Hi, I have a Table A that is a list of ID's. In table B, each ID (from A) could appear mutliple times, or not at all. How do I get a count of how many times each ID in Table A appears in Table B? ie. 0 or 1 or 5 or whatever Thanks,

Hi, I've done loads of research but still find dates, specifically dd/mm/yyyy dates, confusing. Here is what I have: Table FLUSHING with a date field called FLUSHDATE, format set to dd/mm/yyyy. If I make a query through the GUI (ie. Query - New), and enter the 'Criteria' for the FLUSHDATE to...

Hi, I have a label (lblDate) in the page header that I want to be visible on all pages, except for the last page. I have tried lblDate.Visible = Not (Me.Page = Me.Pages) in the PageHeader_Print section, and a few other things, but nothing seems to work. Any other ideas?

Hi, I have a table that is collecting software information installed on uses PCs. Columns are like this: USERNAME - SOFTWARENAME - VERSION - PRIORITY The users are entering a priority for each software on their machine; High, Med or Low. I have no problems creating a query to group all...

Hi, I am grouping a report based on the ID of each record. Usually there is only one or 2 items per ID, so I want as many different groups to show up on each page to avoid wasting paper. I can only get one group to show per page. How do I fix this??

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

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,

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

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

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

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

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

Hi, I have a field in a table that holds the Date/Time. I am trying to create a WHERE clause so that I can get all the records between two dates. This is what I currently have, but no luck: DoCmd.OpenReport "rptSummerReport", acViewPreview, , "SEASON = 'SUMMER' AND PATROLDTE BETWEEN #" &...

Hi, I have a control in the Page Header that I need to change based on what shows up in the Detail section of the report. In the Detail_Format event I cannot seem to modify this control (a label) that sits in the Page Header. But....if I move the control into the Detail section, I can then...

OK, So I have some VBA code that helps format my report. In the PageHeader I have a bunch of checkboxes, and depending on what is in the Detail section of my report determines what checkboxes are or aren't checked. When I run the Report in debug mode in the VBA editor, the report works fine...

Hi, I'm using the following code in .NET to insert some data into a table. The connection is already open other commands are working. mySQL = "INSERT INTO tblWINTER_DETAILS (RECORDNUM, ITEMNUM, DETAILS, ACTION) VALUES (" + recNum + ", " + "1, " + "'This is a detail', " +...