Search results for query: *

Steps I am following to create Access view on SP 2010 Discussion Board or List: 1) Click on create Access view. 2) It opens a new instance of MS Access 2010 on my machine and asks me to save it. 3) After I save it, I select what feature I want to use (Forms, Reports, etc). I create a report and...

When I run a select query, I get the message "Overflow". There are no calculations in the query. I tried to find the record which is giving error by partitioning data. But when I change the where clause to not include that record it still gives the same error. Any idea what should I do?

My access report is not showing all the data. The query fetches all the records ..... but the report shows only some records. If I do top 50 in my query, the report shows 50 records. If i use top 100, report still shows 50 records. I tried to search any filters in the report but couldn't find...

Can anyone please tell me what's the best approach - Using PB Code table or Storing data in backend table. I want to display some values in dropdown.

Can anyone please tell me how I can i override the Sort button available in MS Access when I open any form. In short, i want to do some coding for the default sort button available in MS Access forms. Is this possible and if yes, how can this be done.

I am trying to synchronize a DB with the replica (both in Access 2000), but it is not Synchronizing. As soon as I synchronize it, I get the error "Microsoft Office has encountered a problem.....". I tried Compact and Repair, even then I am getting this error. Can anyone plz tell me how to...

When I open the DB in Access 2007, the Link Table Manager shows all the tables, but when i open the same db in Access 2003, it does not show any. This is not much of a problem, but I was curious to know why is this happening. Is there any setting that I need to do in Access 2003.

When trying to update records, users are getting the error "Could Not Update; Currently Locked". Can anyone please tell me how this can be handled. I dont want the users to get this error and also the records to be saved correctly.

I want to search for a column name in the entire database. In forms, reports, etc. Purpose is to find whether this column is used for any computations. Can anyone please tell me how this can be accomplished.

I need to create a DW column dynamically...and remove it after my usage. Can anyone please tell me how this can be done.

I am trying to print a DW but its going off the page. Is there any way I could print it on the same page. The orientation is 1. Well the only way I can think is by reducing the margins or reducing the columns size. Is there any other way possible?

I am trying to generate an error message on a certain condition. This works fine but after I click OK on the message box, the focus goes on next field. Can anyone please tell me how can I keep the focus on the same field.

On opening a window, I need to disable a menu item on certain condition. Can anyone please tell me how this can be done as there is no protect attribute available on the menu item as on the other columns of the DW.

I am reading some libraries using LibraryDirectory in a pbl file which are then inported in a datawindow using Importfile function. Is it possible to omit some libraries programmatically or by some other way.

I have a DW report which has an embedded DW. I need to pass a parameter from the main DW to the embedded DW. Can anyone please tell me how this can be done. I tried creating a retrieval argument in the embedded DW and it worked. But I am not using that Retrieval Argument in my DW query. I just...

I need to change the color of a datawindow field upon certain conditions. I put the condition in DW expression as well as in the code using modify statement but none of it is taking effect. Could anyone please tell me what could be the reason for this or is there any other way to implement this.

I am sending an email using mail session. In the body of the email, on clicking a particular name i want a new mail window to be opened with that name in the "TO" section. Could anyone please tell me how this can be accomplished.

I am printing a DW using the DW print property. Just before printing I am getting the following error: "Select Error : SQLSTATE = 22001 Microsoft OLE DB Provider for SQL Server String or Binary data could be truncated." Can anyone please tell me what could be the cause of the error.

Can anyone please tell me where are the values of code table (display value and data value) actually stored. Is there any separate PB table for storing it or they are stored in the datawindow itself.

I have the code as follows: If function1(arg1,arg2) = 1 Then A Else B End If. The function returns 1 on successful completion and -1 on failure. The code works fine but when the function returns -1 and I check the value of function(Arg1,Arg2) in Quick Watch I see it as 1, even though...