Search results for query: *

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

I've never encountered an error message like that when trying to send emails from Access. Try adding this before your code: Docmd.SetWarnings False Here is the code I use, Sub SendMailWithOutlook() '<< Add the Microsoft Outlook 9.0 Object Library to your VB references >> '<< The number may...

I don't know what could be causing that error. Make sure that you have Microsoft Outlook open when you run your procedure. Also make sure you added the Microsoft Outlook 9.0 Object Library, in your VB References. Try this code. Its the same as above without all the extra lines. I will know...

I'm going to assume you have Microsoft Outlook since you are using Microsoft Access. If you don't have Outlook then this won't help you so stop reading. Add the Microsoft Outlook 9.0 Object Library (note: your number could be different depending on your version of Office) Put this code in a...

Matt, That helped me figure out my problem. Thanks Dan

Hi, I want to delete all sheets with a name length of 5. I'm having problems with the vb syntax for excel. I know it should be something like this. set wb = ActiveWorkbook set sht = Sheets For Each sht in wb If len(sht.Name) = 5 Then sht.Delete End if Next Thanks Dan