Search results

Help please I am wanting to create some code which will resest a field. I have a form called frmEvent which lists Events being offered. Against each Event are a list of Delegates, and these delegates are picked from a list of Contacts. What i want to do is if say Event 1 exists, and there are...

I have a form with the following fields: ID, EventID, ContactID, BookingID the Event ID is a default value takem from the previous form, the ID is an autonumber and Primary, and the ContactID is selected using a combo box. Wot i want to do however, is to reset the BookingID number back to 1...

Private Sub cmdImport_Click() DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "TEMP", "t:\shared\budmon.xls", Yes Dim db As Database Dim sqlCC As String Dim sqlAC As String Dim recCC As Recordset Dim recAC As Recordset sqlCC = "SELECT TEMP.F1...

I currently have a form which displays a list of students which can be imported into a table. Some of these students may however already exists in that table. I want some code so that if i click on a student, and that student already exists in the other table, i get a message saying that the...

I have a d/b which is full of students names etc etc. i want to send them an e-mail asking if they wish to register for on-line invoices and payments. i need to know how i can create a web-link in the e-mail, so that the student can click this link, and the "Interested" box in my d/b would then...

I have a form which is not bound to a record source. I have various queries which all contain the same field names, and these are the same field names as in the form. i now want to be able to open the form based on any of these queries dependant on what button i press. i.e. if i press A, the...

I have been apporached by our Students Union to create a database which allows them to monitor the issue of union cards. What they want however is a form which allocates an alphanumeric ID based on the 1st letter of the surname, and a number. So you would end up with a1, b1, ca, d1 etc etc...

I have managed to create some code which sends e-mails to specific students. What i now want to do is create a mail merge document which contains details of each student, and then attach this to the e-mail. Has anyone doen anyhting similar before??? Has anyone got any idea's??? This is really...

Can anyone tell me wot is wrong with this code please??? It works in another db of mine, but won't work in one i'm developing now. Set rstTmp = db.OpenRecordset(sqlstr, OpenSnapshot) Thanks.

I currently have a table which includes the fields e-mial, name, address, course, amount owed, reason. I would like to send all these people e-mails, rather than have the Finance Department raise invoices. Anyone got the code to help, rather than me re-invent the wheel??? Thanks, Lee.

I have a database which has start dates off all employees in it. i need to work out the number of years and months between this date, and today's date. Any help gratefully accepted. Thanks, Lee.

Private Sub Command4_Click() On Error GoTo Err_Command4_Click DoCmd.SetWarnings False DoCmd.OpenReport ("R_Standard Monitoring Report"), acViewPreview, , "[T_Formatted data]![Period] = Me.Period.Value" Exit_Command4_Click: Exit Sub Err_Command4_Click: MsgBox Err.Description...

Can anyone tell me a piece of code which will allow me to round values up or down. Thanks, Lee

I have a report with a list of codes and values against each code. I want the report to give me 2 totals at the bottom. One will be a total of all the codes which begin 05, and the other total will be the rest of the codes. Any ideas ???? Lee.

I have created a message box using code with OK and Cancel boxes. Why, when I click Cancel button does the code continue to run ???

I have a report which is grouped by Committee. What i want to be able to do, is to exclude printing the Committee detail, if the Committee total is NIL. I'm sure I will need to write some code, and any advice would be appreciated. Thanks.

I have the following code attached to a button BudHdr = InputBox("You may also send a complete set of these reports. To do so, please type the name of the recipient(s) in the box below. Please use an ; to identify different recipients.", "E-mail ALL ?") DoCmd.SendObject acSendReport, ...

I have managed to create the command to e-mail the reports. I now need to be able to e-mail them to the right people. I have the -email address in the query which the report is bound to, but i don't know what to type in the event as the To : My query is called Q_Code List for Cost Centre's and...

I am writing a procedure, but am having difficulty in turning the SystemWarnings to Off. Can anyone tell me what I need to type ???

I have created a sub-form which is wider than the screen view, so I therefore have to scroll across. Does anyone know if I can lock the first 3 columms in my form, so that the other data will in effect scroll behind these columns.