Search results

I want to release an Access program to the production environment for users. I remember there being a file extention that can be used so the users cannot access the DB or Code. Does anyone have this extention? Thanks for your help. Joe B.

I want to release an Access program to the production environment for users. I remember there being a file extention that can be used so the user cannot access the DB or Code. Does anyone have this extention? Thanks for your help. Joe B.

Paul, That worked. Thanks for all your help. You are the best. Joe B.

PBaldy. . .Have to run off for a while. Ill check back with you later. Thanks for your help

I change the code as above and then received this error Run Time Error 2471 The expression you entered as a query parameter produced this error: 'EmployeeID'

The form is unbound. When I hover over Me.EmployeeName it shows "Me.EmployeeName = "5" which is the id of Employee Name entered in the Employee table. When I hover over Me.Password I get the correct password for this employee. Is the problem that the code is identifying the ID rather than the...

I have never done this before. I read the attachment but am still a little confused. I set the breakpoint on: If Me.Password = DLookup("Password", "Employees", "EmployeeName='" & Me.EmployeeName & "'") Then. Is this the right place? Then I click the Step Into function on the Debug menu but...

Having a issue with the login screen I created. I have created a login form for the users in which the user enters their Employee Name and Password. On the "Go" button I have put the following code to validate the Employee Name and Password are in the "Employees" Table: If Me.Password =...

That worked....Thanks so much for you help

Is there a way to select the fields to join manually? Also Not sure what you mean about the fields are of different data types. The only autonumber field is the primary key. The join field Asset Class and Global Region are test fields in all the tables. Sorry for being such a dolt about this but...

Here is the db. Thanks so much for your help.

Will post tomorrow...Thanks for the help so far

There are three options when I click on the join and select Join Properties: 1. Only include rows where the joined fields from both tables are equal 2. Include all rows from table "A" and only those records from table "B" where the joined fields are equal. 3. Include all records from table...

Thanks. I assume I can add multiple tables and joins to eliminate other table look ups.

I got it now. I created a new query which contains the two tables rather than using the lookup. This works great for displaying the value but for some reason the query does not return all the values in the table. It seems strange but the number of records returned by the query is limited to...

If I do no use lookup fields, how do I get the queries and reports to show the values rather than ID's

Not sure what you mean. I am not very experienced with Access. My query displays the table values but why do the values not get exported to Excel?

All, I have created a query in Access 2007 which pulls data from the table for a certain time period. The query contains lookups so the results of the query display table values rather than ID's. However, when I export the results of the query to Excel, the ID's not the values are...

All, How do I prevent duplicate entries in a table? Here is my problem. I have a table set up to maintain balances of security positions in a portfolio on a monthly basis. From the table I have created a form to allow users to enter the data. The fields are Month, Year, Asset Type, Country...

Hi All, I have created a form for users to input data into a table on a monthly basis. Within the form I wanted to restrict the user from seeing/editing previously input data so I set Data Entry = Yes, Allow Deletions = No, and Allow Edits = No. However, I can see problem arising where...