Search results

Very elegant, thanks for your time WAYNE.

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

This thread may be helpful.

Almost looks too easy! I suppose I may need to replace the Inner Join with a Left Join since not ALL records will have a record in tblUserRecords. I will plug it in later, but it looks good on paper! Thanks for your help guys! The next beer is on me!

I love your suggestion, it would certainly be much easier. However, if a record is private, only specific users can see the record (which is the purpose of tblUserRecords). It's not a case where a user who has a certain permission can see the private records. The user MUST be specifically...

Good point. Only one department for each user. However, the users are not assigned access levels as you suggest. A record in tblRecords is assigned a Security Level when it is created. The three security levels have different meanings (see above). Each record in tblRecords is also assigned...

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

Thanks Bob, I very much appreciate your help, your response was very informative. Scott

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

Can you show us some code you execute on the dbl click event? Is your command button frozen also?

Search the forum for the FileLen function, this should get you going in the right direction

Look up the 'FileLen' function to test for the size of the attachment

An ActiveX Listview control my be a solution. http://www.access-programmers.co.uk/forums/showthread.php?t=127355

A treeview is an ActiveX control that can be used in Access. It is found in the MSComctlLib library. The control itself is not as simple to use as most Access controls and requires a lot more coding. I would recommend that you have a bit of experience programming in VBA, but you can also try...

I'm sure you already considered this option, but it may be easier to simply create two different buttons with different images, then hide the button that does not apply to your condition. Other than that, perhaps someone else can tell you how to programmatically change the button images. Post...

I'm not sure what seams drastic since it should do exactly what you asked. Is there a specific concern you have that may calm your fears? Your end-user should not be able to get into your vba code anyhow since you should be able to convert the final deployment into an mde. But regardless...

Look up the Kill() function, you may need to use the Dir() function first to verify that the database exists before using Kill.

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