Search results for query: *

Hi all I am attempting to create an SSIS package that uses data from SQL Server to automatically create letters. It all works fine except for when I try to change the active printer (oWord.ActivePrinter = Default_printer). At this point I get an error. I have used the same code in a VB.net...

Hi All I have the following code to transfer objects to other access databases. I have created a form to provide the necessary information such as object type, name, destination to make it easy just to select the options and then transfer the selected database objects. DoCmd.TransferDatabase...

Hi all This is really strange. I have the following code in an 'on click' sub to open up a form on an access database. But as soon as the database opens and loads the form it then shuts down. I can't see why and no other code is running and there are no macros on the database. If I open the...

Hi all This is strange and I can't see why it is happening, probably something stupid. I have a VB project that Ive just started trying to use in XP (build in NT4). Functions such as String$, Date, Left$, right$, space$, etc will not work. It just keeps giving complie errors. Does anyone know...

Hi all Does anyone know how to get a mailto to send of automatically, in other words not pop up for the user to amend and send. The reason I want to do this is because on our intranet we have a link that sends a mail to a mailbox and replies with another e-mail that has an attachment with a...

HI all I am using the following code to create a table: Set dbs = CurrentDb Set tdf = dbs.CreateTableDef(tabname) Set fld = tdf.CreateField("system", dbText, 30) tdf.Fields.Append fld Set fld = tdf.CreateField("Potential_Availability", dbText, 30) tdf.Fields.Append fld...

This is very complex and so Im not quite sure how to describe it properly so forgive me if its not understandable and please feel free to ask any questions. All comments and ideas are greatly appreciated. I am creating a database to capture outages on our computer systems. The way it works is...

Hi I have a database which creates a excel spreadsheet. I want to be able to format the colours of the spreadsheet cells fo rthe background and font. However the tricky bit is if there is data in a cell within a given range I want it to be one set of colours and where there is no data I want to...

Hi all Heres a Brain teaser: I have a spreadsheet that I copy through code and then edit the copy and delete the macros. The reason I want the macros delted on the copy is because I am sending it over e-mail and some of the exhange servers of the people I am sending it to do not allow VB code...

Hi all is there a way I can make an excel spreadsheet resize to fit the screen resolution on the PCit is being opened on. This is because the users who will pick up this spreadsheet have varying resolutions. Thanks Tim

Hi all I don't know if this is possible but I hope it is. What format could I use or is there a setting so that decimal places only appear for decimal numbers? E.g. I am using percentages and in some case it could be 95%, 100% in other cases it might be 99.98, 98.23 If it is a whole number...

Hi All I want to transfer data from one workbook to another picking out certain cells. I am trying to avoid the old copy and paste functions and just use something like this: Workbook1.sheet1.Range("C32") = Workbook2.sheet1.Range("B52") But I cannot get anything to work. Can anyone help...

Hi all Here is my code: Dim workbooks As Document Dim xlApp As Object Dim workbook As Object Set xlApp = CreateObject("excel.application") xlApp.Visible = False Set workbook = xlApp.workbooks.Open("C:\AWARD_PROFILES.xls") xlApp.Visible = True Set sheet =...

Hi i am trying to import a number of csv files using the following code: StrSql = "SELECT Functions.Order, Functions.Function AS func FROM Functions WHERE (((Functions.Function)<>'SQLdwndone')) " & _ "ORDER BY Functions.Order;" Set db = CurrentDb Set rst = db.OpenRecordset(StrSql...

Hi all I don't know if this is possible and if it is I can't figure it out. I have a list of functions in fields of a table. I want to call these dependant on the result of an SQL. How do I call a function when I am pulling the name of the function from the table as a string? I don't really...

Hi all I have opened an application using the shell command. What I want to be able to do now is at a later point in my code force the application to close. Is this possible? If so how? All help and advise is greatly appreciated Many Thanks Tim

Hi All I have created a vb script in PCOMM which logs on and pulls back data from an AS400. What I want it to do is to take data from an ini file which contains the username and password to logon. Here is the ini: [Logon_Details] userid=user1 password=password1 My code is below [PCOMM...

Hi all I have created a vb script that starts a program called PCOMM and runs a macro in that program which is written in VBscript to process certain actions. It then closes down and the Access database detects when it closes and then processes other actions. There are currently 2 occasions...

Hi I am trying to open a standard mail from a network drive just using a shortcut button in access using VB. Whenever it opens though the mail is an attachment in a new mail. How do I get it just to open. Here is my code: Dim X X = Shell("Outlook.exe...

Hi All Im trying to transfer data into a spreadsheet. I am selecting the data using getrows, the problems is that the data seems to move around. i.e. the coloumns in the table become rows and the rows become coloumns. I want the data to be in the same order as in the table. Here is my coding...