Search results

I am struggling with getting a report populated with all required data and it may be due to a number of issues or the approach being used. I am trying to develop a Statement of Account report. The Person is selected using a form where the year and month of interest is selected. The Statement of...

The form displays a Sales order, with the Sale Order items and the Payments received on dedicated tabs as subforms. The Sales Order form has a calculated control showing the total of payments received. The formula is =Val(Nz([frmsubPmt].[Form]![txtTotalPd],0)) The form when opened presents...

I have a problem opening a form filtered to a particular record. The form is opened by obtaining a values for respondentID, QuestionnaireID and ResponseSessionDate in a dialog. When all selections are made these are used to identify the record in ResponseSession using a DLookup. The combination...

I have a Sales Form, which can be opened from a Sales History form without issue. However, as Sales can also include sales of subscriptions, I also have a Subscriptions History form that allows the originating Sale form record to be opened - at least that was the intention. Using an almost...

Confused by this: I have a sub form where I can record payments against an invoice. The total payments received are compared to the invoice total to determine if the bill is fully paid. However I have found that a single payment of 49.95 shows the sum of payments as 49.950000763 I had Total...

I have built a query that yields a calculated value if conditions are satisfied 0 if not. The form displays the calculated values for each row EXCEPT when the record meeting the criteria resulting in 0 is selected - in which case all calculated values appear as blank in the continuous form...

I have a Motor Vehicle Travel Diary (tblMVLog) table with records, as the parent to Trip Log table. Apart from in-Travel Diary record validation in BeforeUpdate such as MVLogStartDate (Diary start date) is before the MVLogEndDate (Diary End Date), I would also like to check that, if the record...

I have used the free helper applications by Peter Cole to identify the functions and make changes to the declarations to accommodate moving to 64bit (in fact trying to make it able to generate the 32bit and 64 bit versions), however I have come to a stop when trying to upgrade the code borrowed...

I have a form used to present a list of "qualifications", filtered by qualification type. The form has a search text box in the header to find a person's qualification. Initially when opened the form displays the relevant records. When the first character is entered the list should filter...

Hi. I am logging an import process and after creating the import record in the log table I want to use the id of that record later. I thought I could do this using @@identity and used the following code, however the value of autoID, when executed, is not tblTfrLog - it is an ID from another...

I have been struggling to find the cause of this message appearing when entering a new record on a subform, and would appreciate suggestions of how to locate why this appears. The context is: I have 3 similar forms to record some details of the work force: as Employees, as Contractors and as...

I am trying to limit the list of values displaying in a combo box in a subform to a subset of the values in the source table based upon the "type" of the record displayed in the subform. The subform displays the history of a member's designations: eg affiliate, newbie, corporate sponsor, GOAT...

I have a Textbox (Auto_Header0) in the header of a search form to display the name of the organisation and concatenated text. The name of the organisation is retrieved by a function. The control source for the text box is : =fMainOrg("FullName")+" Search" Unless I (temporarily) set the focus to...

My database uses an append query to add member financial records for current members when a new financial year is established - launched from a command button on a form to manage financial years. Following in the same routine are two update queries that then insert the membership fee appropriate...

I am trying to obtain the descriptive text I entered against the queries I have developed, as I want these to appear in documentation. This text doesn't appear in the the output from the database documenter. The particular line to retrieve this information (and write it into a table...

Hi - by way of introducing myself - I retired a few years ago from working as a manager within data / performance management services in the health sector of the public service in Australia. I am now tinkering with MS Access to develop an application to help manage a charity we are seeking to...