Search results

DLOOKUPS are expensive. They iterate every record of a continuous form on the Load event. You may want to adjust the recordsource of the Autopopulating field to be "SELECT whatyouwant FROM yourtable WHERE whatyouwant = " & Forms!Product!Combo76.

sorry, Dim appOutlook As Outlook.Application Dim namespaceOutlook As Outlook.Namespace right after option explicit at the top of the forms module.

did it run through the sub Outlook_OpenOutlook?

No, I would try the insert, it tests for null, then places the ""

You may want to wrap the vaues that may contain nulls using the NZ function. NZ(YOURFIELD,"")

sorry, the code for the OnClick should be Outlook_SendMail place a breakpoint at the beginning of "Outlook_SendMail" sub by highlighting the begiining line and press F9. Press F8 to walk through the code. should be fine. I just tested it myself.

If this was helpful, click on the sacel to add to my rep!

You can paste this right in the Forms module. for the button: Sub cmdSample OnClick() Sendmail End sub

You may want to naviage through the recordset and call the proccedure for each record: I don't see the math in this code, so I assume that it is a proceedure in code... Dim TotalRecordsTemp As Integer Dim rst As Object Set rst = Me.RecordsetClone On Error Resume Next rst.MoveLast On Error GoTo...

Oh, I get it! You are moving to the next record on the form! I would create a function that calculates what you need. You can call the function as you iterate through the recordset without navigating the actual form so that some of the code that is running (but maybe not needed) in the...

The OnCurrent Event fires when the next record is loaded on the form. If you have a continuos form, then placing the button on the form and calling the code should be sufficient. It is updating the entire recordset, therefore when you load the next record, the OnCurrent fires again, but you...

Perhaps you can define a recordset and use the recordset.bookmark option to select the starting postition.

DO Events is a great way to do this.

You can place this in the ControlSource of the Age text box (unbound) txtBOD = Bate of birth (can be bound txtAge Unbound =DateDiff("y",Year([txtBOD]),Year(Date()))

You would need to create a reference to Microsofr Office Object. Mine in Microsoft Office 14.0 Object Library. Here is some sample code: <code> Sub Outlook_SendMail() Outlook_OpenOutlook 'this is a sub further down the page Dim mailOutlook As Outlook.MailItem Dim strDoc As String `strDoc =...

You may just want to make an ubound form and on the OnOpen event set the recordsource of the form to the recordset in code. Then set the default view as datasheet. Quick and dirty. This would go in the OnOpen Event: Dim strSQL As String Dim rst As Recordset Dim db As Database Set db =...

My novice guess would be no, becuase inherently the user would not be able to open the FE database correctly without having access to the BE. You may want to try dumping the data out of tables (with the exception of lookups) and having the user add records locally, then append the records into...

If the form is unbound, then you may want to try this: [code] Dim ctl As Control For Each ctl In Me.Controls If ctl.ControlType = acComboBox Or ctl.ControlType = acTextBox Then ctl.Value = Null End If Next ctl

I have a data range "states" that is dynamic. I want to copy from a separate worksheet and paste another dynamic range "types" 1 row underneath the last row of datarange "states". Since the ranges are connected to Access query info, the data is fluctuating constantly. My guess is that VBA is...

What I have done in my project is split the database and leave bothe the front-end and the back-end on the file server. I then created a batch file that the users can click on that copies the front end file to the local PC and start access. I grabbed the idea from foums like this. Let me know...