Recent content by monvani

I have a button on a report. I want it to drop a new SQL statement in an unassociated query when clicked. I'm getting the "The object doesn't contain the automation object..." error. The code below is stored within the report, I have a runCode macro that calls the "qryCritAll" function. Please...

I wanted to, but I'm taking inputs on the form so it must be a table and not a query.

Glax, I really thought that was going to work, but just the same old error# message. I hilited the problem field on the attached if you have time to look at it. Maybe I'm just missing something obvious.

So sometimes within expressions, my brackets are automatically replaced by quotes by Access when i hit enter, or try to display the form in Form view. Especially, when they are within a function. Know why?

Ok, I had the wrong form name, but this part works- =Forms!frmShowActuals!month2 So, I want to lookup that value (it exists in the rptPeriodMaster field) within the qryColLbl query, and return the associated value in the FirstofrptColLbl field for that record. All fields are txt. This is what...

The field is text- What I had originally that didn't work: =DLookUp("FirstOfrptColLbl","qryColLbl","rptPeriodMaster=" & Forms!tblColLabels!month2) I've tried each of these and none worked: =DLookUp("FirstOfrptColLbl","qryColLbl","rptPeriodMaster=" & Forms!tblColLabels!month2 & "'")...

Thanks, it's working now. I really appreciate your help!

Form is based on tblColLabels, and I have a field on the form that I want to DLookup values from an unassociated query. I can't seem to get the syntax right to get it to display the query values. This is in the expression on the form (attached for reference)...

confused: Hmmm....not sure why it's not working. Getting the "Invalid Outside Procedure" error.

confused: Hmmm....not sure why it's not working. Getting the "Invalid Outside Procedure" error. :

confused: Hmmm....not sure why it's not working. Getting the "Invalid Outside Procedure" error. :

:confused:A sample of my database is attached. Please see the form, I want to put a check next to the month that will display at the top of the sample report. I know there are so many different ways to do things in Access, but this is part of a huge database, and I really don't want to tinker...

Ok, so I'm writing some reports that are produced monthly, and in the header of the report, I have the month it is being created for (example "October 2009"). Because of processing calendars and the fact that some reports will be created during the prior month, this must be set manually and for...

I have a table with several fields, but one of them is a Yes/No field. I have this on a form, and I want the user to only be able to select Yes on one record. When the form opens, there should be a yes on one record, and if the user tries to click the checkbox on another record to set it to Yes...

I have a table X records long with Y fields. I want to loop through them in VBA like: ----- for i = 1 to X for j = 1 to Y Z = [field (x,y).value] if z = 99 then [field (x,y).value] = 100 next j next i ----- I know I'm way off on syntax, but this is the general...