Search results

I apologize. Yes, I put the code together.

Here is full code (problem code is in bold). The indents are not posting.

In the below code I am receiving an "object variable or With block variable not set" error at this ErrHandling line: The code body works fine. Only the error handling is broken. Any suggestions? Thank you. Full Code:

Thank you. To follow up on the thread: DateSerial for Access works the same as Date for Excel.

I read Access' help documentation about the Date Function before posting my question, and googled syntax for the function. Documentation that I found does not specify arguments for the Date Function. Do you have any suggestions? Thank you.

I am attempting to add an audit field that rounds to the nearest month. Arguments for the Date() function appear to be non-existent. Excel Date() function requires three arguments - year, month, day. When I try to use these arguments in a field's Default Value expression builder, I receive...

My workplace has an existing Access 2000 database un-split on our shared drive. The file is secured via workgroup rights and a Secure.MDW. We have lost access to the file since upgrading to Office 2007. We have one computer that still runs Office 2003. While trying to take out the...

linq, I see now why On Click didn't make sense. Thanks for the explanation. The tabs represent different record levels. One of the 4 tabs will have priority for the user. Based on user input, either tab 1,2,3, or 4 will be indexed. The user can then choose from the other tabs if so inclined.

That worked. Thanks. I wrongly assumed that AfterUpdate would not work because the list boxes are unbound.

I have 4 tabs with a list box in each. Each list box executes the same query On Click. This query populates a SECONDARY list box. So 4 independent list boxes update 1 query that populates 1 list box. By opening the query after I click on each list box I can see that the code executes...

I realized that I misunderstood the problem. I'll post to a new thread.

Problem fixed with Me!lstBoxName.Requery Who knows what got fixed. Thanks for the time and trouble though.

That did not work. Earlier I tried Me!lstBoxName.Requery This time I tried Me.lstBoxName.Requery No luck. Thank you.

I initially had a form that included two list boxes. On Click event of the primary list box executed the query ("qrySecondLstBox"). qrySecondLstBox then populated the second list box. The primary list box after On Click simply read "Me.Requery". I then changed the primary list box to 4 list...

The query form is built and is accomplishing the purpose of my original post. Thank you for the guidance. I have a question about updating the query form that I will post in a new thread.

Here is the code I used. Your help definitely assisted me. Thanks. ( (tblCompetency.fldConcentrationID) like IIf([tblCoachee].[fldConcentration]="General","*",[tblCoachee].[fldConcentration]) OR (tblCompetency.fldConcentrationID) = "General" )

vba / Brian, Just to make sure we are on the same page that I'm looking for an SQL statement, not VBA. My intent is to simply filter a query. SQL is giving an error message that a comma should come before LIKE after the concatenate. Thanks for the continuing help.

Yes. A, B, and C are the only values found in the field being filtered. The user will designate if they are an A, B, or C. The query will return records based on the choice. If the user chooses A, the query will return records with A or C in that field.

It appears that I cannot input data into a query recordsource, just edit data.

I probably confused terminology by interchanging "constant" with criteria C. A simplified explanation follows: I have three cases for filtering my query. The user can choose either A, B, or C. If the user chooses A, then the query filters by A & C If the user chooses B, then the query...