Search results

I have a table, named tblRecords, and a joined table, named tblUserRecords. The tables are one-to-many joined by RecordID. In tblRecords, I have a field named UserID to show who entered the record. In tblUserRecords, I also have a field named UserID for user(s) who have access to the record...

I am trying to restrict the user from only seeing the records that apply to that user. Given the following tables: tblSecurityControls SecurityControlID pk SecurityControl tblDepartments DepartmentID pk Department tblUsers UserID pk UserName tblRecords RecordID pk SecurityControlID fk...

I want to print the project VBA Source Code for an Access 2007 database. I am not impressed with the look of the printed output included with Access. It does not look very professional and does not appear to include any of the VBA formatting. Does anyone know of any add-ins or third party...

I have been working hard to convert to Access 2007. One of the reasons for my conversion was to take advantage of the so-called, RTF functionality, touted by Microsoft as an ActiveX replacement for Access developers. I couldn't believe how much time I wasted when I tried to use the control...

As I begin the process of converting my old databases to 2007 in order to take advantage of some of the new features, I became curious about what happens when a workstation has a full-version of Access 2003 installed, but also needs the 2007 Runtime in order to run my application? Can both...

I am trying to develope a document management system in Access. One thing I would like to do in my ActiveX Listview is show the default icon associated in Windows with that specific file extension (e.g. show the Excel icon when my file has an xls-extension as Windows Explorer does). I found...

Here is an example to demonstrate just a few capabilites of the microsoft listview control. An image list control is included. These controls require a reference to the Microsoft Windows Common Controls 6.0 (SP6). Scott

I have done a bit of research on the topic and I was hoping to generate some discussion. My end-user requires an RTF style control for data entry. I have never implemented this type of control, but noticed that Access 2007 now uses HTML to achieve the same result. I don't think that waiting...

I have several bound subforms whose recordsources are based on querydefs... I use the following code in the OnCurrent event of the main form to count the number of records on a subform, Me.mysubformname.Form.RecordsetClone.RecordCount but for some reason, one particular subform won't give...

Hi guys, I hope somebody can give me a quick step-by-step. I've nearly completed a program written in Access and have started to venture into marketing the program to a local company. When asked what other modifications they would like to see i was sent an email stating; "A major item would...

I've been working with Treeview Controls and thought I would share a few examples I have found: Found at: http://www.pointltd.com/Downloads/Details.asp?dlID=36

Anyone know how to reference the name or header of a particular column in a listbox control? i've tried, Me.lstBox.Column(1).Name Scott

This example shows a way to Resize and Center the image frame to fit the image regardless of the image size. Images larger than the frame will be reduced to fit the frame. Images smaller than the frame will remain their normal size. Simply call the function named fResizeImageFrame(). This...

This is driving me nuts guys... I need a query to show only those Company's that have a relationship to ALL Departments. These are the tables: tblCompanies CompanyID tblUserDepts UserDeptID tjxCompanySubscriptions CompanyID UserDeptID tjxCompanySubscriptions is a junction table that...

Any ideas on how to set up my tables to allow a user to define the stuff he might need to keep track of... I searched the forum and did not see an answer. This is my thought, if I have a Contacts database and the user want's to keep track of the Hire Date for example, how would a user define a...

Seems simple, but I haven't been able to crack this one. I've searched and haven't found an obvious answer. I want to hide a command button after it loses focus. I've tried placing this code on the On Lost Focus and On Exit events of the command button. Me.cmdName.Visible = False I get the...

I found this rather useful. Written by Danny Lesandrini, it demonstrates a way to use Popup Menus on the mouse click of command buttons. A nice way to clean up your forms and give your end user more options. I found it here: http://www.databasejournal.com/features/msaccess/article.php/3437731

Ever since I switched from using a Mapped Drive to using the UNC path for my linked tables, i occassionally get Unexpected Error (40230). I noticed this first when i manually re-linked using the link table manager, it linked the tables, then gave me this error several times, likely reflecting...

I have my database connected to a network of ten computers. I recently switched my linked tables from a Mapped Network Drive to using the actual UNC path \\computer\folder\database.mdb My users have started to notice it takes longer for the database to connect in order to log in. Once they...

I've had success using the Application.SetOption property to change certain database options, however, does anyone know how to toggle the checkbox underneath the Application Icon path which reads 'Use as Report and Form Icon' ? I've searched around and can not find it. Thanks ~Scott