Search results for query: *

Thanks very much. Been doing alot of Qlikview and InfoPath lately. Been away from Excel for a bit!

Hi I don't see "Values" I get a Paste Special dialog box with As...Excel 8.0 format, Biffs, HTML, Unicode Text, Text and CSV. If I go with Excel 8.0 format, I lose the Conditional Formatting, but if I use Unicode Text it retains it. I guess that works.

nice....thanks

I have an access query that i will be running daily for a few weeks, I copy and paste it into an excel sheet (template), I want to have several columns in the sheet color coded (Conditional Formatting) ....Low = green, moderate=yellow, high=red and L=Green, M=Yellow, H=Red ...... How can I...

Can an Access database stored in a library on a SharePoint site be multiuser? Is there a limit on the number of records that the database can hold on SharePoint? What does Publishing do? Our site does not have Access services enabled...they won't let us do anything. I really would like to build...

yes, right click, ctrl key, might have to reinstall

Yes, it's missing. It's a pia to work without it.

Using excel VBA to code a function, the menu toolbar is missing. This is excel,2013 I've tried e everything. Any iseas.

In testing an InfoPath doc published to SharePoint, I set up a few people to test the form. It works fine for me, however when they click the link to open the form the following message..... An error occurred querying the data source, you do not have permission to access a SharePoint list that...

I solved this by.... Choose First instead of Group By under the memo field. The aggregation is still preformed on other fields from the table, but not on the memo, so Access can return the full memo. The field name changes (e.g. FirstOfMyMemo), so change the name and Control Source of any text...

I have an access report that contains several sub reports. In one of the sub reports, i have noticed two fields which have "can grow" set to yes are that are truncating the text at 255 characters on a memo field. I thought this would display the full field's data.

I work for a large company that has users all over the world. Deploying access databases is difficult due to the restrictions etc on shared drives. I need to build a small application that people in europe and asia can get to. I was thinking of publishing to SharePoint (when I get access...

Never mind... i figured it out....really dumb

I have a report, where one of the values had a value that had a 1 to 100 range. My manager wants a different calculation. I have to take that initial value and multiply it by two other values and now that number could be 375. How can I keep the ratio 1-100 ....If the maximum value is now 475...

I am working on a project with someone in my company. Help desk and security are difficult to deal with we are on different shared drives making sharing data a problem as my database i am building is growing. Question....can I use a SharePoint library as a folder....to copy the database to and...

Hi I did it from my phone last night and just checked it. It didnt save. So I re-entered it. This site is the best, and I will again send a small token of my appreciation.

Brilliant... Worked great thank you

thANKS , WILL TRY IN THE MORNING

Background ------------ They have an expenses table and a table containing searching terms. I loop thru the expenses table looking for a matching search term My code is failing on items that have double quotes inside the value ie...Gillette "Boston" Stadium Do While st = 1 ' store...

I am running a find first and getting a syntax error on one of the values in the table. The data item is Gilette "Boston" Stadium. For background, it dealing with expense items, so someone took someone to a game and entered in Gilette "Boston" Stadium... but my findfirst is failing because of...