Search results

Personally, I would go for Me.OrderBy = "fieldname" What I want to know is, how can I add an additional OrderBy criteria. In Excel talk, it might sound something like 'Sort by A then by B then by C', but i want to do it from VBA when I click the column header label. Ta muchly.

There is nothing special in my report, the text box refers to a specific text field in a query. • The 'Can Grow' and 'Can Shrink' properties are both set to Yes. • There are other text boxes on the same line but even if I move it down so there is nothing on the same line, or even delete all the...

There is nothing special in my report, the text box refers to a specific text field in a query. • The 'Can Grow' and 'Can Shrink' properties are both set to Yes. • There are other text boxes on the same line but even if I move it down so there is nothing on the same line, or even delete all the...

try... IsNull(rs!AvgCPC)

Im guessing the FollowHyperlink command is a relatively new feature because Im using Access 2000 and mine returned the message 'Run-time error 490, Cannot find the specified file.'. Private Sub lblwebsite_Click() Dim strURL As String strURL = txtCustWebsite.Value FollowHyperlink strURL End...

Im trying to send an email from VB... Private Sub lblEmail_Click() DoCmd.SendObject acSendNoObject, , acFormatRTF, txtEmail, , , "YourSubject", _ "YourMessage", True End Sub I have tried both acFormatTXT and acFormatRTF. I've also tried a few others too but didnt expect them to work anyway...

I have created a query thats initiated by a command button from a form and one of the criteria for the query is a 'Like' command. On the form, various option buttons and combi-boxes determine the search criteria and put it into a hidden textbox. Then, the query is run based on the contents of...

I have a query that contains, among other things, the name of X people attending X event and another name (from the same table) who is to act as their 'in case of emergency' contact. However, how can I check using VBA to make sure that the emergency contact isnt also attending the same event...