Search results

Actually, I was just using numbers for an easy example. Tfield1 actually holds section names within our organization, and Tfield2 holds Division names within our organization. I think I finally figured it out though. I have a form with a combo box that puts the value of Tfield1 into Dfield1...

This seems so easy, but I can't find the answer anywhere. I have a lookup table called Types with two fields. We'll call the two fields Tfield1 and Tfield2. I have another table called Dtype. It has a field we'll call Dfield1 which is a lookup field bound to Tfield1. Dtype has another field...

Actually, I tried that very same thing that you have suggested based on messages in other threads, but it didn't work. I was not running the report from a form (so I guess my problem wasn't EXACTLY like Michele's, but I was getting the same error message when I put in the same code she was). I...

Just in case anyone is interested. I have the answer to Michele's question without having to use the DLookup function. (I was having the exact same problem as she was.) In the NoData event of the report, enter the following: MsgBox "Whatever you want to say." DoCmd.CancelEvent SendKeys...

Thanks!

I'm using Access 2000. I'm not very familiar with References. There are 4 Microsoft DAO References listed. Does it matter which one I use? Thanks!

I am using Access 2000 and am trying to reference the group that the current user is in. I have seen examples in the knowledgebase that I think might work, but I can't even get the very first part to work. I start with: Dim W as WorkSpace and I get the following error message: "User-defined...

Nevermind. I quit Access, opened it up again, tried the exact same thing I mentioned above, and it worked. It must have been something left over from something else I was doing.

I have been reading all the posts I can on this topic. I see that it's a common problem, but I've tried all the suggestions and keep getting an error message. I am trying to strip out the time from a date field for exporting to a text file. I am using a select query. The name of the field is...

That's exactly what I was looking for. Thanks so much!

Thanks but I looked and didn't find what I'm looking for. The code below changes a property on all of the forms in a project without naming each form. I'm looking for something similar that will change a property on each of the controls on a specific form. Dim objFrm As AccessObject, frm As...

Is there a way to reference all the controls on a form without specifying each control name? If a certain event happens, I want to be able to change the Enabled property on all the controls on the form with having to say controlname.enabled = True for every control on the form. Any help would...

Thanks. It doesn't look like the search options has what I'm looking for, but I'm trying some other things. Thanks again!

Actually, I'm searching fields in two different databases. That did it. Thanks!

I just can't seem to get my syntax right today. I'm trying to use an OR operator. Whithout the OR, this works fine: strSearchAll = "[FIELD] LIKE '" & "*text*" & "'" DoCmd.OpenForm "frmDebtorsSubs", , , strSearchAll I want to add an Or that would be "[FIELD2] LIKE '" & "*text*" & "'" but I...

This is my second post on this question. Thought I'd try again. Anyone have any ideas?

That did it! Thank you so much!

This should be an easy question. I don't know why I can't figure it out. I can't figure out how to use a number in a string expression. Here's what I have which is giving me an error message: Dim n as Integer n = 100 Me.Recordset.FindNext "[NUMBERFIELD] = n" (n actually gets a number from...

I have a button that searches for the first occurrence of a record. If no records match the criteria input by the user, I know how to display a message saying that no records were found. But if a record is found, the user can then click a find next button. How do I display a message saying...

I have a form with a subform. I want to be able to search for a record in the subform's table and display the corresponding record in the main form. I've read where other people have asked similar questions, but they were advised to use a query or a filter. I don't want to use either. I'd...