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

Thansk man!

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

The following worked for me: update (select * from EXCEL_IEMATRIX_NULLS inner join PYLD on EXCEL_IEMATRIX_NULLS.pyld = PYLD.pyld) set EXCEL_IEMATRIX_NULLS.pyld_id = PYLD.pyld_id;

I'm an Access newbie. Can I get a little more help on a fix to my problem?

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

Can someone help me with the import process? I currently have an _be.mdb, .mdb and a .mde file. BTW, I converted all of these to MS Access 2007 and encountered the exact same problem with the .accde file.

I added the line of debug. When I run the uncompiled form (.mdb) a message box with the text "False" inside a popup with an OK button is displayed along with the R_MENU_FRM. When I run the the compiled form (.mde) nothing happens.

Here's a sample of the code that does not work when run from the .mde: Private Sub RM_Module_Click() On Error GoTo Err_RM_Module_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "R_MENU_FRM" DoCmd.OpenForm stDocName, , , stLinkCriteria...

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

Great. Thank You.

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

I was able to make the MDE after compacting my database and compiling my VB code. Thanks.

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.

That did the trick. Thanks a ton!

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

Fixed it. The associated select statement used aliases. I updated the VBA to reference the aliases and it now works.

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