Search results for query: *

Hello, I have configured multiple templates for purchase order printing. Our goal is to have one PO template set up for Goods purchased and one PO template set up for Services purchased because they would have different Terms and Conditions at the end of the PO. Is there a way to select...

Yes sir Mr. SQLBill! We have regularly scheduled backups in place already. This SQL Express was placed on a client machine for performance reasons and somehow got over looked by our network admin backup team, probably because this was supposed to be a temporary solution. Thanks for your input...

Qik3Coder, Thanks for the response, but we figured out a solution for this one. We did have a full backup from about a year ago. I made a new blank test database. I restored the year old backup into this test db with the "RESTORE WITH NORECOVERY" option. We then did a transaction log backup...

I have a SQL Express 2005 production database that has never been backed up. A user accidentally deleted several key tables. Is there any tool like APEXSql that can recover the tables and all data? The trial version of APEXSql only recovers every 10th row. The license for APEXSql is very...

I resolved this myself with a SharePoint workflow. I removed the form submit e-mail and added the workflow that sends the e-mail when a new item is created in the SharePoint library. Thanks, T-Tops

I have an InfoPath form (Office 2010) on a SharePoint 2007 Server. When this form is submitted, a file is saved to a SharePoint library, a new unique ID is created for the file in the library and an e-mail is sent to an Exchange group. How can I capture the newly created ID and display it to the...

Hello, I have a Microsoft Access ADP project that was under source control in VSS. Our organization made the decision to move to Team Foundation Server and VSS is no longer available. When I open the adp file, I get an error message stating that states "The remote name could not be...

I meant for the subject of this post to be "SQL and Exchange on Windows Server 2003". This server has Service Pack 2. My apologies for the oversight. Thanks, T-Tops

I have a SQL Server 2005 Express database that is being touched by Microsoft Access and VBA code written inside AutoCAD 2009. I am having trouble with this database becoming very sluggish and eventually freezing. It seems that when I log onto the server with an administrative account, the...

What I mean is that I can log on as an administrator to the SQL Server using RDP from any machine and do nothing else and the performance of the SQL database improves vastly. I gave the user permission to RDP to the SQL Server with a non-administrative account and the performance is still...

I don't use disconnected recordsets and auto-close is set to false. This behavior seems to suggest that when I (or anyone else) log on as an administrator, it "wakes up" something on the server or in the SQL service. This server is also running Exchange Server 2007. Thanks, T-Tops

I have a SQL Server 2005 Express database that is being touched by Microsoft Access and VBA code written inside AutoCAD 2009. I am having trouble with this database becoming very sluggish and eventually freezing. It seems that when I log onto the server with an administrative account, the...

Hello All, I am trying to capture (with VBA code) the object that is being deleted when the user presses the Delete key on his/her keyboard. When I write any code in the AcadDocument_ObjectErased event, the object is gone by the time any code executes. I can retrieve the ObjectID of the...

Hello, I am getting the following error message in Great Plains Integration Manager: "Cannot access a disposed object. Object name: frmRelationships". I am stuck there. Does anyone have any suggestions. Thanks, T-Tops Thanks, T-Tops

One of my remote users is getting intermittent blue screens of death. Upon restart, a pop up window appears saying that Windows shut down unexpectedly. I clicked on the Details button and got the following information: ****************************************************** Problem signature...

Since my original post, I have made some progress. I have written the following VBA code: **************************************** Private Const RootPath As String = "LDAP://dc=MyOrganizationDomainName,dc=com" Private Sub cmdGetADInfo_Click() Const ADS_SCOPE_SUBTREE = 2 Dim conn...

I have an Access 2007 form that retrieves its data from an Access 2007 table. I would like to save some of the form's fields (First Name, Last Name, Department, Address, etc.) to Active Directory as well. I know this can be done with VBA code, but I've never been tasked with this before. Can...

I have an Access 2007 form that retrieves its data from an Access 2007 table. I would like to save some of the form's fields (First Name, Last Name, Department, Address, etc.) to Active Directory as well. I know this can be done with VBA code, but I've never been tasked with this before. Can...

That fixed it...thanks, Genomon. Thanks, T-Tops

I found my own answer. A stored procedure that runs before all the code I provided earlier was locking the table because I was returning a value before reaching the "Commit" statement. This was my own fault, but thanks for the response, markros. Thanks, T-Tops