Search results for query: *

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

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

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.

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

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

I have two distinct user groups, for one group I would like for them to be able to see the switchboard when the database is first open; for the other group I would only like a form that has all there current assignments come up. I am thinking the code would go something like if currentuser() is...

I am trying to find all the fields in a query that have duplicate matches any ideas? This should be pretty simple but I have not used Access in awhile. Thanks

Okay I have a database that works fine on my computer it even works fine on the server. The problem is when someone on a seperate computer tries to open some forms in design view on the server the forms don't open. Also, the main problem is when they try to go into the on event procedure(VB) on...

Say an item has one part number but many different subparts in a table. So the table has one part number inputed many times and different subparts listed. How would you get a form to show just the one part once and have all the subparts just listed under that. With no blank spaces or extra forms...

I have a database set up with a front end and a backend on the server. Each User will click on a batch file that copies the database to their individual computer and opens it up with the security file that I have on server. Now I will be leaving this position and I have given the task of adding...

Is there anyway to delete all the records in a table(while still keeping the table format) in a automated fashion.

I am trying to get non-duplicate records for the fields in a make table query in an automated fashion. I have looked at Microsoft's suggestion of copying the table to structure only and then making the field that I do not want duplicates the primary key and then appending the tables in a query...

I have a query that I do monthly and I usually just copy the results into an excel table. For some reason this month it is taking forever to copy these records. There is the same amount about 8000; I select all and then copy and it just says copying for over 30 minutes usually this takes less...

I have a List of Part Numbers that is in the SAS data library. I have a list in an odbc database and I am trying to match the two up. My problem is that I do not know the format for expressing my data library file in SQL. Here is my code. PROC SQL; CONNECT TO ORACLE AS DSDCON (USER=gsv0367...

I am doing a simple select query in access. I am trying to retrieve all the values of an item name that have the word bushing in them. The table has the format like electrical,bushing. I have tried "*" & "Bushing" and I get no results although I know that these items are in the table any help...

I'm trying to figure out how to shift to the beginning of a text input whenever a user clicks anywhere on a text box in a form. It should be pretty straight forward but I cant seem to find how to do it. Thanks

Okay I've got a form that lists the projects assigned to a certain employee. This form selects the employee to show by a popup form that lists the employees. The prject listing form then has a clickable command on eacj project to go to that individual project and updata data on it. I would like...

I have a make table query that keeps giving me the mesaage that my table will be deleted evertime I use it. The problem is I have already gone in and turned off action messages in the options tab under tools. Is there a way to do this with vb?

I have subform that is based on a passthru query and a click command that takes you to another form based on information from mutiple tables in a seperate odbc database than the subform. The problem is when I erase the subform from the form the username password screen comes up for the outside...