Search results for query: *

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

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

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

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

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

I am trying to export a report over and over again with code. The report is based on a query that contains a parameter. I fill the parameter by scrolling through a recordset. The report is suppose to export itself after each record change. My problem is that my paremeter is not getting set...