Search results

I have a form that contains fields named Crition1, Criterion 2 .. up to .....Criterion 6 (And also Max1 to Max 6 The form is being used in continuous form mode. In the records Before_Update event, I want to ensure that IF the user has typed text in the Criterion field, then there must be a...

I have a few Navigation forms - which obviously have subforms in them Each subform processes data and I want to update each subform in a similar way.(but contained within a Navigation form) To do this, I have put common code into a function and then have the function update the relevant subform...

I am busy creating a bespoke markbook for a school. I have a form (Called Frm_SubjectSetup) On Frm_SubjectSetup is a navigation subform (Default name of NavigationSubform) Each of the tabs is named 'Term 1', 'Term 2', 'Term 3' and 'Term 4' respectively And naturally, each tab has its own...

I am trying to update my address table using four separate queries. I call each query from a docmd......thus DoCmd.OpenQuery "QRY_UPDATE_POSSIBLE_CMTY_001" DoCmd.OpenQuery "QRY_UPDATE_POSSIBLE_CMTY_002" DoCmd.OpenQuery "QRY_UPDATE_POSSIBLE_CMTY_003" DoCmd.OpenQuery...

Hi All I am trying to get my head around using stored procedures in SQL Server On my form, I have a button that SHOULD add students from a specified formid(which is a combobox) The following is the underlying code. Private Sub Btn_Add_Studs_By_Form_Click() Dim qdef As DAO.QueryDef Dim err_msg...

Hi all I am converting data from one (badly designed) db to a new structure. I have two forms that SHOULD represent the same data (but in a different format/structure)....however, I have either created new records somewhere or I am missing some records from my source for some reason I...

Hi All I have a button on a form that runs a series of queries when pushed. I would like to display to the user which query is currently being run. Just before each query is run, I issue a me.Info = QryName The problem is that the form 'greys out' shortly after the process begins and the textbox...

Hi All Despite HOURS of one-on-one training on how to prevent the capturing duplicate records, I am still called on a weekly basis to merge the information of two students (Who are in fact the SAME person) Consequently, I am developing an unbound Parent form (FRM_DUP_Student) that contains 2...

Hi All At the boarding school that I work for, students frequently run away. If we are unable to track them down within 24 hours, we are obliged to file a 'MISSING PERSONS' report with the police. I am able to extract much of the information (Student details, parent and family member contact...

We need to complete a number of 3rd-party application PDF document for each student at the beginning of each term. For example, We need to fill in a separate application PDF document for each of the following: 1. funding for each boarding student. 2. To request that Centerlink arrange (and pay...

Hi all My users are dismissing messages that I display with a standard msgbox. I therefore want to display a bespoke 'msgbox' that looks completely different to those displayed by the system. That way - they will (hopefully) take more time to read the message - and answer the question properly...

Hi All Before putting my problem out there, you n eed to be aware that I am working in a very different (technically challenged) environment which does not necessarily lend itself to automation in the 'ideal' world scenario. Hence the following (partly manual) process. In my Stu_Student table...

Hi All further to https://www.access-programmers.co.uk/forums/showthread.php?t=294892 I am have now converted the queries to stored procedures (in the back-end SQL server) as follows. I have a SYSTEM DSN connection using the 'ODBC Driver 13 for SQL Server' But they are not firing for some...

Hi all I currently have an access Front-End with a SQL Back-end. I recently read that when queries (which reside in the front-end) are run, that ALL the data in the linked tables is sent from the server to the client before any filtering, sort etc is applied. The client then does the filtering...

Hi All I am building a tool that will create academic reports for teachers. The idea is that the teacher assigns a 'generic' comment to each of the grade options in their subject The following are fake comments to illustrate the point. Grade 'A' - Sname was an active participant in the class...

Hi all The following code creates a label in the BODY of my form. Set ctl = CreateControl(FormName:=strForm, ControlType:=acLabel, Left:=MyWidth, Top:=0, Width:=1440, Height:=288) But I want to add the label in the HEADER section. Any ideas how I do that? PS: While I'm at it, is there a...

Hi there Looking for a bit of info (Pro's/Con's) regarding the use of a MEMO field vs linking to a doc. As a school, we often need to manage either a students health, behaviour or learning ETC.(or a combination of these.) Some requirements * This involves developing a plan to manage the issue...

Hi All If I look at ALL my records (IE: the forms recordsource as per the underlying query) then the date is displayed correctly. However, If I want to filter records (by changing the recordsource as I cannot use a filter in this case.) then the date displays as #Name? The field is a datetime...

Hi all I have a few forms that call a function in a module. The call is changeaddr(me.form.name) However in the module I want test conditions and then (if required) change values on the form that made the call. In short, the function looks like: Function ChangeAddr(FN as String) If Not...

Hi all I am using a split form to find and edit existing records. On the form I have set the following properties. Split for Datasheet = Read Only Allow Addition = NO Allow Deletion = NO Allow Edits = YES Allow Filter = YES Order By = [BLANK] So long as I use the form in this 'default' format...