Search results for query: *

It is used in this previous post http://www.tek-tips.com/viewthread.cfm?qid=1453955&page=1 The function does not work for me however. I thought it was just a built in vba function but apparently not. I am heading out for the day so I'll check back. Thanks for the help so far.

I was using it to only show certain items in a form to certain groups for security.

I am getting function not define error when I try to open a form that has a checkusergroup() function in VBA. I have not been able to find a solution to this problem online. Do I need install some additional functions in access or something?

Can you save to the same table with a primary key when 2 forms are open at the same time. And if not how do I get around this as I need the primary key that is in one form to get me to the proper place in the other form. Right now I am totally confused and my database is pretty much complete...

So, so far I have realized that if two forms are open at the same time they cannot enter values into the same table. So it seems like I need to get something that will hold the previous information or something. Any ideas?

This is crazy it gives me the error message so I can only save one of the entries but then when I go back to that item and save the other field it works and they are both under the same primary field. It's trying to save in two places before the error message and then after it saves it like it...

I have a form frmAssign that is based on a query MyAssign. Within this form is a clickable field that will open another form based on a query of the item in the clickable field. This additional form allows the user to insert additional comments on the item. The problem is when I save and close...

Thanks PHV

Why do some continous forms have an additional blank entry at the bottom of the page while others do not? I have checked the queries the forms are based on and they are the same I want my form to look somewhat professional so I do not want these additional entries. Any help would be appreciated.

Thanks I ended up justing taking out the # sign and it worked perfectly.

I have a table "tblDevice" which has a field "CBID#" which has duplicate entries. I am trying to count the number of duplicates for each CBID# and then just make a table that just shows the individual CBID#'s and each ones number of duplicates. I have used the SQL statement Select CBID#...

Also tblAssign allows the connection of all personnel to the group, what if I just want the initial review able to be assigned a group

I am a little unsure of the tblDevType though. Does having two primary keys allow you to have duplicates in one of the fields? Also I understand tblType but what is the benefit of having tblDevType when I could just add the type to the orignal tblDevice.

Thanks everyone, you have been a big help.

The item will only go through the process once, right now my table structure goes like this a have a table (data) with the following fields: ID(primary key); Lab#; Part# (exploited duplicate field); Initial Review (y/n); Initial Reviewer (Name); Verified (Y/N); Verifier (Name); Engineering...

Okay bad question, sorry guys how about this I am trying to take a field with duplicate entries and only show that, the number of duplicate entries per field line (not sure how to count number of duplicate entries), and a dropdown to select who would get assigned that item on a form. Once this...

Found it http://www.tek-tips.com/viewthread.cfm?qid=1453955&page=1 thanks dhookom

I've done this before but I havent used access in over a year. I guess what I want to be able to do is only show certain objects in a form to certain groups. If I remember correctly in the form ONOPEN I would have to have some kind of vbscript, to do this the problem is I cant recall what that...

I have two questions (1) I am trying to make a database that shows a list of unique devices. These devices will go through a process that entails: -assigning the device to initial review -initial review will then do one of two things, send it to a final verifier or send it to engineering...

Thanks dhookom, I have user level security setup. I think now I may just create a switchboard that hides options based on certain groups. Is there any vb programming needed for this?