Search results

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...

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)...

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...

I have an access table that has many records and fields. Most of the cells contain data, but some are empty (contain ""). I need a macro that will loop through each cell and replace the null value with a "0".

I have a qry based on a table with field [f6] as a date. For example, one record has [f6] with a value of 10/14/2008 (format m/d/yyyy). I am building a field in that query with a dlookup into tblCalendar which looks like this: dateStart* dateFinish* Month 8/29/2008 9/25/2008 200809...

Please see the attached image. It is a screenshot of a query, but based on only one table. The table has the following fields: Task Name, BudSt, BudFn, Bud06_01 - Bud13_12. For each record, I have a buget spread (between Jan 06 and Dec 06). I want a query to determine when the budget spread...

I need to recreate the excel function "VLookup" in Access. I've seen the function Dlookup in Access and (1) I can't figure out how to use it exactly * (2) I don't think it will do what I need it to do anyway. Here's the situation: I want the user to input a date into a field on a form. Based on...