Search results

I need to attach multiple reports (.rtf documents) to an e-mail that is being sent to multiple recipients. Does anyone know how to automate this with Access 2000 and GroupWise Version 5.5 e-mail? Thanks, BJS

Yes it can be done. I had an SAP expert export the SAP data to Excel and then I imported it into Access.

Still can't get the Iif statement to work within the query, so instead I I put the following code on the GotFocus Event of the combo box to change the row source of the combo box: If Me.Checkbox1 = True Then cboComboBox.RowSource = "SELECT DISTINCTROW [TableName].*...

Fizzio, I have tried implementing your suggestion. It is not working for me. There is no OnChange event for the unbound checkbox, so I am requerying the combo box on the OnClick Event. I have put the IIf statements in the criteria of the particular field, but now my combo box shows no data...

I have 4 checkboxes a user can check. If checkbox 1 is checked, I would like the combo box on my form to be filtered so that only items that start with the letter "A" will appear in the combo box for selection. If checkbox 2 is checked, all items except those that start with the letter "A"...

O.K. I finally have it figured out! In the before update event of the SAMPLE_ID field, I have the following code: Private Sub txtSAMPLE_ID_BeforeUpdate(Cancel As Integer) If DCount("[SAMPLE_ID]", "DETAILS", "[SAMPLE_ID]= '" & Nz(Me.[txtSAMPLE_ID]) & "'") = 1 Then MsgBox "You have entered...

Pat, here is what is suppose to happen: The 3 fields in the record that are of interest are: SAMPLE_ID: text field, no duplicates allowed (e.g. 1045A, 33789) txtDistTo: number field (e.g. 138.00, 79.00) txtDistFrom: number field (must be same value as txtDistTo in previous record) 1. When...

Hi Pat, I have modified my code, to reflect changes you have recommended. I am still having the same problem. This code is occuring in the sub form, not the main form. The error message I am getting is: "Run-time error '2108': You must save the field before you execute the GoToControl...

Hello, I have a form "frmMain" and a subform "frmSubMain". On frmMain, I have a "Insert Button that will insert a new record into the subform "frmSubMain". When a new record is inserted, it takes the value of the field named "txtDistTo" from the previous record and populates the "txtDistFrom"...

Screen Resolution with Access 2000 & Windows 2000 Hi, I have been playing with ghunson's sample 97 database that changes the user's screen resolution. It works great, but I can't get it to work with an Access 2000 database. Note: I did't have to add the two lines of code specified in the...