Search results for query: *

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

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

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

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

I will be building a questionnaire whose data will be stored in SQL Server. Regarding Yes/No questions, last year in a similar project, I stored them as bit fields. When I linked the table to an Access database for reporting and analysis purposes, the questions that were not answered (NULL in...

I am designing a questionnaire project similar to what i did last yr using InfoPath for the questionnaire, SharePoint to house the questionnaire and access to query the results. I am looking for a better design in the way we calculate the results (if possible). Last year I had a Specification...

I have a country report which contains several subreports. The subreports essentially are sections of about 10-20 fields. So, I have the first 10 or so questions followed by 6 subreports. In testing the report, I notice that the subreports are duplicating. For instance, the section 3 subreport...

I am getting a new PC at work. Currently I am using SQL Server 2008 Express R2 on my desktop and am getting a new PC at work. Once I get SQL Server installed on the new PC, how do I get the data to the new PC. Thanks

I am building a report displaying country level information, and I have flags of countries stored in a file. I understand there is a file named zapotec.bmp, which is a Microsoft file needed to make this happrn. I don't have zapotec on my computer, anyone know where I can get it.

I have a database that has linked tables to a (desktop) SQL Server db. Last week I accidently de;eted a table. I have re-populated the data and re-linked to SQL Server database, but now a couple of my queries now display "No current Record" when I run them. I have rebuilt the queries and when I...

I am developing a report based on country data. Users can select 1 ore more countries or ALL countries. The country data is displayed in the report detail section. Therefore, the header info is the first line in the detail section. The header info is followed by a double line to seperate. Thats...

I am using a field object to get the fieldname in a For Loop processing a large table. I need to get the value stored in that field. I can't get the syntax for that. I thought .Fields(intFldCtr).Name.Value would give me the value stored in that field....but no. For intFldCtr = 1 To...

Does SQL Server 2008 Express R2 contain the Query Designer. I can't seem to find it, but i thought it was there...kind of hidden. thanks

I am linking to a SQL Server 2008 R2 Express table. The table has data but in access the DOC_ID field (Key field) shows data but the other field is blank. I know it has data.

I have a local database of SQ Server 2008 express R2 set up on my C: DRIVE. I am using Qdabra dbxl to bring infopath form data into the sql server db. I really want to link the tables into an access database for query and reporting. When I tried to link I could not find the database. It found...