Search results

If you can identify the record uniquely based on values of a field then you can put the following in the search criteria of the query: Forms![FormName]![FieldName] Alternatively, you probably could convert whatever your macro does to code and run it from the form (using that record) directly.

Ed, You'd need to do this through a form. In the AfterUpdate event of the DateFinished, you'll want to use the SendObject method, which is explained in the VB help. Mike

Ed, Put a text box on the form in the detail section. In the properties of the form, paste you instructions (with quotes) into the default value of the form (Data Tab). On the same tab, make sure the Locked property is set to Yes. On the Format Tab, set the Scroll Bars property to Vertical...

orchid, It may have to do with any groupings you have set. Do you happen to have a grouping on the rainfall field? If so, it may put the amounts over 1 in a new group, and it may force that group to a new page. Just a thought. Mike

Mark, Here are my thoughts: 1.If you are changing the properties of the label, then you'll need to use the OnCurrent event of the form. This way the properties are evaluated as you go from record to record. You can then call the OnCurrent event after each of your 10 criteria are changed. 2...

Lynna, You could insert this code into the OnCurrent event of your form; If me.NewRecord = True Then 'Only do this if the record is new me.FieldNameToBlank = Null End If

Cheeky, Thanks for your efforts. I actually was able to figure it out - maybe it can help you. The following example locates the first post in the public folder "BST_Postings" with a subject of "Access Type Dump". It then saves the attachment to a network location. You'll need to set a...

Hello, I would like to create some code which on a daily basis locates a specific mail message in an Outlook public folder and the saves the attachment. The message will have the same subject text each day. Thanks, Mike

The list box or combo box is primarily one of cosmetics. What ever looks better to you and fits into the form. I've always beem partial to the neatness of Combo boxes. As far as using a table, that would depend on how dynamic or static your report list is, and if you want other users to be able...

Hello, I'm using the TransferSpreadsheet method in Access 2000 to export a query in Excel format. my problem is that when I open the spreadsheet, there is a ' at the beginning of each cell. Does anyone know of a way to avoid this? Thanks, Mike

Hello, I'm trying to trap error 3022, which occurs when you try to update a record with a duplicate value in an index. My code looks like this: Private Sub Form_BeforeUpdate(Cancel As Integer) On Error GoTo DupWorkOrder Exit_Form: Exit Sub DupWorkOrder: If Err.Number = 3022 Then MsgBox...

Hello, With Access 2000, is there anyway I can read the Windows NT account name that my users would have? Thanks, Mike

Muneer, In the OnCurrent event of the form, put the folowing code: If me.genderfieldname = "Female" Then me.cmdbuttonname.enabled = True Else me.cmdbuttonname.enabled = False End If This will turn the button on and off as you cycle through the records. You'll also want to put the same code...

Sol, Here's a solution: Put the server possibilities into a table. Add a numeric (integer) field to the table. In this new numeric field, for each server possiblity, enter the corresponding option value that you assigned to the values of the option group. (Go to the form design, select the NT...

Simply turn the warnings off before the query code and then turn them back on after: DoCmd.SetWarnings False Query Code DoCmd.SetWarnings True

Hello, I'm working with a user-level secured database and am attempting to use a second workspace which will give me more access than the actual user who logs in. I am able to create the workspace and add it to the workspaces collection, but I can't seem to reference it correctly: Global...

Thanks. My problem is that I need to use the OpenDatabase method to access/manipulate data in the table database. I won't have different users passwords to insert into the command line. My preference is that Access know that I logged into the application database and then use that information...

The first thing I would try would be to set the Tab Stop property (found on the 'Other' tab of the Properties box) on all of the header controls to No. You may have a problem though with all of the detail controls being set to disabled. You may want to set one of these controls to enabled, but...

The vertical pipe, "|", is your answer. Try using: Like "*|[Forms]![Membership]![MemberID]|*" in your query criteria.

Kirsty, A simple line of me.pass = null inserted in your else statement should do the trick.