Search results

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

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

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

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

Good day. I have a developed a query with a field called MaxScores. I have another field which ranks the MaxScores 1 thru n based on the value in the scores. I use the following statement to rank the MaxScores: Ranking: (SELECT Count(*) FROM [rqryMaxScores-8] Where...

I have parameterized query that is to be the recordsource for a particular form. The form is opened, and the query is executed, when a command button is clicked. ON the "on Click' command, I have the the following code -- passing the required parameter as the OpenArgs : iWorkUnitID = 1...

Here is my problem. I have a command button (cmdSitePhotos) that is on a subform (xsfrmDataDisp). When the form/subform is opened, I want a query to be run (I have function executed on the On_Current of the subform properties). The purpose of the query is to seach a table for photos related...

I am attempting populate a field (String) in a table based on the value of the last character in a string of another field in the same table. The field I want to populate is called PhotoCaption, the field that contains the string whose last character it to be tested is called FileName. The...