Search results

Thanks Brian, I actually have about 500 rows so that gets a bit awkward too. One approach I could use is just to add a sum column in column BC then just do a Sumif to that column. I think the best answer I have found so far is a sumproduct((B1:BB5)*(A1:A5="Z")) the Z could actually be a...

Is there a way to make a sumif sum multiple columns? For example I could do =sumif(A1:A5,"Z",B1:B5)+sumif(A1:A5,"Z",C1:C5) would work if I wanted to sum columns B and C. This formula gets pretty long if I want to sum columns B through BB. Isn there a better way to achieve this? I only have...

Plog, The names that I am being asked to use for example field 17 represents "Year End Provision close process, including deferred tax entries-consol (Days 1-6)" these names may change multiple times before I am finished so for now I am just using field name x. For database purposes the label...

Plog, I tried to simplify what I am trying to do in my original post. I don't like to use auto number to create arbitary unique identifiers. I have combined name, manager and month to create my unique identifier. I have tried to upload a screenshot of the structure I was trying to use. I...

I am trying to create a form to enter data in a table. I would like to make it pull in info from a switchboard. If the record already exists I would like it to find it and allow me to edit the info. If the record doesn't exist I would like to be able to add a new record with the data input...

I have created a table that has everyone listed once. But I'm not sure how to procede from there.

I get tasked to use access very infrequently but now I have been asked to create a database. I am struggling with combining 2 tables. I have different data on each table however I do have a unique Identifier. So on table 1 I have Bud, his height, weight, etc. On table 2 I have Bud his home...

I would like to build a query where it retrieves data from 4 seperate comboboxes. However I want to give the user the option of leaving the box blank and treating a blank as a wildcard. How do I setup the query to treat a blank as a wildcard?

Thanks RuralGuy Citrix did the trick.

If you are using a LAN environment an alternative is to query the database from excel using microsoft query. This allows users who are unfamilar with access to see a report in excel. The reports can be refreshed while in excel to get real time data. If you are using excel 2007 you will find...

I have created a small database that will have no more than 500 records. It is located on a LAN. It works fine for me, I'm in the US. However I have users in India when they try to use it, it is unusably slow. I really don't know anything about networks. I've looked at tips for speeding up...

I don't have an issue with this when I query an access database from excel using microsoft query so I wouldn't think it is a microsoft problem.

Thanks for the help guys. I just figured it out. In access 2007 you go under Database tools/Users and Permissions/User and Group Accounts Select each user then hit clear password for all users then the login screen goes away. :)

It is asking for Name and Password.

I did save as a 2007 accdb file. Closed and reopened and it still asks for the Password.

I am using Access 2007

How do i accomplish rejoining the default system.mdw? Do I go under the user level security wizard? Thanks for your help.

We have an access database on a Lan drive. I made a copy of it on my desktop. I was playing with user level security with the copy. I deleted the copy on my desktop. Now when I open the the original on the LAN drive it asks for a password. When other users open the LAN version they don't...

That did it. Thanks for your help

I have one main table with thousands of records and about 25 fields. I want users to be able to edit most of the fields. A couple of fields I use for identifiers, none of these fields are unique identifiers. When the user opens the database he is prenseted with a Form that lets him choose...