Search results for query: *

Just wanted to post back my findings. The issue was because I was using a sendkeys command and with the window running in the background, the sendkeys object was not working right. I revised my script to have a simple FTP batch file separate from this other process I wrote to gather the data...

I have a bat file that is using a "send keys" object. I am trying to automate this but when I put it in the scheduler for Windows 2000, it is ONLY RUN AS A BACKGROUND PROCESS. For XP, it seems like it is run as a foreground process. Is there a way I can create the job so that its run in the...

No actually, because in the script, I am authorizing under a different password and user ID anyway. I can run the job fine manually also as the same account I am running the scheduler's "run as

Here's one that has our whole company stumped. We cannot figure this out for the life of us. Any assistance would be appreciated. We have all Win 2000 servers, and I am trying to place a vbs script that creates a text file from a database and ftp's it to our main server. The process works fine...

Right, but my problem isnt importing the data, but its that I have a record in excel and I'm trying to insert part of that record in table1 and part of that record in table2... The issue is because there is an Autonumber key link (which is our ordernumber field between Table1 (orders) and 2...

Pardon my ignorance, but what's DTS and how can I use it?

Maybe I'm having a brain disfunction, but I'm just trying to map this out in my mind...Seems simple enough tho... I have some records in Excel that have certain columns belonging to two different tables that I need to import into a SQL server database. For example Col1, Col2 go in Table1, and...

Ah ok will do...I guess I was just in this mind set because I have a SQL server back end with an access front end... I'll repost over there...Thanks!!!

import FROM excel into Access, excuse the above post.

Oh I just have some data with a couple hundred records I need to import into Excel.

Maybe I'm having a brain disfunction, but I'm just trying to map this out in my mind...Seems simple enough tho... I have some records in Excel that have certain columns belonging to two different tables that I need to import into a SQL server database. For example Col1, Col2 go in Table1, and...

A laptop was stolen about a month ago at work - had to be a co worker because its on a secure floor...I had to file a police report etc. Anyway, Just to check i thought I would see if pinging the computer would help...if it was still around on the LAN. I wrote a small .bat program i would...

Hi, I was just wondering if any one has any familiarity with running an export to Excel automatically (perhaps on an ONOPEN function in VB) from a Business objects report upon running? The client I am writing this for is basically using BO as a data extraction tool and would really just like...

Right. I see that I can use CTRL-F to find but the option to 'FIND FIRST' button is not there. There used to be a 'FIND FIRST' button above the 'FIND NEXT' button. Its not essential I just wondered about it. Thanks!

I just hit CTRL-F and above the Find Next button there was a Find First.

I have converted a Access 97 database to Access 2000. When finding records in my form, there used to be an option to "Find First" record or find the first occurrance. Access 2000 doesn't seem to have this option any longer. Am I missing something like a disabled option or anything?

Great I'll try it Thanks so much.... That is just the SQL generated from the Query View in Access 2000. I guess the right join is necessary because of the way the tables are shown on the map in the query. I can rearrange it and play with it though. See i had read somewhere that when using SQL...

I have a very slow query left still: SELECT [Insertion Orders].[Publication Name], [Insertion Orders -- Line Items].[Invoice#], Publications.District, Sum([Insertion Orders -- Line Items].[Ad Rate]) AS [SumOfAd Rate], [Media Plans].[Cost Center], [Media Plans].[MITS Code], [Insertion...

I found a resolution to this. I created a table with a 2 columns - 1 Autonumber and another the Year field I am validating against on SQL server. I just update where the records has autonumber of 1 and use it as a temporary variable. You obviously cannot bring over form data variables to...

Thanks - That seems like a best fit I think too. I thought about doing that but wasnt sure if that was best practice or what. The only trouble I'm having now is a syntax error with my last statement: ((([Insertion Orders -- Line Items].[Invoice#]) Is Not Null) AND ((Mid([Insertion...