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.

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

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

Hi All, I have created a user login form with two test boxes, one for Employee and the other for Password. I also created a Command button to Enter. I then created an Employees table with three fields, ID, EmployeeName, and Password. How can I get the Command button to validate the...

Hi All, I have created a form which allows users to enter data into a table and then run reports based on the information. When the form is opened it displays the first record in the table. Is there a way to have the form open to the New record? (Not one already existing in the...

Is there a way to get a user login form to open when the user clicks on their desktop icon for the application? Right now the database opens when the destop icon is clicked. Thanks very much for you help. Joe B.

I have a form where the user can enter the Foreign Exchange rates for different dates. The fields are Date, Currency Name, Currency Code, and Rate. Is there a way to set up a Combo box where the selection of the currency name defaults the Currency Code and vice versa? Thanks again. Joe B.

I have created a form to input the reporting period parameters - "Start Date" and "End Date" to run a query and generate a report. I have since created another query and report for which I woule like to use the same reporting parameters. Is it possible to have the Start Date and End Date passed...

I have created a form to enter a date range as parameters to a query. I then created a report from the query results. Is there a way to display the "To" and "From" dates entered into the form on the report? Thanks for the help. Joe B.

All, I am pretty new to Access 2007 and have a question with which I hope someone can help. I currently have a table for Personnel Turnover. The columns are Year, Quarter, Job Title, Additions, and Subtractions. I want the users to be able to enter a date range based on the...