Hello ...
I create a pivot table from a data spreadsheet no problem. When I add a calculated item I start running into problems. My Data basically looks like this ...
PLAN LOCATION DESCRIPTION QTY
401 A1-A2 Dig 5
402 A2-A3 Place 7
And so on ... when I...
Hello, need some help/guidance...
I have a spreadsheet, that spreadsheet basically summarizes work operations on a construction drawing. The idea is that I have someone go through a workplan, and populating this spreadsheet based on the drawings. My columns are somthing like "PLAN DESCRIPTION...
Good Afternoon ...
I have two columns ... what I want to do is compare the two columns, for every entry in column A that isn't in column B I would like to copy that data to a third column ...
Anyone help?
Ok ... here's the situation ... I have a column1 with several repeating names, what I want to do is create another, column2, with every distinct name listed (Kind of like the dropdown menu for the AutoFilter.
Any suggestions??
Hello ... I have a lookup field with 3 columns. The correct column is getting stored on the base table, However the field on the form is displaying the ID number ... not the actual field data ... I know this is really easy to fix, I'm just having a mental block this afternoon ...
Kevin
Hello ...
I track many projects for my client using Microsoft access. Every friday I export my tables into a Microsoft excel file for their use (As that is what they are familar with). Traditionally they used to get new updates (I.E. Updated dates and comments) bolded for anything added...
Hello ...
Not sure if I'm doing something wrong ... looking for some help. When I "Find" an e-mail in my inbox is there any way that I can then copy that to one of my local folders? When I try with the search results I get an error message saying "Can't move the item." Any idea why this is...
Good Afternoon Folks ...
I have a "Check Box" control in Excel 2002. Is there a way I can change the check mark to an "X" ... or maybe somehow cause the fact that the box is checked become more apparent? I only ask because I have had people complain that the check mark is hard to see when a...
Hello,
I'm putting a database together for some people at my office. I want to populate some fields with calculated dates based on a date that is input. How would I do this? Is there anyway to only let it count business days (I.e not include weekends or holidays)? Any help is great.
Hello,
I have an access database in Access 2000. I have used the security wizard to secure this database. Now when other people go to try and use the database they are told they don't have the proper permissions. Any suggestions on how to fix this? They don't even get asked to enter a...
Good Day,
I want a query to look at another query. What I want to do is count the number of records with a given year attached to them an them display the number of records for those years. The output I'm looking for is below ...
2002 5
2003 10
2004 3
Can anyone help me with this?
Hello,
I am using Microsoft Access 2002. I want to be able to have others access a database I have put togther. Now I want to allow others to View the tables and information in this database but not add or edit any information. I have tried using the wizard but when I start up the database...
Good Day,
I currently have 8.5" X 11" pages in the same PDF file as 11" X 17" pages. I would like these pages to print to the correct size automatically. How do I do this?
Hello,
I have a wireless-B Linksys Router and PCI card. I find that the wireless connection is active for like 5mins then I lose the connection and have to reconnect again. Anyone know why ?? If I upgrade to Wireless - G would this continue ??
Hello,
I have set up a very basic database to replace a series of Excel logs that my work group uses. I have information that I want to enter in a memo type of field. Is there anyway to start a new paragraph in that field (Like pressing "Alt-Enter" in Excel) ?? Any help is appreciated ...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.