Search results for query: *

I have a db with 3 tables: tblStudent, tblPlacement and tbl Reports. There is a main form displaying each student record, within the main form is a sub-form displaying every placement the student has had. Within each placement record in the sub-form there is a button. When the button is clicked...

I have a form based on a table. The table contains several fields that have "required" data. The controls on the form allow users to enter the data. The form also allows the user to change to another record. If the user enters some data and then moves to another record before filling in all...

I have a report that prints a major topic heading followed by a group of data spread over several lines. There may be several groups of data pertaining to the major heading. To differentiate between individual groups, I have enclosed each group by a rectangle. One of the fields in the group of...

This is a convoluted question. Please be patient for those who are willing to accept the challenge. I have two databases. The first is the primary db. The second db is required to be seperate for security reasons but accesses some tables in the primary db via linking. In the first db, there is...

I have a combo box on a form which is bound to a table. The "row source type" is a value list and I have typed in the values for "row source". A "default value" is also set. I have a need to occasionally change the "default value". The new value can be selected from another table. ie not the...

I have a main form with a unbound combo box (FindID). A user can select a person from the combo list and retieve the record. Limit to List is Yes. Row Source: SELECT tblTeacher.ID, tblTeacher.Surname, tblTeacher.Given, tblTeacher.Email FROM tblTeacher ORDER BY [Surname], [Given]; If the...

I have a main form with a command button. This button opens a small pop-up form. I make changes to data on the pop-up form and then close it to return to the main form. I then check to see if a particular value has changed from the pop-up form. If it has, using conditional formatting, I change...

I have a subform with multiple bound fields, 3 of these bound fields are: Code StartDate EndDate I also have a table with a similar structure. This "check" table contains a code and the subsequent start and end dates for that code. There will be several instances of that code with...

I have a database that appears to work correctly for a group of people. The database has several queries/reports that require pop-up forms to enter search criteria before calling the query. On several of these forms, a value is required for a year. Normally this defaults to the current year but...

I have a "query by form" that returns a list of people, relevant data fields and their individual email addresses. From the form, I can specify several parameters to send to the query to retrieve specific data. I can then view, export to Word and Excel. This all works correctly. I also have a...

I am using a Dlookup function to find a record. There are two parameters to pass to the function, one is text (varOld) and the other is numeric (varYear). Debug.Print varOld Debug.Print varYear varTeacher = DLookup("[Super]", "tblPlacements", "Super='" & varOld & "'" And "Year=" & varYear) The...

I have a form that contains a command button with a hyperlink to a page within a web site. This works perfectly well. The web site is a 3rd party site and may from time to time reorganise their site and links. Hence at some stage in the future, the command button will not work. The web site's...

I have a multiuser database installed on a network. The database is split into a front end and two backends. The backend files reside on the server for communal access. All users have a copy of the frontend on their respective workstations. The frontend file contains temporary tables to perform...

I have a table "tblAreas" with a field "Name". I have a form displaying data from another table. On this form, a situation may arise when I wish to add, delete or change the value of "Name" in "tblAreas". I have written SQL statements that work for add and delete - both work. However, the...

I have a Microsoft Access database. There is a facility to email a list of people from the database. I read every record, put all the email addresses into a variable (varEmail) and send the variable to the Email program with this code: DoCmd.SendObject acSendNoObject, , , varEmail The default...

I have a database with many predefined queries/reports. These are sufficient for all users except one. This user would like to create temporary queries on an ad hoc basis. I can add a command button to invoke the QBE query menu: DoCmd.RunCommand acCmdNewObjectQuery However, this will allow the...

I have a database with many predefined queries/reports. These are sufficient for all users except one. This user would like to create temporary queries on an ad hoc basis. I can add a command button to invoke the query command: DoCmd.RunCommand acCmdNewObjectQuery However, this will allow the...

I have a form that displays data about objects. Each object has an email address associated with it. I have a button that can send an email to the address shown on the current record. The following code does this: varEmail = Me!Premail DoCmd.SendObject acSendNoObject, , , varEmail I...

I have 2 tables with a one-to-many relationship tblArea(One) to tblPlaces(Many). tblAreas has 2 fields - Name and Area - Name is a primary key and several names may be in one area tblPlaces has 2 fields - Name and Comments - the same Name may exist many times with different comments I can open...

I have a database that has a variety of reports for the users. These reports satify all the current needs of the users. However, I have a couple of users that have sufficient Access knowledge to create their own queries. I do not want to give them access to structure, table or form design. Is...