Recent content by Dan8376

I've already installed SP1 for all of my office 2007 machines. Right now my most effiecent work around is having the user perform a compact and repair of the database. For some reason this allows everything to calculate in a timely manner.

In my office we have people with access 2003 and access 2007. We have a database that is split with the back end on SQL Server 2005 and the front end is an ADP Access 2002-2003 file format. For the users with access 2003 everything works great and has been for the last few years. For the...

Hi, I'm trying to import a Paradox file into my database, but I'm getting the following error: Run-time error '3044': 'O:\DATA\ACCESS\TG070723.DB' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Here is...

I am working with a SQL Server database and I have an an Acess 2000 front-end ADP, on an XP Prof computer. I'm having a problem trying to edit records in one of my forms that is based on the following stored procedue: ALTER Procedure qryCustCompany1 (@CustCode nvarchar(10)) As SELECT...

Ajent, I had the same problem with a new computer running XP and SP2. I could connect to the internet directly to my cable modem, but I could not get an ip from my router when I had that connected. Your post solved my problem. Thanks

Trevor, I don't think I did. This was a long time ago, at a different job. Sorry. Dan

That made it work. Thanks Chris.

I'm having a problem running a macro from a command button in Excel. I have this procedure that I want to run from the click of a button. The procedure runs great if I run it from the VB window or the immeadiate window. When I try to run it by clicking on a command button, I get the run time...

Yes, I was able to quickly identify the error and replace set with Dim. Thanks again

Wow, within 5 minutes you replied with a solution. Thanks for solving my problem. Thanks PH.

I'm trying to open up a tif file with VB from an access form. I'm using the GetObject function, but I don't know the class name for the Windows Picture and Fax Viewer. (This is the default program to open TIF files with the Microsoft XP operating sysytem) Here's what I'm trying right now, but...

Here's the code, I have a sub that creates all of my reports. I call this sub from many different procedures, when I try and call this sub twice during the same procedure it errors. 'Print Sub Sub SendReportToFile(ReportID As Long) Dim db As DAO.Database Dim rs1 As DAO.Recordset Dim rs2 As...

To automate PDF creation using Adobe Writer you need to do the following steps. (All of these steps below can be automated with VB) 1. Change your default printer to Adobe Writer 2. Open your WIN.ini file, there should be a referece to the "Acrobat PDFWriter", set the PDFFileName=...

I get the following error when I output two or more files in the same procedure when the database window is hidden. Run-time error '2406' The command or action 'OutputTo' isn't available now If the database window is viewable then my code works fine, but when I try to "secure" the...

Bill, Your query is a parameter query. Set your parameters in your SQL statement, then get your dates. Try this: Private Sub Report_Open(Cancel As Integer) Dim db As Database Dim rs As Recordset Dim Date1 As Date Dim Date2 As Date Dim CompanyID As Long Dim dt as Date CompanyID =...