Recent content by rajeshsarin

The code has worked fine in Access 2007 Database for last 8 years, its only when we migrated to Office 2013 we started to have these issues. Do you think there might be an issue with an Add On or a version of VB Script or Some Item in the library? We had similar issues when we installed Adobe...

Hi All, I have three access 2007 databases that used to work just fine till we upgraded from Office 2007 to Office 2013. Now on certain occasions when we hit some buttons (that have got some macro or VB procedure behind the buttons), the databases just closes itself. I have checked again by...

Hi Folks, I want to create a button called "Export To Excel". Then embed code behind this button, so that when ever it is clicked it open the displayed report in excel format. I want to then place this button on any report that I create in my database, and upon clicking that button I want the...

Folks, I have a Access 2007 database, which has a 45Mb backend that sits on a file server (windows SBS 2008). I have 15 users using windows XP which have their own front end. When a single user is on the network the average time to execute a query or report is under 1 second. However when...

I have an access front end, that has a field called Documents link, this field normally contains an entry for each client that points to a set of folders of a win 2008 file server. The hyperlink works fine, however when I open the Folders using hyperlink, the path to the folders in the...

Someone suggested that I use an unbound form and Dcount function, can anyone guide me on how this can be done

Folks, I want to design a form that looks like the following (see attached) At intersection of each row and column I want to display the result of a query. at intersection of visas and 15 days I am displaying result of following query. SELECT Count(*) AS [No Of Visas Expiring in Next 15...

Hi Folks, I have a client table, in which I have an attribute called photo (datatype OLE object). Subsequently in the client form I have dragged this field and placed it on the form. I can right click on the box for photo and insert object (I store in this OLE object and link to client...

Thanks, Works well

Folks, Is it possible to create a subform within another subform. Main form -- Client Subform Dependent Further subforms of dependents - Medicals, Police Clearance, Qualifications. My client form shows dependent data, but the subforms within dependents turn out to be either totally blanks...

Reply: Linked Tables Refresh Thanks, Works like a dream :D

Thanks for the suggestions. I used the Me.Requery behind a button and it works well. However when I use On_Timer & Timer_Interval things to a bit ackward. Timer_Interval = 30000 On_Timer = Me.Requery When I am entering some notes for customer number 220, and while in the middle of typing...

Reply: Linked Tables Refresh and where should I insert this code? On some event in the main form? or create a button and put hte code behind the button.

I how do I achieve that? I am not very conversant with VB :confused:

Folks, I have a database with front of each user (about 15) and a backend that sits on Windows SBS 2008. The issue I am facing is that when one user inserts a new record in the database, the other users who already have the database open on their machines cannot view it. Either the others...