Search results

I created a MS Access 2007 database and now want to setup user level security. The problem is that when I open my database I don't any of the user level security tools (e.g., the Administer/Users & Permissions tool in the Database Tools tab) on my tool bar. Thanks

I have a relatively simple form for adding, updating and deleting records to/from multiple underlying tables. I would like to modify the form to support querying these tables based on user input form values. Is there an easy way to add this querying functionality to the existing form or do I...

I have a combo box on a form which is populated based on values in a lookup table. I need the form to allow a user to easily add a new value to the combo box without leaving the form. To do this currently, the user must: 1. Close the form 2. Open another form used to update the lookup table...

Can someone please help with the following query/error: update EXCEL_IEMATRIX_NULLS set EXCEL_IEMATRIX_NULLS.pyld_id = (select PYLD.pyld_id from PYLD inner join EXCEL_IEMATRIX_NULLS on PYLD.pyld=EXCEL_IEMATRIX_NULLS.pyld); Operation must use an updateable query. Thanks

Some of my MS Access 2007 MDE forms don't work, specifically the forms which open other forms. There is no error message. The MDB version of these same forms work fine and other forms within the MDE (i.e., those that manipulate database data) seem to work fine too. Any help or direction on...

I would like to make an Access 2007 application accessible to SharePoint Server 2007 users. By accessible I mean allowing them to run the Access application's forms and reports. Is this possible and if it is, will these SharePoint users need to have Access 2007 installed on the computer their...

I don't want my MS Access users to see anything except my MS Access GUI so I disabled all my MS Access startup options (database window, menus, etc.). However, now I can't see them or turn them back on! I have two questions: 1. How do I turn these options back on? 2. Is there a way to have...

When I run the MS Access 2003 "Make MDE File" utility on my split database, it hangs the MS Access application. It generates a file called db1.mdb which is identical in size to my mdb file. Any ideas would be appreciated. My database has security enabled (not sure if that's significant). Thanks.

I'm having trouble formatting a bar chart report. My query (shown below) returns 4 rows of data. The report correctly displays the data in the bar chart. However, the report generates 4 bar charts. I'm guessing it's doing this since my query returns 4 rows of data. Any suggestions on how to...

The following VBA code is out of a search form used to collect user search criteria and then query based on the input criteria. The RiskID portion of the filter is not working. For example, the Debug.Print shows the where clause equal to "1=1 AND RISK.[r_id] = 11" if the user enters a Risk ID...

I'm running a networked installation of MS Access 2003 and am trying to implement security (i.e., read only users, read-write users, etc.) on my database. After running the User Level Security Wizard, I get the following error when I try to open the database: "You do not have the necessary...

Rookie here. I have a table called CARS which contains two columns. Here what the table's data look like Make Model ==== ==== Row 1: Ford Mustang Row 2: Ford Maverick I want to write a query which generates the following "grouped" result: Make...

Hello, I have a MS Access 2003 risk management form which includes 2 subforms. The form supports adding, updating and deleting risk data in the form's associated tables. When the form opens, it returns all the risk rows in these tables based on a "SELECT *" query. I would like to modify the...

I changed a form's record source to a query (RISK_FORM_QUERY) and now it will not allow me to make any data updates. It's appears to be in some kind of read-only mode. Here's the query: SELECT RISK.r_id, RISK.rl_id, RISK.rpg_id, RISK.rpj_id, RISK.owner, RISK.RMCS_id, RISK.statement...

Hello, I need to set the value of a form field based on the value of two database table fields ([IMPACT].[value] and [PROBABILITY].[value]). Both value fields can contain number from 1 thru 5 so there are a total of 25 different conditions. Here's pseudo code for the first 5 conditions: if...

Hello, I have a form called RISK that pulls data from a table called RISK. I want to display a calculated field (read only) on the RISK form which represents the sum of the following table fields: R_COST_IMP.value R_SCHED_IMP.vaue R_PERF_IMP.value The following foreign keys link the...

When I select a value from my combo box to support updating a field in an existing database row, all is well. However, when I select a value from my combo box to support creating a field in new record, nothing happens. The field on the form doesn't reflect the selected combo box item. Any ideas?