I have a database in Access 2010 and would like to set permissions to allow other users to have the data tables as READ-ONLY and have no permissions to make changes to them but me as the author. I would allow users to link to the tables from my database and have those users open the linked...
Hello. I have a flat file in Excel. There are missing values on each row when value changes. I need to copy those values to each row. I'm not sure if I'm making any sense, but here is an example.
Current Output
Ticket # Patient Date of Service
1712612 111111 9/15/2011
null null...
I have a report in Access where an option button is visible for each record. As of now, the option is shown in color black when the answer is true or yes. When No, the option button is not filled-in which is expected. However, I do want to change the color in Green when Yes or True and in...
I have a command button name "New Issue" on a form. When I click on that command button, I get a clean form to enter new data. Within that form, there is a field named Issue Number. I would like to assign that field an automatic fill-in number (i.e. last issue number is 35..would like 36 to...
I know there is a way to code a field if a value of that field is a negative. I want to code a negative value in color red font and positive value as green.
I have 12 pages of Access reports. Each page is its own report. To convert all reports to PDF, I have to convert each report and then 'bind' them into one using Adobe. Is there a way to convert all 12 pages into one PDF file?
I have multiple page reports. Each page of the report is setup individually. I would like to print all pages into one PDF file. Is there a way to do this without having each Access report page as a PDF file?
I share a database to other front-end users. I want to be able to setup the data tables so that the users CANNOT make any changes (add/delete) to any of the data tables. They would still be able to run queries from them. How can this be accomplished?
I would like to setup a form with an option group (something like that) to select 1 or more different reports for printing at the same time. Any ideas?
I had just bought a laptop with XP Home Edition. My old laptop serving as the host for networking has Win98. How do I setup for file and printer sharing?
I have a field with last, first names, title. I would like to place them into 4 separate fields as:
name
SMITH, JOHN R MD
last name
SMITH
first name
JOHN
middle init
R
title
MD
Please advice. Thanks.
I'm experiencing difficulties if more than one person is in the Access97 form. The error message as it appears....
"Whenever you are not using <name of database> in Access, please be sure to close it out so that others can get in and enter/review data."
Please advice on what to do...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.