Recent content by nik11

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.