Search results for query: *

I was wondering if there was a way to run multiple SQL Statements in Access like you can in SQL. I have a bunch of steps that I would like to combine in one script. Thanks Mike

There may be a very simple solution to this that I am just missing. I am linking a text file into access. I have a date field that comes in as 11/1/2004. I am trying to populate a table with this date field but I would like for it to be displayed as 11/01/2004. I have tried playing with this...

I am running a update query and am getting a Numeric field overflow message. I have checked the size of the 9 fields I am trying to upload to with the location the data is coming from. And they are identical. The weird thing is if i open up the query in design view, delete a field and then add...

I have a table with transactions. My transactions have 3 main fields that I am concerned with: Transaction number, Status, and Acct Number. If a transaction was made and then cancelled it would look like this: Trans# Status Acct Number 0001 Processed 12345 0001 Cancelled...

I am having a problem with an update query. Everytime I run this query: UPDATE STATESTREETRECON SET STATESTREETRECON.CUSIP = "CASH" WHERE STATESTREETRECON.CUSIP = CASHCODE.CODE I am prompted to Enter Parameter Value for CashCode.Code. I have about 30 different items listed under Code in the...

I am new to exchange. We just migrated over to exchange 2000. Since then, a few of the user's that i am supporting are getting the error Unable to update public free/busy data. The contents of this public folder are currently unavailable. Either the Microsoft Server computer servicing this...

Hello all. I am having a slight problem with the string function. I am trying to use the String funtion in conjunction with the convert function. What I would like to do is left justify a numerical value as a set Char lenght. When I try to use the convert (to Char) function without the str...

I have a trigger that is run everyday that updates a table. I would like to automatically save the contents of that table to a file. Is there anyway to write that into a script? Also when I save a file manually to a csv file I always get commas to seperate columns, is there any way that i can...

I have the constant task of producing flat files with fixed widths. I would like to know is there a way that I can create fixed widths in SQL no matter the length of the data in the record. For example if I have a name column that is 20 spaces, and enter in a name that is 11 spaces, I would...

There is probably a very simple solution to what I am trying to. I am just trying to pull data from a Header and set it to a variable of type String. I have tried many different ways of doing it but nothing seems to work for me. Could you please advise?

I have a job Scheduled to run using the SQL Server Agent Jobs. Besides just scheduling the job to run and having it run automatically I would like to know if this job (not the script under the job) can also be run from the command line. In other words how can or can I write an ISQL statement...

I have to remove the last page of a document. I have tried to use commands such as selection.delete but that ony seems to remove the page contents and not the page. Can anyone give some input as to what may work?? Thanks

I have to automate a mailmerge process but I am unsure how to get started. Can anyone point me in the right direction to get started. I have to produce a mail merge from an excel document. It will be the same excel document every month. Thanks Mike

I am new to DB Administration. I have a database that I Dump and restore to another server nightly (7PM). I have hourly transactions that are backed up and restored hourly from 7am - 6pm. My 7am transaction log is always considerably larger that the others throughout the day. I a 500KB...

I have written a vba macro that seperates a letter mail merge and saves each letter into its own document. My macro runs after the merge is complete. Once the merge is completed my macro breaks up the file and saves each letter as a single word document. What I would like to do is pull one...

How to you call an external program from VBA. And when you do not need it anymore how do you close it? Thanks

I do not know if this is posible using VBA, but I have a document in word that I would like to send to the same recipients every month, how can I send it. I would be sending it utilizing outlook. Thanks

How do you read in Page Breaks using VBA for Word. I have to select the contents between each page break. Can anyone give me a hand?? Thanks

I have my own pc that I have in my room. No one uses it except me. I had 5 GB left in my hard drive earlier today. But in the evenining I have only 64 Kb left. I have nothing left! I removed 15 mb of files in my computer, so then I checked out the c drive to see amount of space left. It said 15...

I have my own pc that I have in my room. No one uses it except me. I had 5 GB left in my hard drive earlier today. But in the evenining I have only 64 Kb left. I have nothing left! I removed 15 mb of files in my computer, so then I checked out the c drive to see amount of space left. It said 15...