Recent content by DJ44

Works great. Thanks for the help!

Good Day. I have search the forums but have not found an answer to my problem (or at least didn't recognize the answer)... I would like to open a report using a cmdButton on a forum. The report is based on a query. I would like to filter the results of the query based on a field in the...

Good Day. I have numerous records that have been handed to me in an excel spreadsheet. I have been asked to incorporate the data into an existing database. I developed the database but all previous data entry was form/subform based. I would like to know how to import the data. It does not go...

Thanks for the reply .... it is now more clear how Access treats the page layout stuff. I will experiment. DJ

Good day. I am required to print information (like name etc) onto a pre-printed certificate. The pre-printed certificate is 8.5"x 5.5" and there are two certificates per "page" (perforated at the centre). I have a report that will get all of the required info, however it will only print one...

Thanks for the help. I now realize that the nested queries is the way to go. First eliminalte all sites that have confirmed sitings, then query the resulting recordset for sites with possilbe or suspected animals. Thanks again, DJ

Thanks for the reply pdx_man. I had put that in the criteria row, however, this returns records for sites that have suspected animals and also has confirmed animals (even though the confirmed animal records are filtered out). Is there a way that, if a site has any confirmed animals, all...

Hello. I have a query that I want to filter but I can't quite get it right. The basic table structure is as follows. I have a field SiteNum. For each site there can be many animals present. Each animal is present (on not) based on the following PresType (presence type) Confirmed, strongly...

I have ran into a new but related problem. I call the code through a command button on a form that allows the user to change the weighting factors. The code does not run , I suspect because the table behind the form that has to be updated by the code is "open", or the focus is in one of the...

Thanks to Fizzio and Jon. I implemented the changes in the code and it was successful. I thought of an update query but this seems slightly easier for my application. Cheers! DJ

I have a database that, among other things will calculate the score of a site based on attributes of that site and the weighting factors assigned to each attribute. The db allows the user to change the weighting factors at will and re-calculate the score. I am having trouble with the syntax of...

Thanks for the post. The filters are installed. I have a smaller database that I created to test various code, one of which was one developed to open the form and display the images. It works fine on the same computer, displaying the exact same pictures from the exact same file path. ????? DJ

This problem has cropped up now an again and I never understand why . I am displaying numerous images in a ImageControl. They (usually) display fine. When I go into the database now, the image appears to load when the form is opened (as it should) and then I get the message DbName doesn't...

Woops, I re-read my last post and realized I missed a ' here and there. Corrected code: Private Sub cmdRankRegion1_Click() On Error GoTo Err_cmdRankRegion1_Click stDocName = "afrmTest" DoCmd.OpenForm stDocName, , , "RegionID =...

Just another thought. The above query is based on another query (rqryMaxScores-8). When I (manually) use the Where criteria for the Region in that query and then run the Ranking query, presto! --the ranking field is relative to the region. This brings up a new problem. How do I run two...