Search results

Hello, Quick overview so you understand: I have two databases, one which contains form(s) that allow users to enter in legal type cases. It has a subform in which has four fields to insert OLE objects. This form draws its data from a linked table in a database called Attachments. Not...

KeithIT, ...Now, I was thinking more of the bulleted list appearing in the form, not a report. That thread focusses on reports. IE, each carriage return = bullet - something like that? I'm sure this could probably be done via coding, but the coding areas I'm generally involved in don't go...

Man, you are good!:D I appreciate your tremendous research ;) into this question I had! Man - That was sitting right in front of my nose. Good thing it wasn't a snake or something dangerous. Now, I don't know if it is possible (at least easily) is there a way it can create a bulleted list...

Hello, ...I don't know if this is easily possible or not, but here's my question/scenario: I am trying to create a form that allows me to (using a memo field) enter in the dialogue from a staff meeting. [This field will also be used for preparation for that very staff meeting]. I would prefer...

Workgroup Security Irina LC, ...Have you ever tried Workgroup Security? Access has an easy to use workgroup security wizard and it will allow you to create specific access per user or per group. I use it on a few databases I have on a network here so that only specific users can perform...

Hello, I thank you for your assistance. I do have a table of which has both the employees name and the org they are associated with. I need both pieces of information. (All of this information/data is extracted from a much larger mainframe system that has a separate org table - So I'm not...

Hello, I have a large table that displays employees and their organization they are in. I want to create a query that only displays the ORG field, but I also only want it to display one occurance of each org. This should give me a short list that allows me to see all of the orgs in the table...

Hello, ...I'm not sure if I'm making this question more complex or not or if it's even possible? (I would think so) Anyway...What I am trying to do is create a form in which I can input more than one criteria into a field - We will cal it txtSetValues. Then via a button open a query that will...

hollering, ...If you don't mind, I'd love to see it. Thanks, ---roystreet

Question For You... Hello hollering, ...I currently use workgroup security with access 2k. But one problem I have is that for the user to change their password; either I have to do it by enabling shift-enter bypass or by walking the user through the same course of action. I am looking for a...

You are correct that if you use workgroups that your database is essentially very secure. I have to use workgroups because of the confidentiality of the data that is stored in the dbases I work with. I will give a very basic scenario in which you can still essentially by-pass security as long...

Here Ya Go... I'll have to cut down the size of a dbase and then attach it to here tommorrow - Right now the current one that has the forms and the modules you'll need equals about 2.9mb and that's too big for this site. The below is a brief that could help you get started with it ;)...

Another Version - I like better Hi Guy's, ....I had ran into this problem at one time because I had very confidential data secured in an Access DB. The 'general user' wouldn't probably know to try to press shift-enter, but I still wasn't happy with that. I have a code that, once you log in as...

Simple 'Flag' Hello, I have made a simple database structure in the past that may help. Now, I only used one table which contained all of the records - No matter if they were 'archived' or not. I just added another field of which was called 'archive'. By default (in the table), this field...

Another Attempt At This.... Here's my latest attempt at this: In the form, I'm first going to try working with if it's null, then later I'll attempt to work with Not In List. Private Sub cbo_Status_LostFocus() If IsNull(cbo_Status) Then Call Navigation.emptyplace(Me) End If Now the code...

WayneRyan, Thank you for your reply. I'm slightly confused by what you said, but I do understand that a default value could be 'valuable' here :D, but part of why I ask is for future use with the msg boxes when it comes to using vbYesNo. I've used the boxes before, but only with the OK...

Hello, I am trying to figure out how to use a vbYesNo msg box to open up if a specific field is left null. Field name: cbo_Status. It is a dropdown menu. If it is left null, then the popup will open offering to insert a value for them which would be "Working" or they could press no and it...

Hello, In my database, I use Access security - As it has grown new types of log on features need to be added. Currently, a user logs on and then it goes to a form that has an on timer event of which attempts to open a form that only the admin group can open. So if they do not have...

A little bit further.... Not sure what you mean here: Because I am seeing the code as it runs, it just doesn't stop the record from being saved. I made some changes to removing the DL and changing the cancel string. I have another Database where this code is in the actual form and is ran on...

Hello, The below code I have in a module and is called by a form at Before Update. It checks the integrity of the data entered (or lack thereof) in a form. If they do not follow the guidlines and enter in the data incorrectly, it should make a msgbox with a warning message and stop the...