Search results

On a form I call a Function to calculate the number of working days remaining between a due date and now. ( I have a field in the underlying table that I can use to store this value, but dont know how to populate it to keep it up to date). The value is displayed fine in the single form. However...

Hi All I have a command button on form one which opens form 2. (works ok) Form 2 has tabs on it (one called tabdepts) Is there a way to open form2 with the tabdepts displayed. Note: Form2 is not open at this point. Thanks Pat

I have a form which consists of several tabs. The data for the form is selected by using a combobox to select the required record 2 of the tabs have a subform on them (each subform links to a different table which have their own add and remove buttons), the others contain data from the main...

Hi All Table relationships: the table FOIRequests is linked to the Exemptions table via a link table in a many to many relationship FOIrequests: PK intFOIRequestsID Link Table: intFOIRequestsID intExemptionID Exemptions Table PK intExemptionID The main form opens and...

The SQL below is taken stright from the SQL view of the query. When trying to use it as an SQL statement I get the above error: Set rs = CurrentDb.OpenRecordset(SQL_String) SQL_String = "SELECT Count([intFOIRequestID]) AS RecCountAll FROM [SELECT DISTINCT intFOIRequestID FROM...

I have a form bound to a query. The query contains thee following tables tblRequests Field Name Value Value intrequestID 1 2 Linktable Field Name Value Value Value intRequestID 1 1 2 intExemptionID...

Hi Is it possible to remove the X (Close Button) from a messagebox. I have searched the web, but to No avail this is my code: If Not Me.Dirty Then MsgBox "No Additions or Changes made. Therefore SAVE not appropriate", vbInformation + vbOKOnly, "Add Status" End if Thanks in Advance Pat

Hi all I have a numeric field on a form and want to stop the user from entering non numeric data. If the user enters non numeric data the Access error message "the value you entered isn't valid for the field". I want to suppress this error message and replace it with my own. Where do I need...

I can't seem to successfully deal with this error. The scenario is as follows. I call the above routine when the user clicks on a save button I have added to the form, which launches an email. with the option of having the User see it first. That works fine. If the user chooses to not send...

Hi All I have a form with 2 combo boxes which are used to select the data displayed in the continuous form. The form shows Student ID, Student Name, and a field called Attend (text box, with drop down allowing "Y" or "N"), (which is to be updated to show if the student attended the course or...

I have a private sub which i am trying to use to sends emails from a form At the moment I call the sub from within an ON click event (On add New Button) when a user saves a record,. Will this work, or does the code to send emails have to be on a button of its own. send email(On Click event)...

I have a private sub which i am trying to use to sends emails from a form At the moment I call the sub from within an ON click event (On add New Button) when a user saves a record,. Will this work, or does the code to send emails have to be on a button of its own. send email(On Click event)...

Hi I have searched the forums, and tried to emulate the code samples found but to no avail Can someome please advise on why my code is not working. The message box "about to Call Send Email" appears, but then nothing else happens. I do not get the Msgbox " In Email". The code below is part...

Hi I have a form called View Courses This form is displayed when the user clicks a button on either the Viewstudent form, or the Searchstudent form. The View Courses form is based on a query, which uses the student ID from the calling form. I have created 2 versions of the Viewcourses form...

I have a main form and subform. based on a query. The main form shows courses/schedules with the subform showing students based on this course/schedule combination. The main form has 2 combo boxes. 1 select course name - (source, query on tblCourses) 2 select schedule - (source, query on...

Hi I want to add extra fields to my subfrom (which is a continuous form). I have clicked on record source property in the subform, amended the query to include the new tables and fields, and saved the changes when closing the design window. but the record source has not changed on the...

Hi I have a main form with several command buttons. When a new record is added to the sub form . I dont want access to update the record automatically. I only want the record Saved when a Save buton is pressed on the main form (This is to allow certain validation on the subform/main form to be...

I want to replace the standard Access Delete Messages, with my own. I know how to use set warnings. I have cascading deletes option turned on. I need to tell if a record I am about to delete has associated records, so i can change the access message to a more user friendly one. eg "Deleting...

Hi I have added some command buttons to a form and added some extra code behind them. I want to use the same buttons and code in several other forms within my database. Is there a simple way for me to be able to do this, as copy and paste only copies the buttons and not the code behind them...

I am trying to build a database for a local football team, and am having trouble with the design of the tables. The database contains numerous tables but my main problem is that within the database there are 4 types of people information: Players: (a player can have more than 1 guardian...