Search results

Groups belong to different companies, so each group must not have access to data of other groups.

Is it possible to implement a multi-tier application with Access? The application is multi-user with users organized in groups that should have exclusive access to their own data. The application is same for all users, I do not want to create different database for each group.

1)Make the row height bigger and test results 2) check data fields, make sure they do not have special characters, ESC characters

4 hours ago the site was not responding at all. Now it is back to normal.

Try calculated fields that follow business logic, use them as flags based upon which, you then apply actions.

New pcs are 64 bit with 64 bit OS. Why run 32 bit apps on them? I am for 64bit.

Your commands is not valid command. Syntax IIf ( expr , truepart , falsepart ) expr Required. Expression you want to evaluate. truepart Required. Value or expression returned if expr is True. falsepart Required. Value or expression returned if expr is False.

Assuming codes at the bottom are fields, of the same record I propose to use tabs in organising them in groups.

You can create multiple column reports. But for forms, I do not know any way to accomplish multiple column flow of records.

From http://www.databasedev.co.uk/sql-multiple-conditions.html If we include multiple operators in the query, SQL Server evaluates them in the following order: Parentheses - if you group conditional SQL statements together by parentheses, SQL Server evaluates the contents of these first...

When you create a logic statement with OR and AND you have to use parenthesis The following statements are different: 1-> A OR B OR C AND D 2-> (A OR B OR C) AND D I think you should use parentheses like in the example no 2

If I follow this option then this component record will be imaginary and the Component table will have two groups of records (real components and imaginary components). I am afraid this proposal will create complexity in separation of the 2 groups of components in every query that the...

I have the following table structure: As the picture shows, a Product consists of a number of Components and each Component is going through a number of Processes. Here is my problem: there are some Products that consist of no Components, but the Product itself is going through a number of...

No, not Sharepoint.

A schematic depiction of Mutual Exclusion situation:

My proposal, use one table with auto-number field and another field to hold the InvoiceID. Then use a 3 phase algorithm: phase 1 -> create the actual new record with empty InvoiceID field and (after the record is saved in the database) mark the specific auto-number field of the new created...

I understand 1-1 relationship as a table split, and I do not find any use for it. Does anyone has any experience in implementing it in a case study?

Please suggest best practices on implementation of a workflow, the user should be guided to complete a number of forms by following certain sequence.

A friend told me that in feature versions of Access VBA is going to be replaced by JavaScript.

Are colourful reports better than BW. Do you have any feedback?