Search results

No it is not split

Not able to open db, repair db nor import any objects from db into a new blank db. Same error message occurs.

Yes I am using Access 2007. Unfortunately that is the only version my company loaded onto my PC. That's all I have been using.

I posted in both places to get help anywhere I could. Is that against the rules? Should I have only posted on 1 forum?

It won't even let me in to the db in order to convert or repair it.

I am on a deadline today and when I went to open an Access 2007 (I abhor the fact that I am forced to use 2007) database, it will not open. It gives me the error message Unrecognized database format [file path]. I have tried creating a brand new database and importing all objects from old to...

I have unique identifiers, and other fields that I removed just to focus on the data at hand that was giving me trouble. Thanks anyway

NESTED FORMULAS WERE LOST WHEN I HAD TO ATTACH AN .XLS FILE BUT THE FORMULAS ARE SPELLED OUT.' I have attached a sample of the the spreadsheet I inherited from an Excel user. I must recreate the formulas in columns M, N, and O by using an Access 2007 expression. Can someone help me? The Excel...

Perfect, thanks!

I have a table in Access 2010 containing the results of a survey. One of the fields in table is the actual quotes from customers who gave direct feedback. I have created a simple report containing all of the quotes. My manager would liek them included in a summary Word doc but wants quotation...

I have a co-worker who has created a very detailed and large Access 2010db and linked it to Sharepoint 2007. On a conf call with him today, a teammate & I decided that for our purposes we'd like to model our new db after his so we want to make a copy of his db and use it as a sandbox to test out...

:banghead: I am working with a simple table but due to my own llimitations, cannot figure our the quickest way to resolve this: It's an employee list with some reporting levels extending out to 8 levels up to the CEO. If all employees had the exact same number of reporting levels, piece of cake...

I have a table in Access 2010 based on these fields: ID Subdivision Builder Lessor Resident In the 500 records, one of the last 3 fields (Builder, Lessor or Resident) must be populated, and is. However, I want to combine all 3 by simply creating a field called "Owner". In...

I'm too new to it to even begin thinking about custom VBA functions but thanks for your help.

Some of the fields in my table are: ID AccountName AccountID Material Revenue Sold Date I'd like to create a query with a calulated field. The field would be called Revenue Range. I want the Revenue Range results to be as follows: Revenue Revenue Range <=$1000 1K or Less...

I'm not proficient at all with SQL but I think the IN operator would work here: I have a table with Name, Acct Number, Site ID. On several of the records, the data got mixed up and I've discovered there's a list of 13 Site IDs that all need to be changed to the same Acct Number. How can I do...

I have Access 2010 but needed Visio to do other projects. The IT dept. gave me Visio 2007. I installed it with no issues, but when I try to open Access 2010 now, the Windows Installer window opens and it's requiring that I reinstall Office Professional Plus 2010. When I cancel, I get a...

I created a db on my local drive that once complete needs to be accessible to a few hundred users across the globe. It's a relatively simple search form that starts out by pulling data in from a warehouse via ODBC. I checked for compatibility issues and there several, the most common one is...

I pulled data from a server; one of the fields was Community Name but due to an internal glitch some of the fields have garbage in them--they have numbers in the Community Name field. Of course the data type for this field is Text. I need to be able to do some sort of delete query and remove...

I am designing a report which includes both a CommitteeGroupID field and a CommitteeGroupName field. I am grouping by the ID field but the end users don't care about that field and only want to see the Name field. Is there a way for me to use both the ID field and Name field in my report...