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?

I am using Print Preview .... But both views filter the data.... As an workaround I added some code to show 56 records per page... and the report shows all the data.. Any views why such strange behaviour?

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

Thanks Matt.....!!

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.

Thanks for your reply Bob.....!!

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.

Split database. Version - 2003 Record locking is "No Locks" in Form as well as Advanced tab. Can you please explain what do you mean by Security. I am quite new to Access. There is a table that holds the security for all the users.

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.

By removing it, I mean removing the column from the DW itself. I just want this newly added column to use in a DW expression and then delete it.

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.

Thanks Matt.

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.