Search results for query: *

The second option was definately the simpler solution, and it works great :D Thanks :)

Hi all, I've created a report that summarises some data for last month. I want to put a heading on this report saying "June 2003" if it's currently July 2003, "August 2003" if it's currently September 2003 etc. So far, I've got it to print "6 / 2003" or "8 /...

Works grand. Thank you :)

OK, that part works great :D Thanks. Now for the next dilemma though. This table also contains a date that the job was complete. I want the query to only show results for last month, without affecting the grouping (can you tell I've tried to do this myself already? ;)). Any suggestions...

Hi All, I'm just playing about with a few queries, and I've come across a bit of a brick wall... I have a list of engineers with scores, like so: Bloggs 1 0 0 1 1 0 1 1 0 Smith 1 1 0 1 1 0 0 0 1 Bloggs 1 0 0 0 0 1 1 0 1 Jones 1 1 1 1 0 0 1 1 0 Bloggs 1 1 0 0 0 0 1 0 1 Smith 0...

Is it not possible to just set "Control Source" property to: Query:[QueryName].count Or something? Surely there's got to be an easier way such as this? If not, could anyone supply more detailed suggestions for implementing the recordcount - the suggestion in the last post just gave...

OK, I think that once I've associated the form with the query/report things should start working a little better. I've got the button placed and named, how do I go about getting it to run the query & fire up the report when I click the button? Also, I need a count of the records found on the...

Also, once I've got the query set up how do I get the query to run from the button click on the form? How does this then go on to generate the report? Thanks :)

Okies - I'm actually using a combobox, but that should work the same (at least, it does in visual basic). When I try and enter the following as the criteria for my query: Forms![SelectContractor]![Engineer] access turns it into: [Forms]![SelectContractor]![Engineer] And I get a standard...

Hi all, I currently have a query and a report that work quite happily together, however it requires that I hard-code the criteria for the query beforehand. I'm trying to change this so that the report can be fired up by submitting the criteria (a contractor and an engineer) on a form. I've...

OK, I'm not sure what I clicked or where I clicked it, but all seems to be working fine now. Thanks :)

Still nothing :( I am right in saying that the row source type should be table/query aren't I? Other than that, I'm pretty much out of ideas :(

OK, I've got as far as making the bottom box drop down once the contractor is selected (which proved the first bunch of code is working, and thus it's just the query needs refining). The combo boxes are called "Contractor" and "Engineer". The form is called...

OK, done that. Once I've selected a contractor in the first combo box, and I click on the engineer drop down box, I get an error saying that the table or query does not exist. I tried creating query with the above SQL statement, and attached the query to the row source instead and it now says...

Hi all :) I have a form with a combo box on it, listing a bunch of contractors from a table. I have another table, that has two columns - contractors and engineers. How can I populate a second combo box on the form with the "engineers" values associated to the contractor selected...

Hi all. First of all, I'll start by saying that I'm not looking for a click-by-click rundown here, more a rough overview. I'm quite new to the world of access (although not database programming in general), so I'm just not sure where to start on this one. Once I get stuck in I should be OK :)...

Yeps - the importing thing seems to have worked - I should at least be able to iron out the bugs he was having now without having to grab his mdw, even if I need it to stick the fixes in :) Thanks guys. I'm sure I'll be posting back here soon to find out how I *can* implement some decent...

Well, the shortcut he uses points to: "C:\WMP Services\Invoice Database 2003-4\2003 database.mdb" Does that mean he's using the default system.mdw? Is there any way to bypass this security, so I don't have to request the file from him, or do I *HAVE* to have that file, even if the...

Hi all, One of our clients recently approached me to ask for my assistance in sorting out a few bits and pieces on his access database. I've never really done anything in-depth in access before, but I do have a fair bit of database programming in a few languages / backends, so I said I'd give...