Search results

Phew! Okay, everything works now. I must thank you very much, jax, for being so patient, helpful and punctual. As it turns out, the main problem was the last DoCmd.Close statement that caused the datatype mismatch error. Thanks again, Ben

Okay. I made the changes you suggested, but now I get an even more confusing error. This is the sub as it looks now. Not much different. Private Sub Find_Click() On Error GoTo Err_Find_Click Dim strWhere As String Dim strSQL As String If clastc And Not IsNull(clastc) Then strWhere =...

Right now, I'm only working with normal text fields (first name and last name), however I might add a date field later, so thanks for the tip. I'm still coming up with the error 'An expression you entered is the wrong data type for one of the arguments'. The entire sub is as follows: Private...

Thank you very much, this helps a lot and makes it look a lot cleaner. However, I'm still encountering a problem. When I run the code as follows, DoCmd.OpenForm([CLIENT LIST], acNormal, , strSQL) I end up with an 'expected: =' error. I'm still learning, so it could be something very...

I'm going to try this again. I have got somewhere, but now I'm stuck. I have created a form that will be the find dialog popup. On it, so far I have 2 fields - first name and last name, however I will have a number of other fields, including address, D.O.B. and parent's names. This is to be a...

I probably should have mentioned that I am still a novice with Access, and so I might need a little more help than this. I understand the idea, but I don't know vba very well, so if you could give me an exmaple of the code to do this, I would very much appreciate it. Thanks again, Ben

How would I go about creating a find/search window that 1) is not the built-in find tool, 2) asks the user to input only two fields: first name and last name (or just last name of the client), then calls up that record in the form. I find that the built-in find tool is very inconsistent...

This works, but copies all of the records, as opposed to only the one that is active in the open form. I don't know how to apply a filter to take only the selected record. Could someone tell me how to do this? Thanks

I have searched the help files and can't find anything on this idea. I want to make a button on a form that, when clicked, moves the current record from it's current table to a different one (ie: copy the record, paste it in the other table and delete the old one). Both tables will have the...

I have a number of checkboxes in a form and table that I want to have a report interpret into text. ie: if the 'Autism' box is checked, I want the report to display the word 'Autism' and so on. Also, there are as many as 8 boxes, and I want all of the boxes that are checked to show text in one...