Search results

You seem to article it well. Isn't code for this nested if statements?

What you want to do is not a simple matter. Any "snoopy" user can undo what you ask. I think that database security is what you really want. Take a look at this.

Just add a shot/branch indicator column to the appropriate tables, i.e. inventory, maybe customers.

This is another video which can help you.

This site explains how to do it.

This video explains how to do it.

"Exclusive as Boolean" (True of False) means open the database exclusively (True), that is, no one else can simultaneously open or be connected to it. False meaning that multiple users can simultaneously open or be connected to it. True is the usual case for a multi-user database, especially...

This link explains and shows how to do it.

Use a combo box by which the user select the desired query and on the combo bo AfterUpdate event, execute the appropriate query using a case statement.

Remember "empty" is not the same as Null. Also test for "empty". I use the NZ function or <column> & "" <> "", usually the latter.

You have to import all the rows. A header is optional.

Use DAO or ADO or an update query to copy the subform's data source records to the other table, making appropriate modifications.

Try Prod1stSend = cstr(me.chkProd1stSend)

Post the complete code for the "OnEnter" event. What you post is inadequate for me.

Google/Lookup how to reference Access report controls.

Evidently that's not a report. Tell us what the parts of that expression mean. Is a report name in the expression? I think not.

You footer needs to include the "report" reference to the controls be summed, etc., not merely the control.

I'd test those values and components with the Debugger on the Onformat event. You may have stumbled upon an undisclosed feature of of the expression builder, this is, building something incorrectly. Try =Report!numEMP!POSummaryAvgRate. Note that the brackets are only necessary if spacea are in...

I think that your control referencing is incorrect. A report's controls should always include the report name. "=[POSummaryAvgRate].[Report]![numEMP]" puzzles me. Shouldn't in be in the form "Report![Reportname]!ReportControlName]"?

Please describe the error.